Re: system maintained keys

From: Joel Burton <joel(at)joelburton(dot)com>
To: Stefan Lindner <lindner(at)visionet(dot)de>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: system maintained keys
Date: 2001-10-19 20:34:26
Message-ID: Pine.LNX.4.30.0110191633430.22474-100000@temp.joelburton.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 15 Oct 2001, 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?

\h CREATE SEQUENCE will give syntax, or look up SEQUENCES and SERIAL data
type in the documentation.

--

Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-10-19 22:38:16 Re: oid's in views.
Previous Message Aasmund Midttun Godal 2001-10-19 19:10:30 Re: oid's in views.