select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2
Historical version. PostgreSQL 8.3 reached end of support in February 2013. See the current version for supported releases.

G.1. Client Interfaces

There are only two client interfaces included in the base PostgreSQL distribution:

  • libpq is included because it is the primary C language interface, and because many other client interfaces are built on top of it.

  • ecpg is included because it depends on the server-side SQL grammar, and is therefore sensitive to changes in PostgreSQL itself.

All other language interfaces are external projects and are distributed separately. Table G-1 includes a list of some of these projects. Note that some of these packages might not be released under the same license as PostgreSQL. For more information on each language interface, including licensing terms, refer to its website and documentation.

Table G-1. Externally Maintained Client Interfaces

Name Language Comments Website
DBD::Pg Perl Perl DBI driver http://search.cpan.org/dist/DBD-Pg/
JDBC JDBC Type 4 JDBC driver http://jdbc.postgresql.org/
libpqxx C++ New-style C++ interface http://pqxx.org/
Npgsql .NET .NET data provider http://npgsql.projects.postgresql.org/
pgtclng Tcl   http://sourceforge.net/projects/pgtclng/
psqlODBC ODBC ODBC driver http://psqlodbc.projects.postgresql.org/
psycopg Python DB API 2.0-compliant http://www.initd.org/

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.