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

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