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');