tablespace_oid alias?

From: Thalis Kalfigkopoulos <tkalfigo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: tablespace_oid alias?
Date: 2012-10-12 21:23:16
Message-ID: CAEkCx9EyCZiBCSpZiGvgV5Xaccj1tWU=mLZ1wiwBFpHnuaqC1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-10-12 22:07:09 Re: Postgres DB Migration from 8.3 to 9.1
Previous Message Josh Kupershmidt 2012-10-12 18:58:31 Re: Limit+Offset query wrong result in Postgres 9.0.3 ?