Re: [GENERAL] sequences and dependences

2008-05-24 Thread Greg Smith
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 c

Re: [GENERAL] sequences and dependences

2008-05-24 Thread Ioannis Tambouras
> 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