一、创建目录
mkdir -p /usr/local/pgsql/data/mytblspc
二、创建表空间
psql
create tablespace myspc owner postgres location '/usr/local/pgsql/data/mytblspc';
\db
select oid,* from pg_tablespace;
1.创建表指定表空间
create table t(id serial primary key,ival int) tablespace myspc;
create index ind_id on t(id) tablespace myspc;