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