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" ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster