Re: Fwd: alter table ... set tablespace - Mailing list pgsql-novice

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