Postgres Pro
Downloads
Home   >   mailing lists

Re: deduce sequence name from table and column - Mailing list pgsql-general

From Louis-David Mitterrand
Subject Re: deduce sequence name from table and column
Date
Msg-id 20051220153647.GA28076@apartia.fr
Whole thread Raw
In response to Re: deduce sequence name from table and column  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Tue, Dec 20, 2005 at 10:31:46AM -0500, Tom Lane wrote:
> Louis-David Mitterrand <vindex@apartia.org> writes:
> > Is there a way (from DBI) to deduce a sequence name from the table and
> > column it is attached to?
>
> Since 8.0 you can use pg_get_serial_sequence(), see
> http://www.postgresql.org/docs/8.0/static/functions-info.html

Just what I needed,
Thanks!

--
                      -= this .sig is not funny =-

pgsql-general by date:

Previous
From: Seneca Cunningham
Date:
Subject: Re: out of memory during query execution
Next
From: Jaime Casanova
Date:
Subject: Re: One DB not backed up by pg_dumpall