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 chain between two pg_class entries using pg_depend that I think is close to what you're looking for at http://wiki.postgresql.org/wiki/Fixing_Sequences
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD