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

Видео 8. Postgres Administration - Tablespace канала SQL Depository