> 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
