> 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 bellow is should give you the name of the table,
assuming you account for the correct namespace; it will not automatically
show the name of the column:
select objid::regclass, refobjid::regclass
from pg_depend
where objid::regclass::text = 'person_id_seq' ;
Thanks
Ioannis Tambouras