CREATE DATABASE
CREATE DATABASE name [ [WITH] [OWNER [=] dbowner]
[TEMPLATE [=] template]
[ENCODING [=] encoding]
[TABLESPACE [=] tablespace]
[CONNECTION LIMIT [=] connlimit ] ]
通过gp工具:
createdb -h 192.168.181.225 -p 5432 -U gpadmin db_t
sql方式:
CREATE DATABASE test_db1;`
CREATE DATABASE test_db2 with ENCODING 'UNICODE';`
CREATE DATABASE test_db3 CONNECTION LIMIT 30 ENCODING='UTF8';
问题,encoding修改成unicode感觉未生效,查看结果还是:
db_t=# \l
List of databases
Name | Owner | Encoding | Access privileges
-----------+---------+----------+---------------------
db_t | gpadmin | UTF8 |
test_db1 | gpadmin | UTF8 |
test_db2 | gpadmin | UTF8 |
test_db3 | gpadmin | UTF8 |
CREATE SCHEMA
CREATE SCHEMA schema_name [AUTHORIZATION username]
[schema_element [ ... ]]
CREATE SCHEMA AUTHORIZATION rolename [schema_element [ ... ]]
保留字pg_
开头
CREATE SCHEMA sch_01;
查看结果:
db_t=# \dn
List of schemas
Name | Owner
--------------------+---------
sch_01 | gpadmin
CREATE TABLE
CREATE [[GLOBAL | LOCAL] {TEMPORARY | TEMP}] TABLE table_name (
[ { column_name data_type [ DEFAULT default_expr ]
[column_constraint [ ... ]
[ ENCODING ( storage_directive [,...] ) ]
]
| table_constraint
| LIKE other_table [{INCLUDING | EXCLUDING}
{DEFAULTS | CONSTRAINTS}] ...}
[, ... ] ]
)
[ INHERITS ( parent_table [, ... ] ) ]
[ WITH ( storage_parameter=value [, ... ] )
[ ON COMMIT {PRESERVE ROWS | DELETE ROWS | DROP} ]
[ TABLESPACE tablespace ]
[ DISTRIBUTED BY (column, [ ... ] ) | DISTRIBUTED RANDOMLY ]
[ PARTITION BY partition_type (column)
[ SUBPARTITION BY partition_type (column) ]
[ SUBPARTITION TEMPLATE ( template_spec ) ]
[...]
( partition_spec )
| [ SUBPARTITION BY partition_type (column) ]
[...]
( partition_spec
[ ( subpartition_spec
[(...)]
) ]
)
连接数据库
psql -h192.168.181.225 -d db_t -p5432 -Ugpadmin