Saturday, May 24, 2008

Re: [GENERAL] sequences and dependences

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@gregsmith.com http://www.gregsmith.com Baltimore, MD

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: