Re: [SQL] get sequence name from table name

2009-12-04 Thread Alvaro Herrera
Uwe Maiwald wrote: > how to get the name of the sequence that is responsible for setting > the autoincrement value of a tables primary key column? You can use the pg_get_serial_sequence() function. You need the name of the column in addition to the table name though. -- Alvaro Herrera

Re: [SQL] get sequence name from table name

2009-12-04 Thread Gerardo Herzig
Uwe Maiwald wrote: > 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 tab

[SQL] get sequence name from table name

2009-12-04 Thread Uwe Maiwald
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 aju