Participants
Stefan Lindner
Stefan Lindner
Oliver Elphick
Oliver Elphick
Attachments
Show all attachments
Thread Outline
#1Stefan LindnerStefan Lindner
Oct 15, 2001
#2Oliver Elphick↳Oliver Elphickto Stefan Lindner (#1)
Oct 17, 2001

system maintained keys

Started by Stefan Lindnerover 24 years ago2 messagesgeneral
Jump to latest
#1Stefan Lindner
Stefan Lindner
lindner@visionet.de

Is there any way to get system maintained keys from postgres? e.g. to
have a table with a primary key column (varchar or int) and let postgres
chose the next unique value for this column?

#2Oliver Elphick
Oliver Elphick
olly@lfix.co.uk
In reply to: Stefan Lindner (#1)
Re: system maintained keys

"Stefan Lindner" wrote:

Is there any way to get system maintained keys from postgres? e.g. to
have a table with a primary key column (varchar or int) and let postgres
chose the next unique value for this column?

The SERIAL data type does this. It is an INTEGER with a sequence attached.

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"Trust in the LORD, and do good..." Psalms 37:3

← Back to Topics