Re: sequences and dependences

[Ioannis Tambouras <ioannis(at)akroninc(dot)net>]

>   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