Re: derive the sequence name of a column

On Fri, 31 Oct 2003, Mel Jamero wrote:

> Works fine with 7.2.2. Thanks! I still can't figure it out in 7.1.3
>
> There's no pg_namespace there. Any ideas?

I think you can just remove the join with pg_namespace and the associated
where clauses (the nspname one and the join condition one). I'm not
sure if there'll be any other problems since I don't currently have a
7.1.x system to try against.

And, for good measure, if you're running 7.1.x, you should really upgrade
soon. ;)

> select pg_attrdef.* from pg_attrdef, pg_namespace, pg_class,
> pg_attribute
> where pg_namespace.nspname='public' and
> pg_class.relnamespace=pg_namespace.oid and pg_class.relname='test' and
> pg_attribute.attrelid=pg_class.oid and pg_attribute.attname='test_id'
> and
> pg_attrdef.adrelid=pg_class.oid and
> pg_attrdef.adnum=pg_attribute.attnum;
>
> (filling in the schema, table name and column name for the constants).