@@ -29,12 +29,13 @@ Questions answered:
2929 1.8) What documentation is available for PostgreSQL?
3030 1.9) What version of SQL does PostgreSQL use?
3131 1.10) Does PostgreSQL work with databases from earlier versions of
32- postgres ?
32+ PostgreSQL ?
3333 1.11) Are there ODBC drivers for PostgreSQL?
34- 1.12) What tools are available for hookingpostgres to Web pages?
34+ 1.12) What tools are available for hookingPostgreSQL to Web pages?
3535 1.13) Does PostgreSQL have a graphical user interface? A report
3636 generator? A embedded query language interface?
3737 1.14) What is a good book to learn SQL?
38+ 1.15) What languages are available to communicate with PostgreSQL?
3839
3940 2) Installation/Configuration questions
4041
@@ -85,7 +86,7 @@ Questions answered:
8586 database?
8687 3.19) What is the time-warp feature and how does it relate to vacuum?
8788 3.20) What is an oid? What is a tid?
88- 3.21) What is the meaning of some of the terms used inPostgres ?
89+ 3.21) What is the meaning of some of the terms used inPostgreSQL ?
8990 3.22) What is Genetic Query Optimization?
9091 3.23) How do you remove a column from a table?
9192 3.24) How do SELECT only the first few rows of a query?
@@ -263,7 +264,7 @@ Section 1: General Questions
263264 particularly important.
264265
265266 The www page contains pointers to an implementation guide and five
266- papers written aboutpostgres design concepts and features.
267+ papers written aboutPostgres design concepts and features.
267268
268269 1.9) What version of SQL does PostgreSQL use?
269270
@@ -275,7 +276,8 @@ Section 1: General Questions
275276 On the other hand, you get to create user-defined types, functions,
276277 inheritance etc.
277278
278- 1.10) Does PostgreSQL work with databases from earlier versions of postgres?
279+ 1.10) Does PostgreSQL work with databases from earlier versions of
280+ PostgreSQL?
279281
280282 PostgreSQL v1.09 is compatible with databases created with v1.01.
281283
@@ -306,14 +308,14 @@ Section 1: General Questions
306308
307309 OpenLink ODBC is very popular. You can get it from
308310 http://www.openlinksw.com/postgres.html. It works with our standard
309- ODBC client software so you'll havePostgres ODBC available on every
311+ ODBC client software so you'll havePostgreSQL ODBC available on every
310312 client platform we support (Win, Mac, Unix, VMS).
311313
312314 We will probably be selling this product to people who need
313315 commercial-quality support, but a freeware version will always be
314316 available. Questions to postgres95@openlink.co.uk.
315317
316- 1.12) What tools are available for hookingpostgres to Web pages?
318+ 1.12) What tools are available for hookingPostgreSQL to Web pages?
317319
318320 A nice introduction to Database-backed Web pages can be seen at:
319321 http://www.webtools.com
@@ -341,6 +343,19 @@ Section 1: General Questions
341343
342344 Many of our users like The Practical SQL Handbook, Bowman et al,
343345 Addison Wesley.
346+
347+ 1.15) What languages are available to communicate with PostgreSQL?
348+
349+ We have:
350+ * C(interfaces/libpq)
351+ * C++(interfaces/libpq++)
352+ * Embedded C(interfaces/ecpg)
353+ * Java(interfaces/jdbc)
354+ * Perl(interfaces/perl5)
355+ * ODBC(interfaces/odbc)
356+ * Python(interfaces/python)
357+ * TCL(interfaces/libpgtcl)
358+ * A crude C/4GL(contrib/pginterface)
344359 _________________________________________________________________
345360
346361Section 2: Installation Questions
@@ -576,7 +591,7 @@ Section 3: PostgreSQL Features
576591 See the create_index manual page for information on what type classes
577592 are available. It must match the field type.
578593
579- Postgres does not warn the user when the improper index is created.
594+ PostgreSQL does not warn the user when the improper index is created.
580595
581596 Indexes not used for ORDER BY operations.
582597
@@ -624,7 +639,7 @@ BYTEA bytea variable-length array of bytes
624639
625640 3.15) How do I create a serial field?
626641
627- Postgres does not allow the user to specifiy a user column as type
642+ PostgreSQL does not allow the user to specifiy a user column as type
628643 SERIAL. Instead, you can use each row's oid field as a unique value.
629644 However, if you need to dump and reload the database, you need to use
630645 pgdump's -o option or COPY's WITH OIDS option to preserver the oids.
@@ -687,14 +702,15 @@ BYTEA bytea variable-length array of bytes
687702
688703 3.20) What is an oid? What is a tid?
689704
690- Oids are Postgres's answer to unique row ids or serial columns. Every
691- row that is created in Postgres gets a unique oid. All oids generated
692- by initdb are less than 16384 (from backend/access/transam.h). All
693- post-initdb (user-created) oids are equal or greater that this. All
694- these oids are unique not only within a table, or database, but unique
695- within the entire postgres installation.
705+ Oids are PostgreSQL's answer to unique row ids or serial columns.
706+ Every row that is created in PostgreSQL gets a unique oid. All oids
707+ generated by initdb are less than 16384 (from
708+ backend/access/transam.h). All post-initdb (user-created) oids are
709+ equal or greater that this. All these oids are unique not only within
710+ a table, or database, but unique within the entire PostgreSQL
711+ installation.
696712
697- Postgres uses oids in its internal system tables to link rows in
713+ PostgreSQL uses oids in its internal system tables to link rows in
698714 separate tables. These oids can be used to identify specific user rows
699715 and used in joins. It is recommended you use column type oid to store
700716 oid values. See the sql(l) manual page to see the other internal
@@ -705,7 +721,7 @@ BYTEA bytea variable-length array of bytes
705721 are used by index entries to point to physical rows. They can not be
706722 accessed through sql.
707723
708- 3.21) What is the meaning of some of the terms used inPostgres ?
724+ 3.21) What is the meaning of some of the terms used inPostgreSQL ?
709725
710726 Some of the source code and older documentation use terms that have
711727 more common usage. Here are some: