Postgres Pro
Downloads
Home   >   mailing lists

Re: determine sequence name for a serial - Mailing list pgsql-general

From Tom Lane
Subject Re: determine sequence name for a serial
Date
Msg-id 28156.1098940504@sss.pgh.pa.us
Whole thread Raw
In response to determine sequence name for a serial  (Robby Russell <robby@planetargon.com>)
List pgsql-general
Tree view 
Robby Russell <robby@planetargon.com> writes:
> Ok, so how would I go about getting the sequence name for a SERIAL
> field on any given schema.table?

8.0 will have a function pg_get_serial_sequence to do this for you.
If you can't wait, the secret is to look in pg_depend for the dependency
link from the serial sequence to its column.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: determine sequence name for a serial
Next
From: Jonathan Daugherty
Date:
Subject: Re: determine sequence name for a serial