SQL Database Access - PostgreSQL
The name of the PostgreSQL driver to be passed to SQL.Databases.Create subprogram is "POSTGRESQL".
Driver accepts all options described in PostgreSQL documentation.
PostgreSQL module is built automatically when PostgreSQL package is installed. Automatic configuration facility use pg_config tools to check whether package is installed and to obtain required switches. When automatic configuration is unable to detect PostgreSQL libraries and linker switches, it is possible to specify path to libraries in the command line of configure (or configure.exe on Windows) program with --with-postgresql-libdir switch, for example:
On many Linux systems postgresql-devel package has incomplete dependencies set. As result, automatic configuration facility is unable to find requires switches. To resolve this issues run
and check that development packages are installed for all packages which containing reported set of libraries. Usually
pam-devel krb5-devel libxslt-devel
packages must be installed.