Re: null tablespace?

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

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

Blog: http://raghavt.blogspot.com/

On Fri, Dec 16, 2011 at 12:11 AM, Tony Capobianco <tcapobianco@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general