Thalis Kalfigkopoulos <tkalfigo@xxxxxxxxx> writes: > Which would be the OID alias type for tablespace_oid? There is none. Use "select oid from pg_tablespace where spcname = 'whatever'". (In general, OID alias types only get invented for object types where the lookup rules are more complicated than that, eg where you have schema qualification or arguments to think about.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general