8. Postgres Administration - Tablespace
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';