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