On Fri, 23 May 2008, Laurent ROCHE wrote:
I would like to write a request where I would get the table name and
column name of a sequence. I have been looking at the sytem table and
could not link the sequence from pg_class to a table (and even less to a
table).
There's an example of how to c
> I would like to write a request where I would get the table name and
> column name of a sequence.
> In fact I want the opposite of pg_get_serial_sequence !
You are looking for refobjid in pg_depend, but this
time the sequence could be a dependent to more than table.
A query like the one