ABORT

Terminates the current transaction.

1. ABORT [WORK | TRANSACTION]

See ABORT for more information.

ALTER AGGREGATE

Changes the definition of an aggregate function

1. ALTER AGGREGATE <name> ( <aggregate_signature> )  RENAME TO <new_name>

3. ALTER AGGREGATE <name> ( <aggregate_signature> ) OWNER TO <new_owner>

5. ALTER AGGREGATE <name> ( <aggregate_signature> ) SET SCHEMA <new_schema>

See ALTER AGGREGATE for more information.

ALTER COLLATION

Changes the definition of a collation.

1. ALTER COLLATION <name> RENAME TO <new_name>

3. ALTER COLLATION <name> OWNER TO <new_owner>

5. ALTER COLLATION <name> SET SCHEMA <new_schema>

See ALTER COLLATION for more information.

ALTER CONVERSION

Changes the definition of a conversion.

1. ALTER CONVERSION <name> RENAME TO <newname>

3. ALTER CONVERSION <name> OWNER TO <newowner>

5. ALTER CONVERSION <name> SET SCHEMA <new_schema>

See ALTER CONVERSION for more information.

ALTER DATABASE

Changes the attributes of a database.

1. ALTER DATABASE <name> [ WITH CONNECTION LIMIT <connlimit> ]

3. ALTER DATABASE <name> RENAME TO <newname>

5. ALTER DATABASE <name> OWNER TO <new_owner>

7. ALTER DATABASE <name> SET TABLESPACE <new_tablespace>

9. ALTER DATABASE <name> SET <parameter> { TO | = } { <value> | DEFAULT }
10. ALTER DATABASE <name> SET <parameter> FROM CURRENT
11. ALTER DATABASE <name> RESET <parameter>
12. ALTER DATABASE <name> RESET ALL

See ALTER DATABASE for more information.

ALTER DEFAULT PRIVILEGES

Changes default access privileges.

2. ALTER DEFAULT PRIVILEGES
3. [ FOR { ROLE | USER } <target_role> [, ...] ]
4. [ IN SCHEMA <schema_name> [, ...] ]
5. <abbreviated_grant_or_revoke>

7. where <abbreviated_grant_or_revoke> is one of:

9. GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
10. [, ...] | ALL [ PRIVILEGES ] }
11. ON TABLES
12. TO { [ GROUP ] <role_name> | PUBLIC } [, ...] [ WITH GRANT OPTION ]

14. GRANT { { USAGE | SELECT | UPDATE }
15. [, ...] | ALL [ PRIVILEGES ] }
16. ON SEQUENCES
17. TO { [ GROUP ] <role_name> | PUBLIC } [, ...] [ WITH GRANT OPTION ]

19. GRANT { EXECUTE | ALL [ PRIVILEGES ] }
20. ON FUNCTIONS
21. TO { [ GROUP ] <role_name> | PUBLIC } [, ...] [ WITH GRANT OPTION ]

23. GRANT { USAGE | ALL [ PRIVILEGES ] }
24. ON TYPES
25. TO { [ GROUP ] <role_name> | PUBLIC } [, ...] [ WITH GRANT OPTION ]

27. REVOKE [ GRANT OPTION FOR ]
28. { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
29. [, ...] | ALL [ PRIVILEGES ] }
30. ON TABLES
31. FROM { [ GROUP ] <role_name> | PUBLIC } [, ...]
32. [ CASCADE | RESTRICT ]

34. REVOKE [ GRANT OPTION FOR ]
35. { { USAGE | SELECT | UPDATE }
36. [, ...] | ALL [ PRIVILEGES ] }
37. ON SEQUENCES
38. FROM { [ GROUP ] <role_name> | PUBLIC } [, ...]
39. [ CASCADE | RESTRICT ]

41. REVOKE [ GRANT OPTION FOR ]
42. { EXECUTE | ALL [ PRIVILEGES ] }
43. ON FUNCTIONS
44. FROM { [ GROUP ] <role_name> | PUBLIC } [, ...]
45. [ CASCADE | RESTRICT ]

47. REVOKE [ GRANT OPTION FOR ]
48. { USAGE | ALL [ PRIVILEGES ] }
49. ON TYPES
50. FROM { [ GROUP ] <role_name> | PUBLIC } [, ...]
51. [ CASCADE | RESTRICT ]

See ALTER DEFAULT PRIVILEGES for more information.

ALTER DOMAIN

Changes the definition of a domain.

1. ALTER DOMAIN <name> { SET DEFAULT <expression> | DROP DEFAULT }

3. ALTER DOMAIN <name> { SET | DROP } NOT NULL

5. ALTER DOMAIN <name> ADD <domain_constraint> [ NOT VALID ]

7. ALTER DOMAIN <name> DROP CONSTRAINT [ IF EXISTS ] <constraint_name> [RESTRICT | CASCADE]

9. ALTER DOMAIN <name> RENAME CONSTRAINT <constraint_name> TO <new_constraint_name>

11. ALTER DOMAIN <name> VALIDATE CONSTRAINT <constraint_name>

13. ALTER DOMAIN <name> OWNER TO <new_owner>

15. ALTER DOMAIN <name> RENAME TO <new_name>

17. ALTER DOMAIN <name> SET SCHEMA <new_schema>

See ALTER DOMAIN for more information.

ALTER EXTENSION

Change the definition of an extension that is registered in a Greenplum database.

1. ALTER EXTENSION <name> UPDATE [ TO <new_version> ]
2. ALTER EXTENSION <name> SET SCHEMA <new_schema>
3. ALTER EXTENSION <name> ADD <member_object>
4. ALTER EXTENSION <name> DROP <member_object>

6. where <member_object> is:

8. ACCESS METHOD <object_name> |
9. AGGREGATE <aggregate_name> ( <aggregate_signature> ) |
10. CAST (<source_type> AS <target_type>) |
11. COLLATION <object_name> |
12. CONVERSION <object_name> |
13. DOMAIN <object_name> |
14. EVENT TRIGGER <object_name> |
15. FOREIGN DATA WRAPPER <object_name> |
16. FOREIGN TABLE <object_name> |
17. FUNCTION <function_name> ( [ [ <argmode> ] [ <argname> ] <argtype> [, ...] ] ) |
18. MATERIALIZED VIEW <object_name> |
19. OPERATOR <operator_name> (<left_type>, <right_type>) |
20. OPERATOR CLASS <object_name> USING <index_method> |
21. OPERATOR FAMILY <object_name> USING <index_method> |
22. [ PROCEDURAL ] LANGUAGE <object_name> |
23. SCHEMA <object_name> |
24. SEQUENCE <object_name> |
25. SERVER <object_name> |
26. TABLE <object_name> |
27. TEXT SEARCH CONFIGURATION <object_name> |
28. TEXT SEARCH DICTIONARY <object_name> |
29. TEXT SEARCH PARSER <object_name> |
30. TEXT SEARCH TEMPLATE <object_name> |
31. TRANSFORM FOR <type_name> LANGUAGE <lang_name> |
32. TYPE <object_name> |
33. VIEW <object_name>

35. and <aggregate_signature> is:

37. * |
38. [ <argmode> ] [ <argname> ] <argtype> [ , ... ] |
39. [ [ <argmode> ] [ <argname> ] <argtype> [ , ... ] ] ORDER BY [ <argmode> ] [ <argname> ] <argtype> [ , ... ]

See ALTER EXTENSION for more information.

ALTER EXTERNAL TABLE

Changes the definition of an external table.

1. ALTER EXTERNAL TABLE <name> <action> [, ... ]

where action is one of:

1. ADD [COLUMN] <new_column> <type>
2. DROP [COLUMN] <column> [RESTRICT|CASCADE]
3. ALTER [COLUMN] <column> TYPE <type>
4. OWNER TO <new_owner>

See ALTER EXTERNAL TABLE for more information.

ALTER FOREIGN DATA WRAPPER

Changes the definition of a foreign-data wrapper.

1. ALTER FOREIGN DATA WRAPPER <name>
2. [ HANDLER <handler_function> | NO HANDLER ]
3. [ VALIDATOR <validator_function> | NO VALIDATOR ]
4. [ OPTIONS ( [ ADD | SET | DROP ] <option> ['<value>'] [, ... ] ) ]

6. ALTER FOREIGN DATA WRAPPER <name> OWNER TO <new_owner>
7. ALTER FOREIGN DATA WRAPPER <name> RENAME TO <new_name>

See ALTER FOREIGN DATA WRAPPER for more information.

ALTER FOREIGN TABLE

Changes the definition of a foreign table.

1. ALTER FOREIGN TABLE [ IF EXISTS ] <name>
2. <action> [, ... ]
3. ALTER FOREIGN TABLE [ IF EXISTS ] <name>
4. RENAME [ COLUMN ] <column_name> TO <new_column_name>
5. ALTER FOREIGN TABLE [ IF EXISTS ] <name>
6. RENAME TO <new_name>
7. ALTER FOREIGN TABLE [ IF EXISTS ] <name>
8. SET SCHEMA <new_schema>

See ALTER FOREIGN TABLE for more information.

ALTER FUNCTION

Changes the definition of a function.

1. ALTER FUNCTION <name> ( [ [<argmode>] [<argname>] <argtype> [, ...] ] )
2. <action> [, ... ] [RESTRICT]

4. ALTER FUNCTION <name> ( [ [<argmode>] [<argname>] <argtype> [, ...] ] )
5. RENAME TO <new_name>

7. ALTER FUNCTION <name> ( [ [<argmode>] [<argname>] <argtype> [, ...] ] )
8. OWNER TO <new_owner>

10. ALTER FUNCTION <name> ( [ [<argmode>] [<argname>] <argtype> [, ...] ] )
11. SET SCHEMA <new_schema>

See ALTER FUNCTION for more information.

ALTER GROUP

Changes a role name or membership.

1. ALTER GROUP <groupname> ADD USER <username> [, ... ]

3. ALTER GROUP <groupname> DROP USER <username> [, ... ]

5. ALTER GROUP <groupname> RENAME TO <newname>

See ALTER GROUP for more information.

ALTER INDEX

Changes the definition of an index.

1. ALTER INDEX [ IF EXISTS ] <name> RENAME TO <new_name>

3. ALTER INDEX [ IF EXISTS ] <name> SET TABLESPACE <tablespace_name>

5. ALTER INDEX [ IF EXISTS ] <name> SET ( <storage_parameter> = <value> [, ...] )

7. ALTER INDEX [ IF EXISTS ] <name> RESET ( <storage_parameter>  [, ...] )

9. ALTER INDEX ALL IN TABLESPACE <name> [ OWNED BY <role_name> [, ... ] ]
10. SET TABLESPACE <new_tablespace> [ NOWAIT ]

See ALTER INDEX for more information.

ALTER LANGUAGE

Changes the name of a procedural language.

1. ALTER LANGUAGE <name> RENAME TO <newname>
2. ALTER LANGUAGE <name> OWNER TO <new_owner>

See ALTER LANGUAGE for more information.

ALTER MATERIALIZED VIEW

Changes the definition of a materialized view.

1. ALTER MATERIALIZED VIEW [ IF EXISTS ] <name> <action> [, ... ]
2. ALTER MATERIALIZED VIEW [ IF EXISTS ] <name>
3. RENAME [ COLUMN ] <column_name> TO <new_column_name>
4. ALTER MATERIALIZED VIEW [ IF EXISTS ] <name>
5. RENAME TO <new_name>
6. ALTER MATERIALIZED VIEW [ IF EXISTS ] <name>
7. SET SCHEMA <new_schema>
8. ALTER MATERIALIZED VIEW ALL IN TABLESPACE <name> [ OWNED BY <role_name> [, ... ] ]
9. SET TABLESPACE <new_tablespace> [ NOWAIT ]

11. where <action> is one of:

13. ALTER [ COLUMN ] <column_name> SET STATISTICS <integer>
14. ALTER [ COLUMN ] <column_name> SET ( <attribute_option> = <value> [, ... ] )
15. ALTER [ COLUMN ] <column_name> RESET ( <attribute_option> [, ... ] )
16. ALTER [ COLUMN ] <column_name> SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
17. CLUSTER ON <index_name>
18. SET WITHOUT CLUSTER
19. SET ( <storage_paramete>r = <value> [, ... ] )
20. RESET ( <storage_parameter> [, ... ] )
21. OWNER TO <new_owner>

See ALTER MATERIALIZED VIEW for more information.

ALTER OPERATOR

Changes the definition of an operator.

1. ALTER OPERATOR <name> ( {<left_type> | NONE} , {<right_type> | NONE} )
2. OWNER TO <new_owner>

4. ALTER OPERATOR <name> ( {<left_type> | NONE} , {<right_type> | NONE} )
5. SET SCHEMA <new_schema>

See ALTER OPERATOR for more information.

ALTER OPERATOR CLASS

Changes the definition of an operator class.

1. ALTER OPERATOR CLASS <name> USING <index_method> RENAME TO <new_name>

3. ALTER OPERATOR CLASS <name> USING <index_method> OWNER TO <new_owner>

5. ALTER OPERATOR CLASS <name> USING <index_method> SET SCHEMA <new_schema>

See ALTER OPERATOR CLASS for more information.

ALTER OPERATOR FAMILY

Changes the definition of an operator family.

1. ALTER OPERATOR FAMILY <name> USING <index_method> ADD
2. {  OPERATOR <strategy_number> <operator_name> ( <op_type>, <op_type> ) [ FOR SEARCH | FOR ORDER BY <sort_family_name> ]
3. | FUNCTION <support_number> [ ( <op_type> [ , <op_type> ] ) ] <funcname> ( <argument_type> [, ...] )
4. } [, ... ]

6. ALTER OPERATOR FAMILY <name> USING <index_method> DROP
7. {  OPERATOR <strategy_number> ( <op_type>, <op_type> )
8. | FUNCTION <support_number> [ ( <op_type> [ , <op_type> ] )
9. } [, ... ]

11. ALTER OPERATOR FAMILY <name> USING <index_method> RENAME TO <new_name>

13. ALTER OPERATOR FAMILY <name> USING <index_method> OWNER TO <new_owner>

15. ALTER OPERATOR FAMILY <name> USING <index_method> SET SCHEMA <new_schema>

See ALTER OPERATOR FAMILY for more information.

ALTER PROTOCOL

Changes the definition of a protocol.

1. ALTER PROTOCOL <name> RENAME TO <newname>

3. ALTER PROTOCOL <name> OWNER TO <newowner>

See ALTER PROTOCOL for more information.

ALTER RESOURCE GROUP

Changes the limits of a resource group.

1. ALTER RESOURCE GROUP <name> SET <group_attribute> <value>

See ALTER RESOURCE GROUP for more information.

ALTER RESOURCE QUEUE

Changes the limits of a resource queue.

1. ALTER RESOURCE QUEUE <name> WITH ( <queue_attribute>=<value> [, ... ] )

See ALTER RESOURCE QUEUE for more information.

ALTER ROLE

Changes a database role (user or group).

1. ALTER ROLE <name> [ [ WITH ] <option> [ ... ] ]

3. where <option> can be:

5. SUPERUSER | NOSUPERUSER
6. | CREATEDB | NOCREATEDB
7. | CREATEROLE | NOCREATEROLE
8. | CREATEEXTTABLE | NOCREATEEXTTABLE  [ ( attribute='value' [, ...] )
9. where attributes and values are:
10. type='readable'|'writable'
11. protocol='gpfdist'|'http'
12. | INHERIT | NOINHERIT
13. | LOGIN | NOLOGIN
14. | REPLICATION | NOREPLICATION
15. | CONNECTION LIMIT <connlimit>
16. | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<password>'
17. | VALID UNTIL '<timestamp>'

19. ALTER ROLE <name> RENAME TO <new_name>

21. ALTER ROLE { <name> | ALL } [ IN DATABASE <database_name> ] SET <configuration_parameter> { TO | = } { <value> | DEFAULT }
22. ALTER ROLE { <name> | ALL } [ IN DATABASE <database_name> ] SET <configuration_parameter> FROM CURRENT
23. ALTER ROLE { <name> | ALL } [ IN DATABASE <database_name> ] RESET <configuration_parameter>
24. ALTER ROLE { <name> | ALL } [ IN DATABASE <database_name> ] RESET ALL
25. ALTER ROLE <name> RESOURCE QUEUE {<queue_name> | NONE}
26. ALTER ROLE <name> RESOURCE GROUP {<group_name> | NONE}

See ALTER ROLE for more information.

ALTER RULE

Changes the definition of a rule.

1. ALTER RULE name ON table\_name RENAME TO new\_name

See ALTER RULE for more information.

ALTER SCHEMA

Changes the definition of a schema.

1. ALTER SCHEMA <name> RENAME TO <newname>

3. ALTER SCHEMA <name> OWNER TO <newowner>

See ALTER SCHEMA for more information.

ALTER SEQUENCE

Changes the definition of a sequence generator.

1. ALTER SEQUENCE [ IF EXISTS ] <name> [INCREMENT [ BY ] <increment>]
2. [MINVALUE <minvalue> | NO MINVALUE]
3. [MAXVALUE <maxvalue> | NO MAXVALUE]
4. [START [ WITH ] <start> ]
5. [RESTART [ [ WITH ] <restart>] ]
6. [CACHE <cache>] [[ NO ] CYCLE]
7. [OWNED BY {<table.column> | NONE}]

9. ALTER SEQUENCE [ IF EXISTS ] <name> OWNER TO <new_owner>

11. ALTER SEQUENCE [ IF EXISTS ] <name> RENAME TO <new_name>

13. ALTER SEQUENCE [ IF EXISTS ] <name> SET SCHEMA <new_schema>

See ALTER SEQUENCE for more information.

ALTER SERVER

Changes the definition of a foreign server.

1. ALTER SERVER <server_name> [ VERSION '<new_version>' ]
2. [ OPTIONS ( [ ADD | SET | DROP ] <option> ['<value>'] [, ... ] ) ]

4. ALTER SERVER <server_name> OWNER TO <new_owner>

6. ALTER SERVER <server_name> RENAME TO <new_name>

See ALTER SERVER for more information.

ALTER TABLE

Changes the definition of a table.

1. ALTER TABLE [IF EXISTS] [ONLY] <name>
2. <action> [, ... ]

4. ALTER TABLE [IF EXISTS] [ONLY] <name>
5. RENAME [COLUMN] <column_name> TO <new_column_name>

7. ALTER TABLE [ IF EXISTS ] [ ONLY ] <name>
8. RENAME CONSTRAINT <constraint_name> TO <new_constraint_name>

10. ALTER TABLE [IF EXISTS] <name>
11. RENAME TO <new_name>

13. ALTER TABLE [IF EXISTS] <name>
14. SET SCHEMA <new_schema>

16. ALTER TABLE ALL IN TABLESPACE <name> [ OWNED BY <role_name> [, ... ] ]
17. SET TABLESPACE <new_tablespace> [ NOWAIT ]

19. ALTER TABLE [IF EXISTS] [ONLY] <name> SET
20. WITH (REORGANIZE=true|false)
21. | DISTRIBUTED BY ({<column_name> [<opclass>]} [, ... ] )
22. | DISTRIBUTED RANDOMLY
23. | DISTRIBUTED REPLICATED

25. ALTER TABLE <name>
26. [ ALTER PARTITION { <partition_name> | FOR (RANK(<number>))
27. | FOR (<value>) } [...] ] <partition_action>

29. where <action> is one of:

31. ADD [COLUMN] <column_name data_type> [ DEFAULT <default_expr> ]
32. [<column_constraint> [ ... ]]
33. [ COLLATE <collation> ]
34. [ ENCODING ( <storage_parameter> [,...] ) ]
35. DROP [COLUMN] [IF EXISTS] <column_name> [RESTRICT | CASCADE]
36. ALTER [COLUMN] <column_name> [ SET DATA ] TYPE <type> [COLLATE <collation>] [USING <expression>]
37. ALTER [COLUMN] <column_name> SET DEFAULT <expression>
38. ALTER [COLUMN] <column_name> DROP DEFAULT
39. ALTER [COLUMN] <column_name> { SET | DROP } NOT NULL
40. ALTER [COLUMN] <column_name> SET STATISTICS <integer>
41. ALTER [COLUMN] column SET ( <attribute_option> = <value> [, ... ] )
42. ALTER [COLUMN] column RESET ( <attribute_option> [, ... ] )
43. ADD <table_constraint> [NOT VALID]
44. ADD <table_constraint_using_index>
45. VALIDATE CONSTRAINT <constraint_name>
46. DROP CONSTRAINT [IF EXISTS] <constraint_name> [RESTRICT | CASCADE]
47. DISABLE TRIGGER [<trigger_name> | ALL | USER]
48. ENABLE TRIGGER [<trigger_name> | ALL | USER]
49. CLUSTER ON <index_name>
50. SET WITHOUT CLUSTER
51. SET WITHOUT OIDS
52. SET (<storage_parameter> = <value>)
53. RESET (<storage_parameter> [, ... ])
54. INHERIT <parent_table>
55. NO INHERIT <parent_table>
56. OF `type_name`
57. NOT OF
58. OWNER TO <new_owner>
59. SET TABLESPACE <new_tablespace>

See ALTER TABLE for more information.

ALTER TABLESPACE

Changes the definition of a tablespace.

1. ALTER TABLESPACE <name> RENAME TO <new_name>

3. ALTER TABLESPACE <name> OWNER TO <new_owner>

5. ALTER TABLESPACE <name> SET ( <tablespace_option> = <value> [, ... ] )

7. ALTER TABLESPACE <name> RESET ( <tablespace_option> [, ... ] )

See ALTER TABLESPACE for more information.

ALTER TEXT SEARCH CONFIGURATION

Changes the definition of a text search configuration.

1. ALTER TEXT SEARCH CONFIGURATION <name>
2. ALTER MAPPING FOR <token_type> [, ... ] WITH <dictionary_name> [, ... ]
3. ALTER TEXT SEARCH CONFIGURATION <name>
4. ALTER MAPPING REPLACE <old_dictionary> WITH <new_dictionary>
5. ALTER TEXT SEARCH CONFIGURATION <name>
6. ALTER MAPPING FOR <token_type> [, ... ] REPLACE <old_dictionary> WITH <new_dictionary>
7. ALTER TEXT SEARCH CONFIGURATION <name>
8. DROP MAPPING [ IF EXISTS ] FOR <token_type> [, ... ]
9. ALTER TEXT SEARCH CONFIGURATION <name> RENAME TO <new_name>
10. ALTER TEXT SEARCH CONFIGURATION <name> OWNER TO <new_owner>
11. ALTER TEXT SEARCH CONFIGURATION <name> SET SCHEMA <new_schema>

See ALTER TEXT SEARCH CONFIGURATION for more information.

ALTER TEXT SEARCH DICTIONARY

Changes the definition of a text search dictionary.

1. ALTER TEXT SEARCH DICTIONARY <name> (
2. <option> [ = <value> ] [, ... ]
3. )
4. ALTER TEXT SEARCH DICTIONARY <name> RENAME TO <new_name>
5. ALTER TEXT SEARCH DICTIONARY <name> OWNER TO <new_owner>
6. ALTER TEXT SEARCH DICTIONARY <name> SET SCHEMA <new_schema>

See ALTER TEXT SEARCH DICTIONARY for more information.

ALTER TEXT SEARCH PARSER

Changes the definition of a text search parser.

1. ALTER TEXT SEARCH PARSER <name> RENAME TO <new_name>
2. ALTER TEXT SEARCH PARSER <name> SET SCHEMA <new_schema>

See ALTER TEXT SEARCH PARSER for more information.

ALTER TEXT SEARCH TEMPLATE

Changes the definition of a text search template.

1. ALTER TEXT SEARCH TEMPLATE <name> RENAME TO <new_name>
2. ALTER TEXT SEARCH TEMPLATE <name> SET SCHEMA <new_schema>

See ALTER TEXT SEARCH TEMPLATE for more information.

ALTER TYPE

Changes the definition of a data type.

2. ALTER TYPE <name> <action> [, ... ]
3. ALTER TYPE <name> OWNER TO <new_owner>
4. ALTER TYPE <name> RENAME ATTRIBUTE <attribute_name> TO <new_attribute_name> [ CASCADE | RESTRICT ]
5. ALTER TYPE <name> RENAME TO <new_name>
6. ALTER TYPE <name> SET SCHEMA <new_schema>
7. ALTER TYPE <name> ADD VALUE [ IF NOT EXISTS ] <new_enum_value> [ { BEFORE | AFTER } <existing_enum_value> ]
8. ALTER TYPE <name> SET DEFAULT ENCODING ( <storage_directive> )

10. where <action> is one of:

12. ADD ATTRIBUTE <attribute_name> <data_type> [ COLLATE <collation> ] [ CASCADE | RESTRICT ]
13. DROP ATTRIBUTE [ IF EXISTS ] <attribute_name> [ CASCADE | RESTRICT ]
14. ALTER ATTRIBUTE <attribute_name> [ SET DATA ] TYPE <data_type> [ COLLATE <collation> ] [ CASCADE | RESTRICT ]

See ALTER TYPE for more information.

ALTER USER

Changes the definition of a database role (user).

1. ALTER USER <name> RENAME TO <newname>

3. ALTER USER <name> SET <config_parameter> {TO | =} {<value> | DEFAULT}

5. ALTER USER <name> RESET <config_parameter>

7. ALTER USER <name> RESOURCE QUEUE {<queue_name> | NONE}

9. ALTER USER <name> RESOURCE GROUP {<group_name> | NONE}

11. ALTER USER <name> [ [WITH] <option> [ ... ] ]

See ALTER USER for more information.

ALTER USER MAPPING

Changes the definition of a user mapping for a foreign server.

1. ALTER USER MAPPING FOR { <username> | USER | CURRENT_USER | PUBLIC }
2. SERVER <servername>
3. OPTIONS ( [ ADD | SET | DROP ] <option> ['<value>'] [, ... ] )

See ALTER USER MAPPING for more information.

ALTER VIEW

Changes properties of a view.

1. ALTER VIEW [ IF EXISTS ] <name> ALTER [ COLUMN ] <column_name> SET DEFAULT <expression>

3. ALTER VIEW [ IF EXISTS ] <name> ALTER [ COLUMN ] <column_name> DROP DEFAULT

5. ALTER VIEW [ IF EXISTS ] <name> OWNER TO <new_owner>

7. ALTER VIEW [ IF EXISTS ] <name> RENAME TO <new_name>

9. ALTER VIEW [ IF EXISTS ] <name> SET SCHEMA <new_schema>

11. ALTER VIEW [ IF EXISTS ] <name> SET ( <view_option_name> [= <view_option_value>] [, ... ] )

13. ALTER VIEW [ IF EXISTS ] <name> RESET ( <view_option_name> [, ... ] )

See ALTER VIEW for more information.

ANALYZE

Collects statistics about a database.

1. ANALYZE [VERBOSE] [<table> [ (<column> [, ...] ) ]]

3. ANALYZE [VERBOSE] {<root_partition_table_name>|<leaf_partition_table_name>} [ (<column> [, ...] )]

5. ANALYZE [VERBOSE] ROOTPARTITION {ALL | <root_partition_table_name> [ (<column> [, ...] )]}

See ANALYZE for more information.

BEGIN

Starts a transaction block.

1. BEGIN [WORK | TRANSACTION] [<transaction_mode>]

See BEGIN for more information.

CHECKPOINT

Forces a transaction log checkpoint.

1. CHECKPOINT

See CHECKPOINT for more information.

CLOSE

Closes a cursor.

1. CLOSE <cursor_name>

See CLOSE for more information.

CLUSTER

Physically reorders a heap storage table on disk according to an index. Not a recommended operation in Greenplum Database.

1. CLUSTER <indexname> ON <tablename>

3. CLUSTER [VERBOSE] <tablename> [ USING index_name ]

5. CLUSTER [VERBOSE]

See CLUSTER for more information.

COMMENT

Defines or changes the comment of an object.

1. COMMENT ON
2. { TABLE <object_name> |
3. COLUMN <relation_name.column_name> |
4. AGGREGATE <agg_name> (<agg_signature>) |
5. CAST (<source_type> AS <target_type>) |
6. COLLATION <object_name>
7. CONSTRAINT <constraint_name> ON <table_name> |
8. CONVERSION <object_name> |
9. DATABASE <object_name> |
10. DOMAIN <object_name> |
11. EXTENSION <object_name> |
12. FOREIGN DATA WRAPPER <object_name> |
13. FOREIGN TABLE <object_name> |
14. FUNCTION <func_name> ([[<argmode>] [<argname>] <argtype> [, ...]]) |
15. INDEX <object_name> |
16. LARGE OBJECT <large_object_oid> |
17. MATERIALIZED VIEW <object_name> |
18. OPERATOR <operator_name> (<left_type>, <right_type>) |
19. OPERATOR CLASS <object_name> USING <index_method> |
20. [PROCEDURAL] LANGUAGE <object_name> |
21. RESOURCE GROUP <object_name> |
22. RESOURCE QUEUE <object_name> |
23. ROLE <object_name> |
24. RULE <rule_name> ON <table_name> |
25. SCHEMA <object_name> |
26. SEQUENCE <object_name> |
27. SERVER <object_name> |
28. TABLESPACE <object_name> |
29. TEXT SEARCH CONFIGURATION <object_name> |
30. TEXT SEARCH DICTIONARY <object_name> |
31. TEXT SEARCH PARSER <object_name> |
32. TEXT SEARCH TEMPLATE <object_name> |
33. TRIGGER <trigger_name> ON <table_name> |
34. TYPE <object_name> |
35. VIEW <object_name> }
36. IS '<text>'

See COMMENT for more information.

COMMIT

Commits the current transaction.

1. COMMIT [WORK | TRANSACTION]

See COMMIT for more information.

COPY

Copies data between a file and a table.

1. COPY <table_name> [(<column_name> [, ...])]
2. FROM {'<filename>' | PROGRAM '<command>' | STDIN}
3. [ [ WITH ] ( <option> [, ...] ) ]
4. [ ON SEGMENT ]

6. COPY { <table_name> [(<column_name> [, ...])] | (<query>)}
7. TO {'<filename>' | PROGRAM '<command>' | STDOUT}
8. [ [ WITH ] ( <option> [, ...] ) ]
9. [ ON SEGMENT ]

See COPY for more information.

CREATE AGGREGATE

Defines a new aggregate function.

1. CREATE AGGREGATE <name> ( [ <argmode> ] [ <argname> ] <arg_data_type> [ , ... ] ) (
2. SFUNC = <statefunc>,
3. STYPE = <state_data_type>
4. [ , SSPACE = <state_data_size> ]
5. [ , FINALFUNC = <ffunc> ]
6. [ , FINALFUNC_EXTRA ]
7. [ , COMBINEFUNC = <combinefunc> ]
8. [ , SERIALFUNC = <serialfunc> ]
9. [ , DESERIALFUNC = <deserialfunc> ]
10. [ , INITCOND = <initial_condition> ]
11. [ , MSFUNC = <msfunc> ]
12. [ , MINVFUNC = <minvfunc> ]
13. [ , MSTYPE = <mstate_data_type> ]
14. [ , MSSPACE = <mstate_data_size> ]
15. [ , MFINALFUNC = <mffunc> ]
16. [ , MFINALFUNC_EXTRA ]
17. [ , MINITCOND = <minitial_condition> ]
18. [ , SORTOP = <sort_operator> ]
19. )

21. CREATE AGGREGATE <name> ( [ [ <argmode> ] [ <argname> ] <arg_data_type> [ , ... ] ]
22. ORDER BY [ <argmode> ] [ <argname> ] <arg_data_type> [ , ... ] ) (
23. SFUNC = <statefunc>,
24. STYPE = <state_data_type>
25. [ , SSPACE = <state_data_size> ]
26. [ , FINALFUNC = <ffunc> ]
27. [ , FINALFUNC_EXTRA ]
28. [ , COMBINEFUNC = <combinefunc> ]
29. [ , SERIALFUNC = <serialfunc> ]
30. [ , DESERIALFUNC = <deserialfunc> ]
31. [ , INITCOND = <initial_condition> ]
32. [ , HYPOTHETICAL ]
33. )

35. or the old syntax

37. CREATE AGGREGATE <name> (
38. BASETYPE = <base_type>,
39. SFUNC = <statefunc>,
40. STYPE = <state_data_type>
41. [ , SSPACE = <state_data_size> ]
42. [ , FINALFUNC = <ffunc> ]
43. [ , FINALFUNC_EXTRA ]
44. [ , COMBINEFUNC = <combinefunc> ]
45. [ , SERIALFUNC = <serialfunc> ]
46. [ , DESERIALFUNC = <deserialfunc> ]
47. [ , INITCOND = <initial_condition> ]
48. [ , MSFUNC = <msfunc> ]
49. [ , MINVFUNC = <minvfunc> ]
50. [ , MSTYPE = <mstate_data_type> ]
51. [ , MSSPACE = <mstate_data_size> ]
52. [ , MFINALFUNC = <mffunc> ]
53. [ , MFINALFUNC_EXTRA ]
54. [ , MINITCOND = <minitial_condition> ]
55. [ , SORTOP = <sort_operator> ]
56. )

See CREATE AGGREGATE for more information.

CREATE CAST

Defines a new cast.

1. CREATE CAST (<sourcetype> AS <targettype>)
2. WITH FUNCTION <funcname> (<argtype> [, ...])
3. [AS ASSIGNMENT | AS IMPLICIT]

5. CREATE CAST (<sourcetype> AS <targettype>)
6. WITHOUT FUNCTION
7. [AS ASSIGNMENT | AS IMPLICIT]

9. CREATE CAST (<sourcetype> AS <targettype>)
10. WITH INOUT
11. [AS ASSIGNMENT | AS IMPLICIT]

See CREATE CAST for more information.

CREATE COLLATION

Defines a new collation using the specified operating system locale settings, or by copying an existing collation.

1. CREATE COLLATION <name> (
2. [ LOCALE = <locale>, ]
3. [ LC_COLLATE = <lc_collate>, ]
4. [ LC_CTYPE = <lc_ctype> ])

6. CREATE COLLATION <name> FROM <existing_collation>

See CREATE COLLATION for more information.

CREATE CONVERSION

Defines a new encoding conversion.

1. CREATE [DEFAULT] CONVERSION <name> FOR <source_encoding> TO
2. <dest_encoding> FROM <funcname>

See CREATE CONVERSION for more information.

CREATE DATABASE

Creates a new database.

1. CREATE DATABASE name [ [WITH] [OWNER [=] <user_name>]
2. [TEMPLATE [=] <template>]
3. [ENCODING [=] <encoding>]
4. [LC_COLLATE [=] <lc_collate>]
5. [LC_CTYPE [=] <lc_ctype>]
6. [TABLESPACE [=] <tablespace>]
7. [CONNECTION LIMIT [=] connlimit ] ]

See CREATE DATABASE for more information.

CREATE DOMAIN

Defines a new domain.

1. CREATE DOMAIN <name> [AS] <data_type> [DEFAULT <expression>]
2. [ COLLATE <collation> ]
3. [ CONSTRAINT <constraint_name>
4. | NOT NULL | NULL
5. | CHECK (<expression>) [...]]

See CREATE DOMAIN for more information.

CREATE EXTENSION

Registers an extension in a Greenplum database.

1. CREATE EXTENSION [ IF NOT EXISTS ] <extension_name>
2. [ WITH ] [ SCHEMA <schema_name> ]
3. [ VERSION <version> ]
4. [ FROM <old_version> ]
5. [ CASCADE ]

See CREATE EXTENSION for more information.

CREATE EXTERNAL TABLE

Defines a new external table.

1. CREATE [READABLE] EXTERNAL [TEMPORARY | TEMP] TABLE <table_name>
2. ( <column_name> <data_type> [, ...] | LIKE <other_table >)
3. LOCATION ('file://<seghost>[:<port>]/<path>/<file>' [, ...])
4. | ('gpfdist://<filehost>[:<port>]/<file_pattern>[#transform=<trans_name>]'
5. [, ...]
6. | ('gpfdists://<filehost>[:<port>]/<file_pattern>[#transform=<trans_name>]'
7. [, ...])
8. | ('pxf://<path-to-data>?PROFILE=<profile_name>[&SERVER=<server_name>][&<custom-option>=<value>[...]]'))
9. | ('s3://<S3_endpoint>[:<port>]/<bucket_name>/[<S3_prefix>] [region=<S3-region>] [config=<config_file> | config_server=<url>]')
10. [ON MASTER]
11. FORMAT 'TEXT'
12. [( [HEADER]
13. [DELIMITER [AS] '<delimiter>' | 'OFF']
14. [NULL [AS] '<null string>']
15. [ESCAPE [AS] '<escape>' | 'OFF']
16. [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']
17. [FILL MISSING FIELDS] )]
18. | 'CSV'
19. [( [HEADER]
20. [QUOTE [AS] '<quote>']
21. [DELIMITER [AS] '<delimiter>']
22. [NULL [AS] '<null string>']
23. [FORCE NOT NULL <column> [, ...]]
24. [ESCAPE [AS] '<escape>']
25. [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']
26. [FILL MISSING FIELDS] )]
27. | 'CUSTOM' (Formatter=<<formatter_specifications>>)
28. [ ENCODING '<encoding>' ]
29. [ [LOG ERRORS [PERSISTENTLY]] SEGMENT REJECT LIMIT <count>
30. [ROWS | PERCENT] ]

32. CREATE [READABLE] EXTERNAL WEB [TEMPORARY | TEMP] TABLE <table_name>
33. ( <column_name> <data_type> [, ...] | LIKE <other_table >)
34. LOCATION ('http://<webhost>[:<port>]/<path>/<file>' [, ...])
35. | EXECUTE '<command>' [ON ALL
36. | MASTER
37. | <number_of_segments>
38. | HOST ['<segment_hostname>']
39. | SEGMENT <segment_id> ]
40. FORMAT 'TEXT'
41. [( [HEADER]
42. [DELIMITER [AS] '<delimiter>' | 'OFF']
43. [NULL [AS] '<null string>']
44. [ESCAPE [AS] '<escape>' | 'OFF']
45. [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']
46. [FILL MISSING FIELDS] )]
47. | 'CSV'
48. [( [HEADER]
49. [QUOTE [AS] '<quote>']
50. [DELIMITER [AS] '<delimiter>']
51. [NULL [AS] '<null string>']
52. [FORCE NOT NULL <column> [, ...]]
53. [ESCAPE [AS] '<escape>']
54. [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']
55. [FILL MISSING FIELDS] )]
56. | 'CUSTOM' (Formatter=<<formatter specifications>>)
57. [ ENCODING '<encoding>' ]
58. [ [LOG ERRORS [PERSISTENTLY]] SEGMENT REJECT LIMIT <count>
59. [ROWS | PERCENT] ]

61. CREATE WRITABLE EXTERNAL [TEMPORARY | TEMP] TABLE <table_name>
62. ( <column_name> <data_type> [, ...] | LIKE <other_table >)
63. LOCATION('gpfdist://<outputhost>[:<port>]/<filename>[#transform=<trans_name>]'
64. [, ...])
65. | ('gpfdists://<outputhost>[:<port>]/<file_pattern>[#transform=<trans_name>]'
66. [, ...])
67. FORMAT 'TEXT'
68. [( [DELIMITER [AS] '<delimiter>']
69. [NULL [AS] '<null string>']
70. [ESCAPE [AS] '<escape>' | 'OFF'] )]
71. | 'CSV'
72. [([QUOTE [AS] '<quote>']
73. [DELIMITER [AS] '<delimiter>']
74. [NULL [AS] '<null string>']
75. [FORCE QUOTE <column> [, ...]] | * ]
76. [ESCAPE [AS] '<escape>'] )]

78. | 'CUSTOM' (Formatter=<<formatter specifications>>)
79. [ ENCODING '<write_encoding>' ]
80. [ DISTRIBUTED BY ({<column> [<opclass>]}, [ ... ] ) | DISTRIBUTED RANDOMLY ]

82. CREATE WRITABLE EXTERNAL [TEMPORARY | TEMP] TABLE <table_name>
83. ( <column_name> <data_type> [, ...] | LIKE <other_table >)
84. LOCATION('s3://<S3_endpoint>[:<port>]/<bucket_name>/[<S3_prefix>] [region=<S3-region>] [config=<config_file> | config_server=<url>]')
85. [ON MASTER]
86. FORMAT 'TEXT'
87. [( [DELIMITER [AS] '<delimiter>']
88. [NULL [AS] '<null string>']
89. [ESCAPE [AS] '<escape>' | 'OFF'] )]
90. | 'CSV'
91. [([QUOTE [AS] '<quote>']
92. [DELIMITER [AS] '<delimiter>']
93. [NULL [AS] '<null string>']
94. [FORCE QUOTE <column> [, ...]] | * ]
95. [ESCAPE [AS] '<escape>'] )]

97. CREATE WRITABLE EXTERNAL WEB [TEMPORARY | TEMP] TABLE <table_name>
98. ( <column_name> <data_type> [, ...] | LIKE <other_table> )
99. EXECUTE '<command>' [ON ALL]
100. FORMAT 'TEXT'
101. [( [DELIMITER [AS] '<delimiter>']
102. [NULL [AS] '<null string>']
103. [ESCAPE [AS] '<escape>' | 'OFF'] )]
104. | 'CSV'
105. [([QUOTE [AS] '<quote>']
106. [DELIMITER [AS] '<delimiter>']
107. [NULL [AS] '<null string>']
108. [FORCE QUOTE <column> [, ...]] | * ]
109. [ESCAPE [AS] '<escape>'] )]
110. | 'CUSTOM' (Formatter=<<formatter specifications>>)
111. [ ENCODING '<write_encoding>' ]
112. [ DISTRIBUTED BY ({<column> [<opclass>]}, [ ... ] ) | DISTRIBUTED RANDOMLY ]

See CREATE EXTERNAL TABLE for more information.

CREATE FOREIGN DATA WRAPPER

Defines a new foreign-data wrapper.

1. CREATE FOREIGN DATA WRAPPER <name>
2. [ HANDLER <handler_function> | NO HANDLER ]
3. [ VALIDATOR <validator_function> | NO VALIDATOR ]
4. [ OPTIONS ( [ mpp_execute { 'master' | 'any' | 'all segments' } [, ] ] <option> '<value>' [, ... ] ) ]

See CREATE FOREIGN DATA WRAPPER for more information.

CREATE FOREIGN TABLE

Defines a new foreign table.

1. CREATE FOREIGN TABLE [ IF NOT EXISTS ] <table_name> ( [
2. <column_name> <data_type> [ OPTIONS ( <option> '<value>' [, ... ] ) ] [ COLLATE <collation> ] [ <column_constraint> [ ... ] ]
3. [, ... ]
4. ] )
5. SERVER <server_name>
6. [ OPTIONS ( [ mpp_execute { 'master' | 'any' | 'all segments' } [, ] ] <option> '<value>' [, ... ] ) ]

See CREATE FOREIGN TABLE for more information.

CREATE FUNCTION

Defines a new function.

1. CREATE [OR REPLACE] FUNCTION <name>
2. ( [ [<argmode>] [<argname>] <argtype> [ { DEFAULT | = } <default_expr> ] [, ...] ] )
3. [ RETURNS <rettype>
4. | RETURNS TABLE ( <column_name> <column_type> [, ...] ) ]
5. { LANGUAGE <langname>
6. | WINDOW
7. | IMMUTABLE | STABLE | VOLATILE | [NOT] LEAKPROOF
8. | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
9. | NO SQL | CONTAINS SQL | READS SQL DATA | MODIFIES SQL
10. | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER
11. | EXECUTE ON { ANY | MASTER | ALL SEGMENTS | INITPLAN }
12. | COST <execution_cost>
13. | SET <configuration_parameter> { TO <value> | = <value> | FROM CURRENT }
14. | AS '<definition>'
15. | AS '<obj_file>', '<link_symbol>' } ...
16. [ WITH ({ DESCRIBE = describe_function
17. } [, ...] ) ]

See CREATE FUNCTION for more information.

CREATE GROUP

Defines a new database role.

CREATE GROUP <name> [[WITH] <option> [ ... ]]

See CREATE GROUP for more information.

CREATE INDEX

Defines a new index.

CREATE [UNIQUE] INDEX [<name>] ON <table_name> [USING <method>]
       ( {<column_name> | (<expression>)} [COLLATE <parameter>] [<opclass>] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
       [ WITH ( <storage_parameter> = <value> [, ... ] ) ]
       [ TABLESPACE <tablespace> ]
       [ WHERE <predicate> ]

See CREATE INDEX for more information.

CREATE LANGUAGE

Defines a new procedural language.

CREATE [ OR REPLACE ] [ PROCEDURAL ] LANGUAGE <name>

CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE <name>
    HANDLER <call_handler> [ INLINE <inline_handler> ]
   [ VALIDATOR <valfunction> ]

See CREATE LANGUAGE for more information.

CREATE MATERIALIZED VIEW

Defines a new materialized view.

CREATE MATERIALIZED VIEW <table_name>
    [ (<column_name> [, ...] ) ]
    [ WITH ( <storage_parameter> [= <value>] [, ... ] ) ]
    [ TABLESPACE <tablespace_name> ]
    AS <query>
    [ WITH [ NO ] DATA ]
    [DISTRIBUTED {| BY <column> [<opclass>], [ ... ] | RANDOMLY | REPLICATED }]

See CREATE MATERIALIZED VIEW for more information.

CREATE OPERATOR

Defines a new operator.

CREATE OPERATOR <name> (
       PROCEDURE = <funcname>
       [, LEFTARG = <lefttype>] [, RIGHTARG = <righttype>]
       [, COMMUTATOR = <com_op>] [, NEGATOR = <neg_op>]
       [, RESTRICT = <res_proc>] [, JOIN = <join_proc>]
       [, HASHES] [, MERGES] )

See CREATE OPERATOR for more information.

CREATE OPERATOR CLASS

Defines a new operator class.

CREATE OPERATOR CLASS <name> [DEFAULT] FOR TYPE <data_type>
  USING <index_method> [ FAMILY <family_name> ] AS
  { OPERATOR <strategy_number> <operator_name> [ ( <op_type>, <op_type> ) ] [ FOR SEARCH | FOR ORDER BY <sort_family_name> ]
  | FUNCTION <support_number> <funcname> (<argument_type> [, ...] )
  | STORAGE <storage_type>
  } [, ... ]

See CREATE OPERATOR CLASS for more information.

CREATE OPERATOR FAMILY

Defines a new operator family.

CREATE OPERATOR FAMILY <name>  USING <index_method>

See CREATE OPERATOR FAMILY for more information.

CREATE PROTOCOL

Registers a custom data access protocol that can be specified when defining a Greenplum Database external table.

CREATE [TRUSTED] PROTOCOL <name> (
   [readfunc='<read_call_handler>'] [, writefunc='<write_call_handler>']
   [, validatorfunc='<validate_handler>' ])

See CREATE PROTOCOL for more information.

CREATE RESOURCE GROUP

Defines a new resource group.

CREATE RESOURCE GROUP <name> WITH (<group_attribute>=<value> [, ... ])

See CREATE RESOURCE GROUP for more information.

CREATE RESOURCE QUEUE

Defines a new resource queue.

CREATE RESOURCE QUEUE <name> WITH (<queue_attribute>=<value> [, ... ])

See CREATE RESOURCE QUEUE for more information.

CREATE ROLE

Defines a new database role (user or group).

CREATE ROLE <name> [[WITH] <option> [ ... ]]

See CREATE ROLE for more information.

CREATE RULE

Defines a new rewrite rule.

CREATE [OR REPLACE] RULE <name> AS ON <event>
  TO <table_name> [WHERE <condition>]
  DO [ALSO | INSTEAD] { NOTHING | <command> | (<command>; <command>
  ...) }

See CREATE RULE for more information.

CREATE SCHEMA

Defines a new schema.

CREATE SCHEMA <schema_name> [AUTHORIZATION <username>]
   [<schema_element> [ ... ]]

CREATE SCHEMA AUTHORIZATION <rolename> [<schema_element> [ ... ]]

CREATE SCHEMA IF NOT EXISTS <schema_name> [ AUTHORIZATION <user_name> ]

CREATE SCHEMA IF NOT EXISTS AUTHORIZATION <user_name>

See CREATE SCHEMA for more information.

CREATE SEQUENCE

Defines a new sequence generator.

CREATE [TEMPORARY | TEMP] SEQUENCE <name>
       [INCREMENT [BY] <value>]
       [MINVALUE <minvalue> | NO MINVALUE]
       [MAXVALUE <maxvalue> | NO MAXVALUE]
       [START [ WITH ] <start>]
       [CACHE <cache>]
       [[NO] CYCLE]
       [OWNED BY { <table>.<column> | NONE }]

See CREATE SEQUENCE for more information.

CREATE SERVER

Defines a new foreign server.

CREATE SERVER <server_name> [ TYPE '<server_type>' ] [ VERSION '<server_version>' ]
    FOREIGN DATA WRAPPER <fdw_name>
    [ OPTIONS ( [ mpp_execute { 'master' | 'any' | 'all segments' } [, ] ]
                [ num_segments '<num>' [, ] ]
                [ <option> '<value>' [, ... ]] ) ]

See CREATE SERVER for more information.

CREATE TABLE

Defines a new table.

CREATE [ [GLOBAL | LOCAL] {TEMPORARY | TEMP } | UNLOGGED] TABLE [IF NOT EXISTS]
  <table_name> (
  [ { <column_name> <data_type> [ COLLATE <collation> ] [<column_constraint> [ ... ] ]
[ ENCODING ( <storage_directive> [, ...] ) ]
    | <table_constraint>
    | LIKE <source_table> [ <like_option> ... ] }
    | [ <column_reference_storage_directive> [, ...]
    [, ... ]
] )
[ INHERITS ( <parent_table> [, ... ] ) ]
[ WITH ( <storage_parameter> [=<value>] [, ... ] ) ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
[ TABLESPACE <tablespace_name> ]
[ DISTRIBUTED BY (<column> [<opclass>], [ ... ] )
       | DISTRIBUTED RANDOMLY | DISTRIBUTED REPLICATED ]

{ --partitioned table using SUBPARTITION TEMPLATE
[ PARTITION BY <partition_type> (<column>)
  {  [ SUBPARTITION BY <partition_type> (<column1>)
       SUBPARTITION TEMPLATE ( <template_spec> ) ]
          [ SUBPARTITION BY partition_type (<column2>)
            SUBPARTITION TEMPLATE ( <template_spec> ) ]
              [...]  }
  ( <partition_spec> ) ]
} |

{ **-- partitioned table without SUBPARTITION TEMPLATE
**[ PARTITION BY <partition_type> (<column>)
   [ SUBPARTITION BY <partition_type> (<column1>) ]
      [ SUBPARTITION BY <partition_type> (<column2>) ]
         [...]
  ( <partition_spec>
     [ ( <subpartition_spec_column1>
          [ ( <subpartition_spec_column2>
               [...] ) ] ) ],
  [ <partition_spec>
     [ ( <subpartition_spec_column1>
        [ ( <subpartition_spec_column2>
             [...] ) ] ) ], ]
    [...]
  ) ]
}

CREATE [ [GLOBAL | LOCAL] {TEMPORARY | TEMP} | UNLOGGED ] TABLE [IF NOT EXISTS]
   <table_name>
    OF <type_name> [ (
  { <column_name> WITH OPTIONS [ <column_constraint> [ ... ] ]
    | <table_constraint> }
    [, ... ]
) ]
[ WITH ( <storage_parameter> [=<value>] [, ... ] ) ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
[ TABLESPACE <tablespace_name> ]

See CREATE TABLE for more information.

CREATE TABLE AS

Defines a new table from the results of a query.

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE <table_name>
        [ (<column_name> [, ...] ) ]
        [ WITH ( <storage_parameter> [= <value>] [, ... ] ) | WITHOUT OIDS ]
        [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
        [ TABLESPACE <tablespace_name> ]
        AS <query>
        [ WITH [ NO ] DATA ]
        [ DISTRIBUTED BY (column [, ... ] ) | DISTRIBUTED RANDOMLY | DISTRIBUTED REPLICATED ]

See CREATE TABLE AS for more information.

CREATE TABLESPACE

Defines a new tablespace.

CREATE TABLESPACE <tablespace_name> [OWNER <username>]  LOCATION '</path/to/dir>'
   [WITH (content<ID_1>='</path/to/dir1>'[, content<ID_2>='</path/to/dir2>' ... ])]

See CREATE TABLESPACE for more information.

CREATE TEXT SEARCH CONFIGURATION

Defines a new text search configuration.

CREATE TEXT SEARCH CONFIGURATION <name> (
    PARSER = <parser_name> |
    COPY = <source_config>
)

See CREATE TEXT SEARCH CONFIGURATION for more information.

CREATE TEXT SEARCH DICTIONARY

Defines a new text search dictionary.

CREATE TEXT SEARCH DICTIONARY <name> (
    TEMPLATE = <template>
    [, <option> = <value> [, ... ]]
)

See CREATE TEXT SEARCH DICTIONARY for more information.

CREATE TEXT SEARCH PARSER

Defines a new text search parser.

``` CREATE TEXT SEARCH PARSER name ( START = start_function , GETTOKEN = gettoken_function , END = end_function

（本文超出站点单文档体积上限，已截断）