Hi Laurent.

As I understand where is no direct link between sequence and the table column. You should see pg_attrdef table. Query SELECT pg_get_expr(adbin,adrelid) FROM pg_attrdef; will return you all default values of the columns. Among them you will find nextval('your_sequence'::regclass).

Hope that helps...



Laurent ROCHE rašė:
Hi,

I have posted this on the pg main list ... and as I had no sensible answers, I am trying here. Also, it's likely someone knows the answer as you need to get this info to display it in pgAdmin !

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 column).

Any ideas ?
Have fun,
[EMAIL PROTECTED]
The Computing Froggy



------------------------------------------------------------------------
Envoyé avec Yahoo! Mail <http://us.rd.yahoo.com/mailuk/taglines/isp/control/*http://us.rd.yahoo.com/evt=52423/*http://fr.docs.yahoo.com/mail/overview/index.html>. Une boite mail plus intelligente.


--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050


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

Reply via email to