| From: | "Dan Wilson" <phpPgAdmin(at)acucore(dot)com> |
|---|---|
| To: | <harry(dot)wood(at)ic(dot)ac(dot)uk>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Auto incrementing fields. How? |
| Date: | 2000-12-19 16:40:44 |
| Message-ID: | 006801c069da$6f8d4490$078353d8@danwilson |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Use the column type of SERIAL in your create table statement. This will
automatically create a sequence and default for the given column.
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-createsequence.htm
for more on sequences.
----- Original Message -----
From: "Harry Wood" <harry(dot)wood(at)ic(dot)ac(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, December 19, 2000 6:51 AM
Subject: [GENERAL] Auto incrementing fields. How?
> Anyone know how to create auto incrementing fields?
>
> --
> Harry
> harry(dot)wood(at)ic(dot)ac(dot)uk
> http://www.doc.ic.ac.uk/~hw97/Nojer2
> Nojer2 on chat.yahoo.com and zapidonia.com
> ICQ number 18519769
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tulio Oliveira | 2000-12-19 17:34:57 | Re: Auto incrementing fields. How? |
| Previous Message | Dan Wilson | 2000-12-19 16:37:58 | Re: newbie question: |