tablespace_oid alias? - Mailing list pgsql-general

From Thalis Kalfigkopoulos
Subject tablespace_oid alias?
Date
Msg-id CAEkCx9EyCZiBCSpZiGvgV5Xaccj1tWU=mLZ1wiwBFpHnuaqC1A@mail.gmail.com
Whole thread Raw
Responses Re: tablespace_oid alias?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi all,

I want to get the databases that correspond to a certain tablespace
through a call to pg_tablespace_databases(tablespace_oid)

Which would be the OID alias type for tablespace_oid?

I've tried:
# select pg_tablespace_databases('pg_default'::XXX);

with XXΧ as any of the OID aliases mentioned in the manual's chapter 8
section on "Object Iddentifier Types", but without success.

Any hints? Missing something?


TIA,
Thalis K.


pgsql-general by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: Limit+Offset query wrong result in Postgres 9.0.3 ?
Next
From: Scott Marlowe
Date:
Subject: Re: Postgres DB Migration from 8.3 to 9.1