10. Hints and tips¶

10.1. Connect psql to your plugin database¶

In order to easelly run the PostgreSQL interactive terminal psql on your plugin database, from your MFBASE plugin directory, issue

the plugin_env command
then the base command.

e.g. from the foo MFBASE plugin:

plugin_env

Output:

          __  __      ___          __        _
          |  \/  |    |        / /       | |
          |  / | ___| | / / /__  _ __| | __
          | |\/| |/ _ __\ \/  \/ / _ \| '__| |/ /
          | |  | |  __/ |_  / / (_) | |  |   <
          |_|  |_|\___|\__| \/  \/ \___/|_|  |_|\_\


Welcome on xxx (xxx, xx.xx.xx.x)
(module: MFBASE, version: xxxx)

 13:50:24 up 15 days, 21:31,  4 users,  load average: 0.47, 0.38, 0.27

base

psql (10.1)
Type "help" for help.

plugin_foo=>

Then you are able to type in queries interactively, issue them to PostgreSQL, and see the query results

Note

If you enter the base command without first entering the plugin_env command, you will be connect to the Metwork PostgreSQL template database.

10.2. PostGIS and MapServer¶

If you want to make MapServer query calls to a PostGIS layer of your database, you should be interested in some Metwork libraries and sets of tools close to Mapserver.