Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: deduce sequence name from table and column
Date
Msg-id 29515.1135092706@sss.pgh.pa.us
Whole thread Raw
In response to deduce sequence name from table and column  (Louis-David Mitterrand <vindex@apartia.org>)
Responses Re: deduce sequence name from table and column
List pgsql-general
Tree view 
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

            regards, tom lane

pgsql-general by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: deduce sequence name from table and column
Next
From: Seneca Cunningham
Date:
Subject: Re: out of memory during query execution