[GENERAL] deduce sequence name from table and column

2005-12-20 Thread Louis-David Mitterrand
Hi, Is there a way (from DBI) to deduce a sequence name from the table and column it is attached to? For instance: Column| Type |Modifiers

Re: [GENERAL] deduce sequence name from table and column

2005-12-20 Thread Tom Lane
Louis-David Mitterrand [EMAIL PROTECTED] writes: Is there a way (from DBI) to deduce a sequence name from the table and column it is attached to? Since 8.0 you can use pg_get_serial_sequence(), see http://www.postgresql.org/docs/8.0/static/functions-info.html regards,

Re: [GENERAL] deduce sequence name from table and column

2005-12-20 Thread Louis-David Mitterrand
On Tue, Dec 20, 2005 at 10:31:46AM -0500, Tom Lane wrote: Louis-David Mitterrand [EMAIL PROTECTED] writes: Is there a way (from DBI) to deduce a sequence name from the table and column it is attached to? Since 8.0 you can use pg_get_serial_sequence(), see