Pessoal, não entendi:

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)

Em que tablespace está a tabela?

Att.,
Sergio Nogueira
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a