null tablespace?

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

On Fri, 2011-12-16 at 00:23 +0530, Raghavendra wrote:

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