Re: how to find a tablespace for the table?

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: how to find a tablespace for the table?
Дата
Msg-id BANLkTi=SDgXBminYHtxwjR-X0vOaXno1kA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to find a tablespace for the table?  (hyelluas <helen_yelluas@mcafee.com>)
Ответы Re: how to find a tablespace for the table?  (hyelluas <helen_yelluas@mcafee.com>)
Список pgsql-general
profiler1=#  select * from pg_catalog.pg_tables where
tablename='application_category';
 schemaname |      tablename       | tableowner | tablespace | hasindexes |
hasrules | hastrigge
rs
------------+----------------------+------------+------------+------------+----------+----------
---
 public     | application_category | postgres   |            | t          |
f        | f
(1 row)

Whats the output of this..

select relname,reltablespace from pg_class where relname='application_category';



---
Best Regards,
Raghavendra
EnterpriseDB Corporation



On Tue, Jun 21, 2011 at 2:16 AM, hyelluas <helen_yelluas@mcafee.com> wrote:
here it is :


profiler1=# select oid,* from pg_tablespace;
 oid  |  spcname   | spcowner |     spclocation      | spcacl
-------+------------+----------+----------------------+--------
 1663 | pg_default |       10 |                      |
 1664 | pg_global  |       10 |                      |
 19955 | profiler1  |       10 | /data/psql/profiler1 |
(3 rows)


profiler1=# select relname,reltablespace from pg_class where
reltablespace=19955;
 relname | reltablespace
---------+---------------
(0 rows)


thanks
Helen

--
View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-find-a-tablespace-for-the-table-tp4500200p4508020.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
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 по дате отправления:

Предыдущее
От: hyelluas
Дата:
Сообщение: Re: how to find a tablespace for the table?
Следующее
От: hyelluas
Дата:
Сообщение: Re: how to find a tablespace for the table?