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
