| From: | "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg> |
|---|---|
| To: | "impala" <bhnnc(at)yahoo(dot)co(dot)uk>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: auto increment primary key |
| Date: | 2002-04-05 10:30:19 |
| Message-ID: | 001301c1dc8c$e24fd760$9b0e32d4@sirma.bg |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
----- Original Message -----
From: "impala"
> I created a table, want the integer/varchar primary
> key column to be incremented automatically when
> inserted a new row. How do I define the table to do
> that? I tried AUTO_INCREMENT and INCREMENT but
> postgres accept none of them.
>
search docs for "sequence" and "serial"
how do u increment a varchar?
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Joerdens | 2002-04-05 10:30:39 | Re: auto increment primary key |
| Previous Message | impala | 2002-04-05 10:21:19 | auto increment primary key |