Re: auto increment primary key

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: Raw Message | Whole Thread | 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. "

In response to

Browse pgsql-general by date

  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