Re: list all members in a tablespace
| От | Raghavendra |
|---|---|
| Тема | Re: list all members in a tablespace |
| Дата | |
| Msg-id | AANLkTi=+LmL43Vai8fPhBhU1YWnaAqfBGnTo=naT_DZB@mail.gmail.com обсуждение исходный текст |
| Ответ на | list all members in a tablespace (Michael Andrew Babb <babbm@uw.edu>) |
| Ответы |
9.1 Trigger question
Re: list all members in a tablespace |
| Список | pgsql-general |
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
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 по дате отправления: