There are two ODBC drivers available, PsqlODBC and OpenLink ODBC.
PsqlODBC is included in the distribution. More information about it can be gotten from:
ftp://ftp.PostgreSQL.org/pub/odbc/OpenLink ODBC can be gotten from http://www.openlinksw.com. It works with their standard ODBC client software so you'll have POSTGRESQL ODBC available on every client platform they support (Win, Mac, Unix, VMS).
They will probably be selling this product to people who need commercial-quality support, but a freeware version will always be available. Questions to [email protected].
See also the ODBC chapter of the Programmer's Guide.
A nice introduction to Database-backed Web pages can be seen at http://www.webtools.com.
There is also one at http://www.phone.net/home/mwm/hotlist/.
For Web integration, PHP is an excellent interface. It is at http://www.php.net
For complex cases, many use the Perl interface and CGI.pm.
A WWW gateway based on WDB using Perl can be downloaded
from
http://www.eol.ists.ca/dunlop/wdb-p95.
We have a nice graphical user interface called pgaccess , which is shipped as part of the distribution. Pgaccess also has a report generator. The Web page is http://www.flex.ro/pgaccess.
We also include ecpg , which is an embedded SQL query language interface for C.
We have: