Re: find the sequence name from schema, table, field

On Thursday 10 January 2008 06:12:43 am Alvaro Herrera wrote:
> pg_get_serial_sequence

But it only works with a serial data type.

Create a sequence "mySequence"
Create a field "myField smallint NOT NULL  DEFAULT
nextval('mysequence'::regclass)"

So given the name of the table and the name of the field. How can I find the
name of the associated squence?



--
John Fabiani