Re: Find schema-qualified table name given unqualified name

Aron Widforss writes: > I'm interested in finding a (any) unique identifier for a table given an > unqualified name of the table. Is that feasible in SQL or a C function? Something like this might help you: select relnamespace::regnamespace from pg_class where oid = 'mytable

Find schema-qualified table name given unqualified name

Hi, I'm interested in finding a (any) unique identifier for a table given an unqualified name of the table. Is that feasible in SQL or a C function? Regards, Aron Widforss