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 <ba...@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 >
