Re: [GENERAL] auto increment?
От | David Hartwig |
---|---|
Тема | Re: [GENERAL] auto increment? |
Дата | |
Msg-id | 006501be4727$3a6ef740$027dc497@daveh обсуждение исходный текст |
Список | pgsql-general |
Each PostgreSQL table has a, system assigned, oid (object ID) column which is useful for uniquely identifying rows. Users have vertually no control over it value. There is also: CREATE TABLE foo ( ai serial primary key, bar integer ); which is a short cut in the parser for: CREATE SEQUENCE ai_seq; CREATE TABLE foo ( ai integer default nextval('ai_seq') primary key, bar integer ); The ai column in each create statement does not require the user code to explicitly assign its values. See CREATE_SEQUENCE in the doc. ----- Original Message ----- From: Robert Williams <rwilliams@jrc-utah.com> To: Postgres <pgsql-general@postgreSQL.org> Sent: Saturday, January 23, 1999 4:11 PM Subject: [GENERAL] auto increment? >How do I set up a column as auto increment? I have looked >everywhere for the postgres equivalent ROWID as in Oracle. > >-- >Robert Williams rwilliams@jrc-utah.com >Jarob Consulting rwilliams@kde.org >Provo, Utah rwilliams71@mailexcite.com
В списке pgsql-general по дате отправления: