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"
In response to
pgsql-general by date
|Next:||From: Jonathan Daugherty||Date: 2004-10-28 05:14:06|
|Subject: Re: determine sequence name for a serial|
|Previous:||From: Tom Lane||Date: 2004-10-28 05:01:20|
|Subject: Re: compatibilityissues from 7.1 to 7.4 |