auto increment primary key

From: impala <bhnnc(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: auto increment primary key
Date: 2002-04-05 10:21:19
Message-ID: 20020405102119.48225.qmail@web14904.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks
NJ

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marin Dimitrov 2002-04-05 10:30:19 Re: auto increment primary key
Previous Message Marin Dimitrov 2002-04-05 09:35:53 Re: text and numeric