Postgres Pro
Downloads
Home   >   mailing lists

get sequence name from table name - Mailing list pgsql-sql

From Uwe Maiwald
Subject get sequence name from table name
Date
Msg-id 4B193E8E.6010603@kiss-net.de
Whole thread Raw
Responses Re: get sequence name from table name  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Re: get sequence name from table name  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Gerardo Herzig
Date:
Subject: Re: create user xxx with md5 string?
Next
From: Another Trad
Date:
Subject: Getting more than one row in UNIQUE fields