kingbaseESV8数据库表空间

创建数据库db01，属主为user01、编码为UTF8、参照模板template0、连接数为10
CREATE DATABASE db01 OWNER user01 TEMPLATE template0 ENCODING 'UTF8' CONNECTION LIMIT 10;

\l+ db01

ALTER DATABASE db01 OwNER TO system;

ALTER DATABASE db01 RENAME TO db10;

DROP DATABASE IF EXISTS db10;

CREATE TABLESPACE tbs01 LOCATION '/dir01';

ALTER TABLESPACE tbs01 OWNER TO user01;

ALTER TABLESPACE tbs01 RENAME TO tbs10;

ALTER DATABASE db01 SET TABLESPACE tbs10;

SELECT oid,spcname FROM sys_tablespace;  

CREATE TABLE t01(id int) TABLESPACE sys_default;

ALTER TABLE t01 SET TABLESPACE tbs10;

SELECT oid,spcname  FROM sys_tablespace WHERE spcname='tbs10';

--上述语句部分来自官方文档