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

NameLanguageCommentsWebsite
DBD::PgPerlPerl DBI driverhttp://search.cpan.org/dist/DBD-Pg/
JDBCJDBCType 4 JDBC driverhttp://jdbc.postgresql.org/
libpqxxC++New-style C++ interfacehttp://pqxx.org/
Npgsql.NET.NET data providerhttp://npgsql.projects.postgresql.org/
pgtclngTcl http://sourceforge.net/projects/pgtclng/
psqlODBCODBCODBC driverhttp://psqlodbc.projects.postgresql.org/
psycopgPythonDB API 2.0-complianthttp://initd.org/psycopg/