如果我在Postgres 9.5.1中有OID,我正在尝试弄清楚如何获得表格的架构。我尝试使用information_schema
,但无法弄清楚我用哪个表加入oid
。
您需要将pg_namespace
加入pg_class
select nsp.nspname as schema_name, tbl.relname as table_name
from pg_namespace nsp
join pg_class tbl on nsp.oid = tbl.relnamespace
where tbl.oid = 42;