greenplum sql使用实例【未完待续】

来源：互联网发布：阿里云实时同步编辑：程序博客网时间：2024/06/05 15:16

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

0 0