On Thu, Nov 03, 2005 at 11:46:58AM +1100, Shuying Wang wrote:
> Why is relname 'eligibility_type' and not 'enumerations.eligibility_type'?
pg_class.relname stores only the relation name; if you want the
schema name then join pg_class.relnamespace and pg_namespace.oid
and refer to pg_namespace.nspname. Another way would be to cast
'schemaname.relationname' to regclass and compare it to pg_class.oid:
FROM pg_class c ...
WHERE c.oid = 'enumerations.eligibility_type'::regclass
In response to
pgsql-novice by date
|Next:||From: william||Date: 2005-11-04 00:41:51|
|Subject: Unable to login for first time ....|
|Previous:||From: Michael Dean||Date: 2005-11-03 00:47:10|