- 论坛徽章:
- 1
|
- create tablespace 语法:
- CREATE TABLESPACE 表空间的名称 [ OWNER 用户名 ] LOCATION '目录'
- create table 语法:
- CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] 表名 ( [
- { 列名称 数据_类型 [ COLLATE 校对规则 ] [ 列约束 [ ... ] ]
- | 表约束
- | LIKE 源表 [ like选项 ... ] }
- [, ... ]
- ] )
- [ INHERITS ( 父表 [, ... ] ) ]
- [ WITH ( 存储参数 [= 值] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
- [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
- [ TABLESPACE 表空间的名称 ]
- CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] 表名
- OF 类型名称 [ (
- { 列名称 WITH OPTIONS [ 列约束 [ ... ] ]
- | 表约束 }
- [, ... ]
- ) ]
- [ WITH ( 存储参数 [= 值] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
- [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
- [ TABLESPACE 表空间的名称 ]
复制代码 |
|