Re: null tablespace?

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: null tablespace?
Дата
Msg-id CA+h6AhiT+p5eGTZ0UPnYNLDavfKnnS20eL3_ktQ0bjyG8B_2AA@mail.gmail.com
обсуждение исходный текст
Ответ на null tablespace?  (Tony Capobianco <tcapobianco@prospectiv.com>)
Ответы Re: null tablespace?
Список pgsql-general
Дерево обсуждения
Its going in default tablespace i.e. base/global.

Try this query, which give information on the default tablespaces.

select spcname, case spcname when 'pg_default' then (select setting from pg_settings where name = 'data_directory')||'/base' when 'pg_global' then (select setting from pg_settings where name = 'data_directory')||'/global' else spclocation end from pg_tablespace;


---
Regards,
Raghavendra
EnterpriseDB Corporation



On Fri, Dec 16, 2011 at 12:11 AM, Tony Capobianco <tcapobianco@prospectiv.com> wrote:
I have not defined my default tablespace:

show default_tablespace ;
 default_tablespace
--------------------


However, I have tables with null tablespaces values in pg_tables:

pg_dw=# select * from pg_tables where tablename = 'source_prev';
 schemaname |       tablename       | tableowner | tablespace | hasindexes | hasrules | hastriggers
------------+-----------------------+------------+------------+------------+----------+-------------
 support    | source_prev           | jspool     |            | t          | f        | f


We have defined out search_path correctly, so what tablespace is this table stored in?

Thanks!


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

Предыдущее
От: Kirill Simonov
Дата:
Сообщение: Re: Logical Aggregate Functions (eg ANY())
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: LOCK DATABASE