Re: determine sequence name for a serial - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: determine sequence name for a serial
Date
Msg-id 20041028051347.GA10946@dcc.uchile.cl
Whole thread Raw
In response to Re: determine sequence name for a serial  (Robby Russell <robby@planetargon.com>)
List pgsql-general
On Wed, Oct 27, 2004 at 09:33:21PM -0700, Robby Russell wrote:

> So, it was a nice attempt, but I am back to the need to of determining
> the sequence name using a schema and a table.

The schema of a table is stored in pg_class.relnamespace, which is an
Oid of the pg_namespace catalog.  With that and your previous query you
should be set.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La felicidad no es mañana. La felicidad es ahora"


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: compatibilityissues from 7.1 to 7.4
Next
From: Tom Lane
Date:
Subject: Re: determine sequence name for a serial