From: | Michael Andrew Babb <babbm(at)uw(dot)edu> |
---|---|
To: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: list all members in a tablespace |
Date: | 2011-03-14 18:20:31 |
Message-ID: | FA6A2975AD158C4A850EE96CF41AB63B3ED9FA6F@BL2PRD0103MB041.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Raghavendra. I tried the query and it seemed to be returning the indices and sequences in each tablespace. I'll keep trying to get the list of tablespaces.
Thanks for your help!
Mike
From: Raghavendra [mailto:raghavendra(dot)rao(at)enterprisedb(dot)com]
Sent: Wednesday, March 09, 2011 5:15 PM
To: Michael Andrew Babb
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] list all members in a tablespace
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(at)uw(dot)edu<mailto:babbm(at)uw(dot)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(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Vick Khera | 2011-03-14 18:38:21 | Re: DBMS upgrade and backups |
Previous Message | Merlin Moncure | 2011-03-14 16:52:24 | Re: Select for update with offset interferes with concurrent transactions |