sergio nogueira <sergiopnog@gmail.com> writes:
> 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?
It's probably in the default tablespace for the current database.
regards, tom lane