8.2 Postgres Administration - Move and Drop Tablespaces

Move and Drop Tablespaces

Postgres Administration - Tablespace

#check existing tablespace
select * from pg_tablespace;

#create tablespace
create tablespace rpt location '/opt/rpt';

#create table in non default tablespace
create table reporting (id int) tablespace rpt;

#check tablespace of a table
select * from pg_tables where tablename='tablename';

#move table to different tablespace
alter table actor set tablespace rpt;

#check table filepath
select * from pg_relation_filepath('actor');