Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I should think that the table-level display ought to show both the >> relfilenode and tablespace OIDs for each table.
> For objects in the default tablespace, they don't show a tablespace oid, > right? Where do we put it? A column that will be empty if they don't > use tablespaces? pg_class will show a zero for objects in the default tablespace, but I think oid2name should pull the actual tablespace ID from pg_database.dattablespace and show that. The convention about zero is just to make life simple for CREATE DATABASE --- users of oid2name should not have to think about it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match