Re: tablespace_oid alias? - Mailing list pgsql-general

From Tom Lane
Subject Re: tablespace_oid alias?
Date
Msg-id 24770.1350082857@sss.pgh.pa.us
Whole thread Raw
In response to tablespace_oid alias?  (Thalis Kalfigkopoulos <tkalfigo@gmail.com>)
List pgsql-general
Thalis Kalfigkopoulos <tkalfigo@gmail.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


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Postgres DB Migration from 8.3 to 9.1
Next
From: Vishalakshi Navaneethakrishnan
Date:
Subject: Re: Postgres DB Migration from 8.3 to 9.1