Thalis Kalfigkopoulos <tkalfigo(at)gmail(dot)com> 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