Hi, i didn't understand:
dmonitor=> create table whattbs (id integer);
CREATE TABLE
dmonitor=> select tablename, tablespace from pg_tables where
tablename='whattbs';
tablename | tablespace
-----------+------------
whattbs |
(1 row)
dmonitor=> alter table whattbs set tablespace monitor_dat1;
ALTER TABLE
dmonitor=> select tablename, tablespace from pg_tables where
tablename='whattbs';
tablename | tablespace
-----------+------------
whattbs |
(1 row)
In what tablespace is the table?
Att.,
Sergio Nogueira