From: johnf <jfabiani@yolo.com>
To: pgsql-admin@postgresql.org
Subject: Re: find the sequence name from schema, table, field
Date: Thu, 10 Jan 2008 07:12:39 -0800
Message-ID: <200801100712.39496.jfabiani@yolo.com> (raw)
In-Reply-To: <20080110141243.GB6465@alvh.no-ip.org>
References: <200801092329.31115.jfabiani@yolo.com>
<20080110141243.GB6465@alvh.no-ip.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jfabiani@yolo.com
Subject: Re: find the sequence name from schema, table, field
In-Reply-To: <200801100712.39496.jfabiani@yolo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox