diff options
Diffstat (limited to 'doc/FAQ')
| -rw-r--r-- | doc/FAQ | 18 |
1 files changed, 8 insertions, 10 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sat Nov 15 23:41:03 EST 2003 + Last updated: Sat Nov 29 23:54:03 EST 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -253,7 +253,7 @@ 1.7) What is the latest release? - The latest release of PostgreSQL is version 7.3.4. + The latest release of PostgreSQL is version 7.4. We plan to have major releases every six to eight months. @@ -430,11 +430,10 @@ Yes, there are several graphical interfaces to PostgreSQL available. These include PgAccess http://www.pgaccess.org), PgAdmin III - (http://www.pgadmin.org, Win32-only), RHDB Admin - (http://sources.redhat.com/rhdb/ ) and Rekall ( - http://www.thekompany.com/products/rekall/, proprietary). There is - also PHPPgAdmin ( http://phppgadmin.sourceforge.net/ ), a web-based - interface to PostgreSQL. + (http://www.pgadmin.org, RHDB Admin (http://sources.redhat.com/rhdb/ ) + and Rekall ( http://www.thekompany.com/products/rekall/, proprietary). + There is also PHPPgAdmin ( http://phppgadmin.sourceforge.net/ ), a + web-based interface to PostgreSQL. See http://techdocs.postgresql.org/guides/GUITools for a more detailed list. @@ -879,8 +878,8 @@ BYTEA bytea variable-length byte array (null-byte safe) 4.15.1) How do I create a serial/auto-incrementing field? - PostgreSQL supports a SERIAL data type. It auto-creates a sequence and - index on the column. For example, this: + PostgreSQL supports a SERIAL data type. It auto-creates a sequence. + For example, this: CREATE TABLE person ( id SERIAL, name TEXT @@ -892,7 +891,6 @@ BYTEA bytea variable-length byte array (null-byte safe) id INT4 NOT NULL DEFAULT nextval('person_id_seq'), name TEXT ); - CREATE UNIQUE INDEX person_id_key ON person ( id ); See the create_sequence manual page for more information about sequences. You can also use each row's OID field as a unique value. |