77Frequently Asked Questions (FAQ) for PostgreSQL
88</ H1 >
99< P >
10- Last updated:Fri Jun 2 11:32:13 EDT 2000
10+ Last updated:Wed Jul 26 13:33:21 EDT 2000
1111< P >
1212Current maintainer:Bruce Momjian (< A
1313HREF ="mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ A > )< BR > < P >
1616< A HREF ="http://www.Postgresql.org/docs/faq-english.html ">
1717http://www.PostgreSQL.org/docs/faq-english.html</ A > .< P >
1818
19- Linux-specific questions are answered in< A
20- HREF ="http://www.PostgreSQL.org/docs/faq-linux.html "> http://www.PostgreSQL.org/docs/faq-linux.html</ A > .< P >
21-
22- HPUX-specific questions are answered in< A
23- HREF ="http://www.PostgreSQL.org/docs/faq-hpux.html "> http://www.PostgreSQL.org/docs/faq-hpux.html</ A > .< P >
24-
25- Solaris-specific questions are answered in< A
26- HREF ="http://www.PostgreSQL.org/docs/faq-solaris.html "> http://www.PostgreSQL.org/docs/faq-solaris.html</ A > .< P >
27-
28- Irix-specific questions are answered in< A
29- HREF ="http://www.PostgreSQL.org/docs/faq-irix.html "> http://www.PostgreSQL.org/docs/faq-irix.html</ A > .< P >
19+ Platform-specific questions are answered at< A
20+ HREF ="http://www.PostgreSQL.org/docs/ "> http://www.PostgreSQL.org/docs/</ A > .< P >
3021
3122< HR > < P >
3223
@@ -115,7 +106,7 @@ <H2><CENTER>Operational Questions</CENTER></H2>
115106< A HREF ="#4.12 "> 4.12</ A > ) What is Genetic Query Optimization?< BR >
116107
117108< A HREF ="#4.13 "> 4.13</ A > ) How do I do regular expression searches
118- and case-insensitive regular expressionsearching ?< BR >
109+ and case-insensitive regular expressionsearches ?< BR >
119110< A HREF ="#4.14 "> 4.14</ A > ) In a query, how do I detect if a field
120111is NULL?< BR >
121112< A HREF ="#4.15 "> 4.15</ A > ) What is the difference between the
@@ -169,7 +160,7 @@ <H4><A
169160PostQuel query language with an extended subset of SQL. PostgreSQL is
170161free and the complete source is available.< P >
171162
172- PostgreSQL development isbeing performed by a team of Internet
163+ PostgreSQL development is performed by a team of Internet
173164developers who all subscribe to the PostgreSQL development mailing list.
174165The current coordinator is Marc G. Fournier (< A
175166HREF ="mailto:scrappy@PostgreSQL.org "> scrappy@PostgreSQL.org</ A > ). (See
@@ -252,13 +243,13 @@ <H4><A NAME="1.3">1.3</A>) What Unix platforms does PostgreSQL run
252243
253244< H4 > < A NAME ="1.4 "> 1.4</ A > ) What non-unix ports are available?</ H4 > < P >
254245
255- It is possible to compile the libpq C library, psql, and other
246+ It is possible to compile the< I > libpq</ I > C library, psql, and other
256247interfaces and binaries to run on MS Windows platforms. In this case,
257248the client is running on MS Windows, and communicates via TCP/IP to a
258249server running on one of our supported Unix platforms.< P >
259250
260251A file< I > win31.mak</ I > is included in the distribution for making a
261- Win32 libpq library and psql.< P >
252+ Win32< I > libpq</ I > library and psql.< P >
262253
263254The database server is now working on Windows NT using the Cygnus
264255Unix/NT porting library. See< I > pgsql/doc/FAQ_NT</ I > in the distribution.< P >
@@ -272,7 +263,7 @@ <H4><A NAME="1.5">1.5</A>) Where can I get PostgreSQL?</H4><P>
272263
273264< H4 > < A NAME ="1.6 "> 1.6</ A > ) Where can I get support?</ H4 > < P >
274265
275- There is noofficial support for PostgreSQL from the University of
266+ There is no support for PostgreSQL from the University of
276267California, Berkeley. It is maintained through volunteer effort.< P >
277268
278269The main mailing list is:< A
@@ -531,8 +522,7 @@ <H4><A NAME="2.2">2.2</A>) What tools are available for hooking
531522For web integration, PHP is an excellent interface. It is at
532523< A HREF ="http://www.php.net "> http://www.php.net</ A > < P >
533524
534- PHP is great for simple stuff, but for more complex cases, many
535- use the perl interface and CGI.pm.< P >
525+ For complex cases, many use the perl interface and CGI.pm.< P >
536526
537527A WWW gateway based on WDB using perl can be downloaded from< A
538528HREF ="http://www.eol.ists.ca/~dunlop/wdb-p95 "> http://www.eol.ists.ca/~dunlop/wdb-p95</ A >
@@ -553,15 +543,15 @@ <H4><A NAME="2.4">2.4</A>) What languages are available to
553543
554544We have:
555545< UL >
556- < LI > C(libpq)
557- < LI > C++(libpq++)
558- < LI > Embedded C(ecpg)
559- < LI > Java(jdbc)
560- < LI > Perl(perl5)
561- < LI > ODBC(odbc)
562- < LI > Python(PyGreSQL)
563- < LI > TCL(libpgtcl)
564- < LI > C Easy API(libpgeasy)
546+ < LI > C (libpq)
547+ < LI > C++ (libpq++)
548+ < LI > Embedded C (ecpg)
549+ < LI > Java (jdbc)
550+ < LI > Perl (perl5)
551+ < LI > ODBC (odbc)
552+ < LI > Python (PyGreSQL)
553+ < LI > TCL (libpgtcl)
554+ < LI > C Easy API (libpgeasy)
565555< LI > Embedded HTML (< A HREF ="http://www.php.net "> PHP from http://www.php.net</ A > )
566556</ UL > < P >
567557
@@ -783,7 +773,7 @@ <H4><A NAME="3.13">3.13</A>) What are the <I>pg_sorttempNNN.NN</I> files in my
783773the sort requires more space than the backend's< I > -S</ I > parameter allows,
784774then temporary files are created to hold the extra data.< P >
785775
786- Thetemp files should be deleted automatically, but might not if a backend
776+ Thetemporary files should be deleted automatically, but might not if a backend
787777crashes during a sort. If you have no backends running at the time,
788778it is safe to delete the pg_tempNNN.NN files.< P >
789779
@@ -977,7 +967,7 @@ <H4><A NAME="4.12">4.12</A>) What is Genetic Query
977967non-exhaustive search.< P >
978968
979969< H4 > < A NAME ="4.13 "> 4.13</ A > ) How do I do regular expression searches and
980- case-insensitive regular expressionsearching ?</ H4 > < P >
970+ case-insensitive regular expressionsearches ?</ H4 > < P >
981971
982972The< I > ~</ I > operator does regular-expression matching, and< I > ~*</ I >
983973does case-insensitive regular-expression matching. There is no
@@ -1231,7 +1221,7 @@ <H4><A NAME="5.3">5.3</A>) How can I contribute some nifty new types and
12311221functions to PostgreSQL?</ H4 > < P >
12321222
12331223
1234- Send your extensions to the pgsql-hackers mailing list, and they will
1224+ Send your extensions to the< I > pgsql-hackers</ I > mailing list, and they will
12351225eventually end up in the< I > contrib/</ I > subdirectory.< P >
12361226
12371227