1010alink ="#0000ff ">
1111< H1 > Frequently Asked Questions (FAQ) for PostgreSQL</ H1 >
1212
13- < P > Last updated:Sun Oct 20 20 :47:14 EDT 2002</ P >
13+ < P > Last updated:Thu Dec 5 00 :47:26 EST 2002</ P >
1414
1515< P > Current maintainer: Bruce Momjian (< A href =
1616 "mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ A > )< BR >
@@ -52,7 +52,6 @@ <H2 align="center">User Client Questions</H2>
5252< A href ="#2.2 "> 2.2</ A > ) What tools are available for using
5353 PostgreSQL with Web pages?< BR >
5454< A href ="#2.3 "> 2.3</ A > ) Does PostgreSQL have a graphical user
55- interface? A report generator? An embedded query language
5655 interface?< BR >
5756< A href ="#2.4 "> 2.4</ A > ) What languages are available to
5857 communicate with PostgreSQL?< BR >
@@ -507,9 +506,9 @@ <H4><A name="2.1">2.1</A>) Are there <SMALL>ODBC</SMALL> drivers
507506< P > There are two< SMALL > ODBC</ SMALL > drivers available, PsqlODBC
508507 and OpenLink< SMALL > ODBC</ SMALL > .</ P >
509508
510- < P > PsqlODBC is included in the distribution. More information about
511- it can be gotten from < A href =
512- " ftp ://ftp.PostgreSQL .org/pub/odbc/ " > ftp://ftp.PostgreSQL.org/pub/odbc/ </ A > .</ P >
509+ < P > You can download PsqlODBC from < A href =
510+ " http://gborg.postgresql.org/project/psqlodbc/projdisplay.php " >
511+ http ://gborg.postgresql .org/project/psqlodbc/projdisplay.php </ A > .</ P >
513512
514513< P > OpenLink< SMALL > ODBC</ SMALL > can be gotten from< A href =
515514 "http://www.openlinksw.com/ "> http://www.openlinksw.com</ A > . It
@@ -522,10 +521,6 @@ <H4><A name="2.1">2.1</A>) Are there <SMALL>ODBC</SMALL> drivers
522521 available. Please send questions to< A href =
523522 "mailto:postgres95@openlink.co.uk "> postgres95@openlink.co.uk</ A > .</ P >
524523
525- < P > See also the< A href =
526- "http://www.postgresql.org/devel-corner/docs/programmer/odbc.html "> ODBC
527- chapter of the Programmer's Guide</ A > .</ P >
528-
529524< H4 > < A name ="2.2 "> 2.2</ A > ) What tools are available for using
530525 PostgreSQL with Web pages?</ H4 >
531526
@@ -538,45 +533,49 @@ <H4><A name="2.2">2.2</A>) What tools are available for using
538533< P > For complex cases, many use the Perl interface and CGI.pm or mod_perl.</ P >
539534
540535< H4 > < A name ="2.3 "> 2.3</ A > ) Does PostgreSQL have a graphical user
541- interface? A report generator? An embedded query language
542536 interface?</ H4 >
543537
538+ Yes, there are several graphical interfaces to PostgreSQL available.
539+ These include PgAccess< a href ="http://www.pgaccess.com ">
540+ http://www.pgaccess.com</ a > ), PgAdmin II (< a
541+ href ="http://www.pgadmin.org "> http://www.pgadmin.org</ a > ,
542+ Win32-only), RHDB Admin (< a
543+ href ="http://sources.redhat.com/rhdb/ "> http://sources.redhat.com/rhdb/
544+ </ a > ) and Rekall (< a href ="http://www.thekompany.com/products/rekall/ ">
545+ http://www.thekompany.com/products/rekall/</ a > , proprietary). There is
546+ also PHPPgAdmin (< a href ="http://phppgadmin.sourceforge.net/ ">
547+ http://phppgadmin.sourceforge.net/</ a > ), a web-based interface to
548+ PostgreSQL.
549+
544550< P > We have a nice graphical user interface called PgAccess which can
545551 also be used as a report generator. The Web page is
546552< A href ="http://www.pgaccess.org/ "> http://www.pgaccess.org/</ A > .</ P >
547553
548- < P > We also include < I > ecpg </ I > , which is an embedded SQL query
549- language interface for C. </ P >
554+ < H4 > < A name =" 2.4 " > 2.4 </ A > ) What languages are able to communicate with
555+ PostgreSQL? </ H4 >
550556
551- < H4 > < A name ="2.4 "> 2.4</ A > ) What languages are able to communicate with PostgreSQL?</ H4 >
557+ < P > Most popular programming languages contain an interface to
558+ PostgreSQL. Check your programming language's list of extension
559+ modules.</ P >
552560
553- < P > We have:</ P >
561+ < P > The following interfaces are included in the PostgreSQL
562+ distribution:</ P >
554563
555564< UL >
556565< LI > C (libpq)</ LI >
557566
558- < LI > C++ (libpq++)</ LI >
559-
560567< LI > Embedded C (ecpg)</ LI >
561568
562569< LI > Java (jdbc)</ LI >
563570
564- < LI > Perl (DBD::Pg and perl5)</ LI >
565-
566- < LI > ODBC (odbc)</ LI >
567-
568571< LI > Python (PyGreSQL)</ LI >
569572
570573< LI > TCL (libpgtcl)</ LI >
571574
572- < LI > C Easy API (libpgeasy)</ LI >
573-
574- < LI > PHP ('pg_' functions, Pear::DB)</ LI >
575575</ UL >
576576< P > Additional interfaces are available at
577- < a href ="http://www.PostgreSQL.org/interfaces.html "> http://www.PostgreSQL.org/interfaces.html</ A >
578- and
579- < a href ="http://gborg.PostgreSQL.org "> http://gborg.PostgreSQL.org</ A > .
577+ < a href ="http://gborg.postgresql.org "> http://gborg.postgresql.org</ A >
578+ in the< I > Drivers/Interfaces</ I > section.
580579</ P >
581580< HR >
582581