Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: find the sequence name from schema, table, field
- From: johnf <jfabiani(at)yolo(dot)com>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: Re: find the sequence name from schema, table, field
- Date: Thu, 10 Jan 2008 07:12:39 -0800
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
- References:
- find the sequence name from schema, table, field
- From: johnf
- Re: find the sequence name from schema, table, field
- From: Alvaro Herrera
- find the sequence name from schema, table, field
- Prev by Date: Re: Postgres replication
- Next by Date: Re: Postgres replication
- Previous by thread: Re: find the sequence name from schema, table, field
- Next by thread: Need some info.
- Indexes: