Package Modeling.DatabaseAdaptors.PostgresqlAdaptorLayer

PostgresqlAdaptorLayer

This package is for use by the core to interact with PostgreSQL databases.

Three different low-level DB-adaptors, conforming to the python DB-API 2.0, can be used, and by default theyu are searched in the following order:

• 'psycopg', if available, will be used,
• then 'pygresql' (pgdb), if available, is used,
• otherwise, 'PyPgSQL' is searched and used.

If more than one of these adaptors are installed, you can set the environment variable 'MDL_PREFERRED_PYTHON_POSTGRESQL_ADAPTOR' to either 'psycopg', 'pgdb' or 'pypgsql' to indicate your preference.

Model & Connection Dictionaries:

'adaptorName' -- should be 'Postgresql'

'database' -- the name of the database

'host' -- where the pg server is hosted

'user', 'password' -- user credentials

'port' -- optional; the port to which the database server listens to

Supported SQL datatypes are:

VARCHAR, CHAR, TEXT, FLOAT, INT, INTEGER, NUMERIC, DATE, TIME, DATETIME, TIMESTAMP, TIMESTAMP WITHOUT TIME ZONE, TIMESTAMP WITH TIME ZONE

Note: postgresql v7.3+ does not support DATETIME anymore.