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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: johnf <jfabiani(at)yolo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: find the sequence name from schema, table, field
Date: 2008-01-10 14:12:43
Message-ID: 20080110141243.GB6465@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

johnf wrote:

> I have to go to the well and ask you guys how in the he_l I can determine the
> sequence name if I only have the schema name (normally 'public'), the table
> name, and the field name (normally the PK).

pg_get_serial_sequence()

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Kempter 2008-01-10 15:10:39 Re: Postgres replication
Previous Message Richard Ray 2008-01-10 14:06:40 Re: pg_dumpall --exclude