how to get the name of the sequence that is responsible for setting the autoincrement value of a tables primary key column?

i only have the name of the table and need to have an appropiate sql statement.


i need this to write a program that loops through all tables of a database and then ajusts the start values of the sequencees in case the table has an automatic id value (serial/bigserial)


thanks,
Uwe

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

Reply via email to