7
7
Frequently Asked Questions (FAQ) for PostgreSQL
8
8
</ H1 >
9
9
< P >
10
- Last updated:Fri Jun 2 11:32:13 EDT 2000
10
+ Last updated:Wed Jul 26 13:33:21 EDT 2000
11
11
< P >
12
12
Current maintainer:Bruce Momjian (< A
13
13
HREF ="mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ A > )< BR > < P >
16
16
< A HREF ="http://www.Postgresql.org/docs/faq-english.html ">
17
17
http://www.PostgreSQL.org/docs/faq-english.html</ A > .< P >
18
18
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 >
30
21
31
22
< HR > < P >
32
23
@@ -115,7 +106,7 @@ <H2><CENTER>Operational Questions</CENTER></H2>
115
106
< A HREF ="#4.12 "> 4.12</ A > ) What is Genetic Query Optimization?< BR >
116
107
117
108
< 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 >
119
110
< A HREF ="#4.14 "> 4.14</ A > ) In a query, how do I detect if a field
120
111
is NULL?< BR >
121
112
< A HREF ="#4.15 "> 4.15</ A > ) What is the difference between the
@@ -169,7 +160,7 @@ <H4><A
169
160
PostQuel query language with an extended subset of SQL. PostgreSQL is
170
161
free and the complete source is available.< P >
171
162
172
- PostgreSQL development isbeing performed by a team of Internet
163
+ PostgreSQL development is performed by a team of Internet
173
164
developers who all subscribe to the PostgreSQL development mailing list.
174
165
The current coordinator is Marc G. Fournier (< A
175
166
HREF ="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
252
243
253
244
< H4 > < A NAME ="1.4 "> 1.4</ A > ) What non-unix ports are available?</ H4 > < P >
254
245
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
256
247
interfaces and binaries to run on MS Windows platforms. In this case,
257
248
the client is running on MS Windows, and communicates via TCP/IP to a
258
249
server running on one of our supported Unix platforms.< P >
259
250
260
251
A 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 >
262
253
263
254
The database server is now working on Windows NT using the Cygnus
264
255
Unix/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>
272
263
273
264
< H4 > < A NAME ="1.6 "> 1.6</ A > ) Where can I get support?</ H4 > < P >
274
265
275
- There is noofficial support for PostgreSQL from the University of
266
+ There is no support for PostgreSQL from the University of
276
267
California, Berkeley. It is maintained through volunteer effort.< P >
277
268
278
269
The main mailing list is:< A
@@ -531,8 +522,7 @@ <H4><A NAME="2.2">2.2</A>) What tools are available for hooking
531
522
For web integration, PHP is an excellent interface. It is at
532
523
< A HREF ="http://www.php.net "> http://www.php.net</ A > < P >
533
524
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 >
536
526
537
527
A WWW gateway based on WDB using perl can be downloaded from< A
538
528
HREF ="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
553
543
554
544
We have:
555
545
< 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)
565
555
< LI > Embedded HTML (< A HREF ="http://www.php.net "> PHP from http://www.php.net</ A > )
566
556
</ UL > < P >
567
557
@@ -783,7 +773,7 @@ <H4><A NAME="3.13">3.13</A>) What are the <I>pg_sorttempNNN.NN</I> files in my
783
773
the sort requires more space than the backend's< I > -S</ I > parameter allows,
784
774
then temporary files are created to hold the extra data.< P >
785
775
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
787
777
crashes during a sort. If you have no backends running at the time,
788
778
it is safe to delete the pg_tempNNN.NN files.< P >
789
779
@@ -977,7 +967,7 @@ <H4><A NAME="4.12">4.12</A>) What is Genetic Query
977
967
non-exhaustive search.< P >
978
968
979
969
< 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 >
981
971
982
972
The< I > ~</ I > operator does regular-expression matching, and< I > ~*</ I >
983
973
does 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
1231
1221
functions to PostgreSQL?</ H4 > < P >
1232
1222
1233
1223
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
1235
1225
eventually end up in the< I > contrib/</ I > subdirectory.< P >
1236
1226
1237
1227