Postgres Pro
Downloads
Home   >   mailing lists

Re: list all members in a tablespace - Mailing list pgsql-general

From Raghavendra
Subject Re: list all members in a tablespace
Date
Msg-id AANLkTi=+LmL43Vai8fPhBhU1YWnaAqfBGnTo=naT_DZB@mail.gmail.com
Whole thread Raw
In response to list all members in a tablespace  (Michael Andrew Babb <babbm@uw.edu>)
Responses 9.1 Trigger question  (Michael Black <michaelblack75052@hotmail.com>)
Re: list all members in a tablespace  (Michael Andrew Babb <babbm@uw.edu>)
List pgsql-general
Tree view
Hi Mike,

I tried this, which will get the list of tables belong to 'XYZ' tablespace.

select relname from pg_class where reltablespace=(select oid from pg_tablespace where spcname='xyz');

Hope this helps

Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres Company

On Thu, Mar 10, 2011 at 6:05 AM, Michael Andrew Babb <babbm@uw.edu> wrote:
Hi All,

I'm doing a little housekeeping on my tablespaces and I'm curious if there is a quick and easy way to list all of the objects in a tablespace. Is there a command to list all objects in a tablespace?

Thanks,

Mike

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Arturo Perez
Date:
Subject: Re: ER tool that supports domains and custom types?
Next
From: Michael Black
Date:
Subject: 9.1 Trigger question