> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
