SQL Syntax Summary

ABORT

Aborts 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> ( <type> [ , ... ] ) RENAME TO <new_name>

3. ALTER AGGREGATE <name> ( <type> [ , ... ] ) OWNER TO <new_owner>

5. ALTER AGGREGATE <name> ( <type> [ , ... ] ) SET SCHEMA <new_schema>

See ALTER AGGREGATE 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>

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> SET <parameter> { TO | = } { <value> | DEFAULT }

5. ALTER DATABASE <name> RESET <parameter>

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

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

See ALTER DATABASE 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>

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

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

11. 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. * | [ <argmode> ] [ <argname> ] <argtype> [ , ... ] |
38. [ [ <argmode> ] [ <argname> ] <argtype> [ , ... ] ]
39. 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> [USING <expression>]
4. OWNER TO <new_owner>

See ALTER EXTERNAL TABLE for more information.

ALTER FILESPACE

Changes the definition of a filespace.

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

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

See ALTER FILESPACE 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 <name> RENAME TO <new_name>

3. ALTER INDEX <name> SET TABLESPACE <tablespace_name>

5. ALTER INDEX <name> SET ( FILLFACTOR = <value> )

7. ALTER INDEX <name> RESET ( FILLFACTOR )

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 OPERATOR

Changes the definition of an operator.

1. ALTER OPERATOR <name> ( {<lefttype> | NONE} , {<righttype> | NONE} )
2. OWNER TO <newowner>

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 <newname>

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

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> ) [ RECHECK ]
3. | FUNCTION <support_number> [ ( <op_type> [ , <op_type> ] ) ] <funcname> ( <argument_type> [, ...] )
4. } [, ... ]
5. ALTER OPERATOR FAMILY <name> USING <index_method> DROP
6. {  OPERATOR s<trategy_number> ( <op_type>, <op_type> )
7. | FUNCTION <support_number> [ ( <op_type> [ , <op_type> ] )
8. } [, ... ]

10. ALTER OPERATOR FAMILY <name> USING <index_method> RENAME TO <newname>

12. ALTER OPERATOR FAMILY <name> USING <index_method> OWNER TO <newowner>

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> RENAME TO <newname>

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

5. ALTER ROLE <name> RESET <config_parameter>

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

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

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

See ALTER ROLE 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 <name> [INCREMENT [ BY ] <increment>]
2. [MINVALUE <minvalue> | NO MINVALUE]
3. [MAXVALUE <maxvalue> | NO MAXVALUE]
4. [RESTART [ WITH ] <start>]
5. [CACHE <cache>] [[ NO ] CYCLE]
6. [OWNED BY {<table.column> | NONE}]

8. ALTER SEQUENCE <name> RENAME TO new\_name

10. ALTER SEQUENCE <name> SET SCHEMA <new_schema>

See ALTER SEQUENCE for more information.

ALTER TABLE

Changes the definition of a table.

1. ALTER TABLE [ONLY] <name> RENAME [COLUMN] <column> TO <new_column>

3. ALTER TABLE <name> RENAME TO <new_name>

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

7. ALTER TABLE [ONLY] <name> SET
8. DISTRIBUTED BY (<column>, [ ... ] )
9. | DISTRIBUTED RANDOMLY
10. | WITH (REORGANIZE=true|false)

12. ALTER TABLE [ONLY] <name> <action> [, ... ]

14. ALTER TABLE <name>
15. [ ALTER PARTITION { <partition_name> | FOR (RANK(<number>))
16. | FOR (<value>) } [...] ] <partition_action>

18. where <action> is one of:

20. ADD [COLUMN] <column_name data_type> [ DEFAULT <default_expr> ]
21. [<column_constraint> [ ... ]]
22. [ ENCODING ( <storage_directive> [,...] ) ]
23. DROP [COLUMN] <column> [RESTRICT | CASCADE]
24. ALTER [COLUMN] <column> TYPE <type> [USING <expression>]
25. ALTER [COLUMN] <column> SET DEFAULT <expression>
26. ALTER [COLUMN] <column> DROP DEFAULT
27. ALTER [COLUMN] <column> { SET | DROP } NOT NULL
28. ALTER [COLUMN] <column> SET STATISTICS <integer>
29. ADD <table_constraint>
30. DROP CONSTRAINT <constraint_name> [RESTRICT | CASCADE]
31. DISABLE TRIGGER [<trigger_name> | ALL | USER]
32. ENABLE TRIGGER [<trigger_name> | ALL | USER]
33. CLUSTER ON <index_name>
34. SET WITHOUT CLUSTER
35. SET WITHOUT OIDS
36. SET (FILLFACTOR = <value>)
37. RESET (FILLFACTOR)
38. INHERIT <parent_table>
39. NO INHERIT <parent_table>
40. OWNER TO <new_owner>
41. SET TABLESPACE <new_tablespace>

See ALTER TABLE for more information.

ALTER TABLESPACE

Changes the definition of a tablespace.

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

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

See ALTER TABLESPACE for more information.

ALTER TYPE

Changes the definition of a data type.

1. ALTER TYPE <name>
2. OWNER TO <new_owner> | SET SCHEMA <new_schema>

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 VIEW

Changes the definition of a view.

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

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>]
2. [READ ONLY | READ WRITE]

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 <tablename>

5. CLUSTER

See CLUSTER for more information.

COMMENT

Defines or change the comment of an object.

1. COMMENT ON
2. { TABLE <object_name> |
3. COLUMN <table_name.column_name> |
4. AGGREGATE <agg_name> (<agg_type> [, ...]) |
5. CAST (<sourcetype> AS <targettype>) |
6. CONSTRAINT <constraint_name> ON <table_name> |
7. CONVERSION <object_name> |
8. DATABASE <object_name> |
9. DOMAIN <object_name> |
10. FILESPACE <object_name> |
11. FUNCTION <func_name> ([[<argmode>] [<argname>] <argtype> [, ...]]) |
12. INDEX <object_name> |
13. LARGE OBJECT <large_object_oid> |
14. OPERATOR <op> (<leftoperand_type>, <rightoperand_type>) |
15. OPERATOR CLASS <object_name> USING <index_method> |
16. [PROCEDURAL] LANGUAGE <object_name> |
17. RESOURCE QUEUE <object_name> |
18. ROLE <object_name> |
19. RULE <rule_name> ON <table_name> |
20. SCHEMA <object_name> |
21. SEQUENCE <object_name> |
22. TABLESPACE <object_name> |
23. TRIGGER <trigger_name> ON <table_name> |
24. TYPE <object_name> |
25. VIEW <object_name> }
26. 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> [(<column> [, ...])] FROM {'<file>' | PROGRAM '<command>' | STDIN}
2. [ [WITH]
3. [ON SEGMENT]
4. [BINARY]
5. [OIDS]
6. [HEADER]
7. [DELIMITER [ AS ] '<delimiter>']
8. [NULL [ AS ] '<null string>']
9. [ESCAPE [ AS ] '<escape>' | 'OFF']
10. [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']
11. [CSV [QUOTE [ AS ] '<quote>']
12. [FORCE NOT NULL <column> [, ...]]
13. [FILL MISSING FIELDS]
14. [[LOG ERRORS]
15. SEGMENT REJECT LIMIT <count> [ROWS | PERCENT] ]

17. COPY {table [(<column> [, ...])] | (<query>)} TO {'<file>' | PROGRAM '<command>' | STDOUT}
18. [ [WITH]
19. [ON SEGMENT]
20. [BINARY]
21. [OIDS]
22. [HEADER]
23. [DELIMITER [ AS ] 'delimiter']
24. [NULL [ AS ] 'null string']
25. [ESCAPE [ AS ] '<escape>' | 'OFF']
26. [CSV [QUOTE [ AS ] 'quote']
27. [FORCE QUOTE column [, ...]] ]
28. [IGNORE EXTERNAL PARTITIONS ]

See COPY for more information.

CREATE AGGREGATE

Defines a new aggregate function.

1. CREATE [ORDERED] AGGREGATE <name> (<input_data_type> [ , ... ])
2. ( SFUNC = <sfunc>,
3. STYPE = <state_data_type>
4. [, PREFUNC = <prefunc>]
5. [, FINALFUNC = <ffunc>]
6. [, INITCOND = <initial_condition>]
7. [, SORTOP = <sort_operator>] )

See CREATE AGGREGATE for more information.

CREATE CAST

Defines a new cast.

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

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

See CREATE CAST 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 [=] <dbowner>]
2. [TEMPLATE [=] <template>]
3. [ENCODING [=] <encoding>]
4. [TABLESPACE [=] <tablespace>]
5. [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. [CONSTRAINT <constraint_name>
3. | NOT NULL | NULL
4. | 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. | ('gphdfs://<hdfs_host>[:port]/<path>/<file>')
9. | ('pxf://<path-to-data>?<PROFILE>[&<custom-option>=<value>[...]]'))
10. | ('s3://<S3_endpoint>[:<port>]/<bucket_name>/[<S3_prefix>] [region=<S3-region>] [config=<config_file>]')
11. [ON MASTER]
12. FORMAT 'TEXT'
13. [( [HEADER]
14. [DELIMITER [AS] '<delimiter>' | 'OFF']
15. [NULL [AS] '<null string>']
16. [ESCAPE [AS] '<escape>' | 'OFF']
17. [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']
18. [FILL MISSING FIELDS] )]
19. | 'CSV'
20. [( [HEADER]
21. [QUOTE [AS] '<quote>']
22. [DELIMITER [AS] '<delimiter>']
23. [NULL [AS] '<null string>']
24. [FORCE NOT NULL <column> [, ...]]
25. [ESCAPE [AS] '<escape>']
26. [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF']
27. [FILL MISSING FIELDS] )]
28. | 'AVRO'
29. | 'PARQUET'
30. | 'CUSTOM' (Formatter=<<formatter_specifications>>)
31. [ ENCODING '<encoding>' ]
32. [ [LOG ERRORS [PERSISTENTLY]] SEGMENT REJECT LIMIT <count>
33. [ROWS | PERCENT] ]

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

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

84. | 'CUSTOM' (Formatter=<<formatter specifications>>)
85. [ ENCODING '<write_encoding>' ]
86. [ DISTRIBUTED BY (<column>, [ ... ] ) | DISTRIBUTED RANDOMLY ]

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

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

See CREATE EXTERNAL TABLE for more information.

CREATE FUNCTION

Defines a new function.

1. CREATE [OR REPLACE] FUNCTION <name>
2. ( [ [<argmode>] [<argname>] <argtype> [ { DEFAULT | = } <defexpr> ] [, ...] ] )
3. [ RETURNS { [ SETOF ] rettype
4. | TABLE ([{ argname argtype | LIKE other table }
5. [, ...]])
6. } ]
7. { LANGUAGE <langname>
8. | IMMUTABLE | STABLE | VOLATILE
9. | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
10. | NO SQL | CONTAINS SQL | READS SQL DATA | MODIFIES SQL
11. | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER
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.

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

See CREATE GROUP for more information.

CREATE INDEX

Defines a new index.

1. CREATE [UNIQUE] INDEX <name> ON <table>
2. [USING btree|bitmap|gist]
3. ( {<column> | (<expression>)} [<opclass>] [, ...] )
4. [ WITH ( FILLFACTOR = <value> ) ]
5. [TABLESPACE <tablespace>]
6. [WHERE <predicate>]

See CREATE INDEX for more information.

CREATE LANGUAGE

Defines a new procedural language.

1. CREATE [PROCEDURAL] LANGUAGE <name>

3. CREATE [TRUSTED] [PROCEDURAL] LANGUAGE <name>
4. HANDLER <call_handler> [ INLINE <inline_handler> ] [VALIDATOR <valfunction>]

See CREATE LANGUAGE for more information.

CREATE OPERATOR

Defines a new operator.

1. CREATE OPERATOR <name> (
2. PROCEDURE = <funcname>
3. [, LEFTARG = <lefttype>] [, RIGHTARG = <righttype>]
4. [, COMMUTATOR = <com_op>] [, NEGATOR = <neg_op>]
5. [, RESTRICT = <res_proc>] [, JOIN = <join_proc>]
6. [, HASHES] [, MERGES] )

See CREATE OPERATOR for more information.

CREATE OPERATOR CLASS

Defines a new operator class.

1. CREATE OPERATOR CLASS <name> [DEFAULT] FOR TYPE <data_type>
2. USING <index_method> AS
3. {
4. OPERATOR <strategy_number> <op_name> [(<op_type>, <op_type>)] [RECHECK]
5. | FUNCTION <support_number> <funcname> (<argument_type> [, ...] )
6. | STORAGE <storage_type>
7. } [, ... ]

See CREATE OPERATOR CLASS for more information.

CREATE OPERATOR FAMILY

Defines a new operator family.

1. 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.

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

See CREATE PROTOCOL for more information.

CREATE RESOURCE GROUP

Defines a new resource group.

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

See CREATE RESOURCE GROUP for more information.

CREATE RESOURCE QUEUE

Defines a new resource queue.

1. 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).

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

See CREATE ROLE for more information.

CREATE RULE

Defines a new rewrite rule.

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

See CREATE RULE for more information.

CREATE SCHEMA

Defines a new schema.

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

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

See CREATE SCHEMA for more information.

CREATE SEQUENCE

Defines a new sequence generator.

1. CREATE [TEMPORARY | TEMP] SEQUENCE <name>
2. [INCREMENT [BY] <value>]
3. [MINVALUE <minvalue> | NO MINVALUE]
4. [MAXVALUE <maxvalue> | NO MAXVALUE]
5. [START [ WITH ] <start>]
6. [CACHE <cache>]
7. [[NO] CYCLE]
8. [OWNED BY { <table>.<column> | NONE }]

See CREATE SEQUENCE for more information.

CREATE TABLE

Defines a new table.

1. CREATE [[GLOBAL | LOCAL] {TEMPORARY | TEMP}] TABLE <table_name> (
2. [ { <column_name> <data_type> [ DEFAULT <default_expr> ]
3. [<column_constraint> [ ... ]
4. [ ENCODING ( <storage_directive> [,...] ) ]
5. ]
6. | <table_constraint>
7. | LIKE <other_table> [{INCLUDING | EXCLUDING}
8. {DEFAULTS | CONSTRAINTS}] ...}
9. [, ... ] ]
10. )
11. [ INHERITS ( <parent_table> [, ... ] ) ]
12. [ WITH ( <storage_parameter>=<value> [, ... ] )
13. [ ON COMMIT {PRESERVE ROWS | DELETE ROWS | DROP} ]
14. [ TABLESPACE <tablespace> ]
15. [ DISTRIBUTED BY (<column>, [ ... ] ) | DISTRIBUTED RANDOMLY ]
16. [ PARTITION BY <partition_type> (<column>)
17. [ SUBPARTITION BY <partition_type> (<column>) ]
18. [ SUBPARTITION TEMPLATE ( <template_spec >) ]
19. [...]
20. ( <partition_spec> )
21. | [ SUBPARTITION BY <partition_type> (<column>) ]
22. [...]
23. ( <partition_spec>
24. [ ( <subpartition_spec>
25. [(...)]
26. ) ]
27. )

See CREATE TABLE for more information.

CREATE TABLE AS

Defines a new table from the results of a query.

1. CREATE [ [GLOBAL | LOCAL] {TEMPORARY | TEMP} ] TABLE <table_name>
2. [(<column_name> [, ...] )]
3. [ WITH ( <storage_parameter>=<value> [, ... ] ) ]
4. [ON COMMIT {PRESERVE ROWS | DELETE ROWS | DROP}]
5. [TABLESPACE <tablespace>]
6. AS <query>
7. [DISTRIBUTED BY (<column>, [ ... ] ) | DISTRIBUTED RANDOMLY]

See CREATE TABLE AS for more information.

CREATE TABLESPACE

Defines a new tablespace.

1. CREATE TABLESPACE <tablespace_name> [OWNER <username>]
2. FILESPACE <filespace_name>

See CREATE TABLESPACE for more information.

CREATE TYPE

Defines a new data type.

1. CREATE TYPE <name> AS ( <attribute_name> <data_type> [, ... ] )

3. CREATE TYPE <name> AS ENUM ( '<label>' [, ... ] )

5. CREATE TYPE <name> (
6. INPUT = <input_function>,
7. OUTPUT = <output_function>
8. [, RECEIVE = <receive_function>]
9. [, SEND = <send_function>]
10. [, TYPMOD_IN = <type_modifier_input_function> ]
11. [, TYPMOD_OUT = <type_modifier_output_function> ]
12. [, INTERNALLENGTH = {<internallength> | VARIABLE}]
13. [, PASSEDBYVALUE]
14. [, ALIGNMENT = <alignment>]
15. [, STORAGE = <storage>]
16. [, DEFAULT = <default>]
17. [, ELEMENT = <element>]
18. [, DELIMITER = <delimiter>] )

20. CREATE TYPE <name>

See CREATE TYPE for more information.

CREATE USER

Defines a new database role with the LOGIN privilege by default.

1. CREATE USER <name> [[WITH] <option> [ ... ]]

See CREATE USER for more information.

CREATE VIEW

Defines a new view.

1. CREATE [OR REPLACE] [TEMP | TEMPORARY] VIEW <name>
2. [ ( <column_name> [, ...] ) ]
3. AS <query>

See CREATE VIEW for more information.

DEALLOCATE

Deallocates a prepared statement.

1. DEALLOCATE [PREPARE] <name>

See DEALLOCATE for more information.

DECLARE

Defines a cursor.

1. DECLARE <name> [BINARY] [INSENSITIVE] [NO SCROLL] CURSOR
2. [{WITH | WITHOUT} HOLD]
3. FOR <query> [FOR READ ONLY]

See DECLARE for more information.

DELETE

Deletes rows from a table.

1. DELETE FROM [ONLY] <table> [[AS] <alias>]
2. [USING <usinglist>]
3. [WHERE <condition> | WHERE CURRENT OF <cursor_name> ]

See DELETE for more information.

DISCARD

Discards the session state.

1. DISCARD { ALL | PLANS | TEMPORARY | TEMP }

See DISCARD for more information.

DROP AGGREGATE

Removes an aggregate function.

1. DROP AGGREGATE [IF EXISTS] <name> ( <type> [, ...] ) [CASCADE | RESTRICT]

See DROP AGGREGATE for more information.

DO

Executes an anonymous code block as a transient anonymous function.

1. DO [ LANGUAGE <lang_name> ] <code>

See DO for more information.

DROP CAST

Removes a cast.

1. DROP CAST [IF EXISTS] (<sourcetype> AS <targettype>) [CASCADE | RESTRICT]

See DROP CAST for more information.

DROP CONVERSION

Removes a conversion.

1. DROP CONVERSION [IF EXISTS] <name> [CASCADE | RESTRICT]

See DROP CONVERSION for more information.

DROP DATABASE

Removes a database.

1. DROP DATABASE [IF EXISTS] <name>

See DROP DATABASE for more information.

DROP DOMAIN

Removes a domain.

1. DROP DOMAIN [IF EXISTS] <name> [, ...]  [CASCADE | RESTRICT]

See DROP DOMAIN for more information.

DROP EXTENSION

Removes an extension from a Greenplum database.

1. DROP EXTENSION [ IF EXISTS ] <name> [, ...] [ CASCADE | RESTRICT ]

See DROP EXTENSION for more information.

DROP EXTERNAL TABLE

Removes an external table definition.

1. DROP EXTERNAL [WEB] TABLE [IF EXISTS] <name> [CASCADE | RESTRICT]

See DROP EXTERNAL TABLE for more information.

DROP FILESPACE

Removes a filespace.

1. DROP FILESPACE [IF EXISTS] <filespacename>

See DROP FILESPACE for more information.

DROP FUNCTION

Removes a function.

1. DROP FUNCTION [IF EXISTS] name ( [ [argmode] [argname] argtype
2. [, ...] ] ) [CASCADE | RESTRICT]

See DROP FUNCTION for more information.

DROP GROUP

Removes a database role.

1. DROP GROUP [IF EXISTS] <name> [, ...]

See DROP GROUP for more information.

DROP INDEX

Removes an index.

1. DROP INDEX [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]

See DROP INDEX for more information.

DROP LANGUAGE

Removes a procedural language.

1. DROP [PROCEDURAL] LANGUAGE [IF EXISTS] <name> [CASCADE | RESTRICT]

See DROP LANGUAGE for more information.

DROP OPERATOR

Removes an operator.

1. DROP OPERATOR [IF EXISTS] <name> ( {<lefttype> | NONE} ,
2. {<righttype> | NONE} ) [CASCADE | RESTRICT]

See DROP OPERATOR for more information.

DROP OPERATOR CLASS

Removes an operator class.

1. DROP OPERATOR CLASS [IF EXISTS] <name> USING <index_method> [CASCADE | RESTRICT]

See DROP OPERATOR CLASS for more information.

DROP OPERATOR FAMILY

Removes an operator family.

1. DROP OPERATOR FAMILY [IF EXISTS] <name> USING <index_method> [CASCADE | RESTRICT]

See DROP OPERATOR FAMILY for more information.

DROP OWNED

Removes database objects owned by a database role.

1. DROP OWNED BY <name> [, ...] [CASCADE | RESTRICT]

See DROP OWNED for more information.

DROP PROTOCOL

Removes a external table data access protocol from a database.

1. DROP PROTOCOL [IF EXISTS] <name>

See DROP PROTOCOL for more information.

DROP RESOURCE GROUP

Removes a resource group.

1. DROP RESOURCE GROUP <group_name>

See DROP RESOURCE GROUP for more information.

DROP RESOURCE QUEUE

Removes a resource queue.

1. DROP RESOURCE QUEUE <queue_name>

See DROP RESOURCE QUEUE for more information.

DROP ROLE

Removes a database role.

1. DROP ROLE [IF EXISTS] <name> [, ...]

See DROP ROLE for more information.

DROP RULE

Removes a rewrite rule.

1. DROP RULE [IF EXISTS] <name> ON <relation> [CASCADE | RESTRICT]

See DROP RULE for more information.

DROP SCHEMA

Removes a schema.

1. DROP SCHEMA [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]

See DROP SCHEMA for more information.

DROP SEQUENCE

Removes a sequence.

1. DROP SEQUENCE [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]

See DROP SEQUENCE for more information.

DROP TABLE

Removes a table.

1. DROP TABLE [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]

See DROP TABLE for more information.

DROP TABLESPACE

Removes a tablespace.

1. DROP TABLESPACE [IF EXISTS] <tablespacename>

See DROP TABLESPACE for more information.

DROP TYPE

Removes a data type.

1. DROP TYPE [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]

See DROP TYPE for more information.

DROP USER

Removes a database role.

1. DROP USER [IF EXISTS] <name> [, ...]

See DROP USER for more information.

DROP VIEW

Removes a view.

1. DROP VIEW [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]

See DROP VIEW for more information.

END

Commits the current transaction.

1. END [WORK | TRANSACTION]

See END for more information.

EXECUTE

Executes a prepared SQL statement.

1. EXECUTE <name> [ (<parameter> [, ...] ) ]

See EXECUTE for more information.

EXPLAIN

Shows the query plan of a statement.

1. EXPLAIN [ANALYZE] [VERBOSE] <statement>

See EXPLAIN for more information.

FETCH

Retrieves rows from a query using a cursor.

1. FETCH [ <forward_direction> { FROM | IN } ] <cursorname>

See FETCH for more information.

GRANT

Defines access privileges.

1. GRANT { {SELECT | INSERT | UPDATE | DELETE | REFERENCES |
2. TRIGGER | TRUNCATE } [,...] | ALL [PRIVILEGES] }
3. ON [TABLE] <tablename> [, ...]
4. TO {<rolename> | PUBLIC} [, ...] [WITH GRANT OPTION]

6. GRANT { {USAGE | SELECT | UPDATE} [,...] | ALL [PRIVILEGES] }
7. ON SEQUENCE <sequencename> [, ...]
8. TO { <rolename> | PUBLIC } [, ...] [WITH GRANT OPTION]

10. GRANT { {CREATE | CONNECT | TEMPORARY | TEMP} [,...] | ALL
11. [PRIVILEGES] }
12. ON DATABASE <dbname> [, ...]
13. TO {<rolename> | PUBLIC} [, ...] [WITH GRANT OPTION]

15. GRANT { USAGE | ALL [ PRIVILEGES ] }
16. ON FOREIGN DATA WRAPPER <fdwname> [, ...]
17. TO { [ GROUP ] <rolename> | PUBLIC } [, ...] [ WITH GRANT OPTION ]

19. GRANT { USAGE | ALL [ PRIVILEGES ] }
20. ON FOREIGN SERVER <servername> [, ...]
21. TO { [ GROUP ] <rolename> | PUBLIC } [, ...] [ WITH GRANT OPTION ]

23. GRANT { EXECUTE | ALL [PRIVILEGES] }
24. ON FUNCTION <funcname> ( [ [<argmode>] [<argname>] <argtype> [, ...]
25. ] ) [, ...]
26. TO {<rolename> | PUBLIC} [, ...] [WITH GRANT OPTION]

28. GRANT { USAGE | ALL [PRIVILEGES] }
29. ON LANGUAGE <langname> [, ...]
30. TO {<rolename> | PUBLIC} [, ...] [WITH GRANT OPTION]

32. GRANT { {CREATE | USAGE} [,...] | ALL [PRIVILEGES] }
33. ON SCHEMA <schemaname> [, ...]
34. TO {<rolename> | PUBLIC} [, ...] [WITH GRANT OPTION]

36. GRANT { CREATE | ALL [PRIVILEGES] }
37. ON TABLESPACE <tablespacename> [, ...]
38. TO {<rolename> | PUBLIC} [, ...] [WITH GRANT OPTION]

40. GRANT <parent_role> [, ...]
41. TO <member_role> [, ...] [WITH ADMIN OPTION]

43. GRANT { SELECT | INSERT | ALL [PRIVILEGES] }
44. ON PROTOCOL <protocolname>
45. TO <username>

See GRANT for more information.

INSERT

Creates new rows in a table.

1. INSERT INTO <table> [( <column> [, ...] )]
2. {DEFAULT VALUES | VALUES ( {<expression> | DEFAULT} [, ...] )
3. [, ...] | <query>}

See INSERT for more information.

LOAD

Loads or reloads a shared library file.

1. LOAD '<filename>'

See LOAD for more information.

LOCK

Locks a table.

1. LOCK [TABLE] name [, ...] [IN <lockmode> MODE] [NOWAIT]

See LOCK for more information.

MOVE

Positions a cursor.

1. MOVE [ <forward_direction> {FROM | IN} ] <cursorname>

See MOVE for more information.

PREPARE

Prepare a statement for execution.

1. PREPARE <name> [ (<datatype> [, ...] ) ] AS <statement>

See PREPARE for more information.

REASSIGN OWNED

Changes the ownership of database objects owned by a database role.

1. REASSIGN OWNED BY <old_role> [, ...] TO <new_role>

See REASSIGN OWNED for more information.

REINDEX

Rebuilds indexes.

1. REINDEX {INDEX | TABLE | DATABASE | SYSTEM} <name>

See REINDEX for more information.

RELEASE SAVEPOINT

Destroys a previously defined savepoint.

1. RELEASE [SAVEPOINT] <savepoint_name>

See RELEASE SAVEPOINT for more information.

RESET

Restores the value of a system configuration parameter to the default value.

1. RESET <configuration_parameter>

3. RESET ALL

See RESET for more information.

REVOKE

Removes access privileges.

1. REVOKE [GRANT OPTION FOR] { {SELECT | INSERT | UPDATE | DELETE
2. | REFERENCES | TRIGGER | TRUNCATE } [,...] | ALL [PRIVILEGES] }
3. ON [TABLE] <tablename> [, ...]
4. FROM {<rolename> | PUBLIC} [, ...]
5. [CASCADE | RESTRICT]

7. REVOKE [GRANT OPTION FOR] { {USAGE | SELECT | UPDATE} [,...]
8. | ALL [PRIVILEGES] }
9. ON SEQUENCE <sequencename> [, ...]
10. FROM { <rolename> | PUBLIC } [, ...]
11. [CASCADE | RESTRICT]

13. REVOKE [GRANT OPTION FOR] { {CREATE | CONNECT
14. | TEMPORARY | TEMP} [,...] | ALL [PRIVILEGES] }
15. ON DATABASE <dbname> [, ...]
16. FROM {rolename | PUBLIC} [, ...]
17. [CASCADE | RESTRICT]

19. REVOKE [GRANT OPTION FOR] {EXECUTE | ALL [PRIVILEGES]}
20. ON FUNCTION <funcname> ( [[<argmode>] [<argname>] <argtype>
21. [, ...]] ) [, ...]
22. FROM {<rolename> | PUBLIC} [, ...]
23. [CASCADE | RESTRICT]

25. REVOKE [GRANT OPTION FOR] {USAGE | ALL [PRIVILEGES]}
26. ON LANGUAGE <langname> [, ...]
27. FROM {<rolename> | PUBLIC} [, ...]
28. [ CASCADE | RESTRICT ]

30. REVOKE [GRANT OPTION FOR] { {CREATE | USAGE} [,...]
31. | ALL [PRIVILEGES] }
32. ON SCHEMA <schemaname> [, ...]
33. FROM {<rolename> | PUBLIC} [, ...]
34. [CASCADE | RESTRICT]

36. REVOKE [GRANT OPTION FOR] { CREATE | ALL [PRIVILEGES] }
37. ON TABLESPACE <tablespacename> [, ...]
38. FROM { <rolename> | PUBLIC } [, ...]
39. [CASCADE | RESTRICT]

41. REVOKE [ADMIN OPTION FOR] <parent_role> [, ...]
42. FROM <member_role> [, ...]
43. [CASCADE | RESTRICT]

See REVOKE for more information.

ROLLBACK

Aborts the current transaction.

1. ROLLBACK [WORK | TRANSACTION]

See ROLLBACK for more information.

ROLLBACK TO SAVEPOINT

Rolls back the current transaction to a savepoint.

1. ROLLBACK [WORK | TRANSACTION] TO [SAVEPOINT] <savepoint_name>

See ROLLBACK TO SAVEPOINT for more information.

SAVEPOINT

Defines a new savepoint within the current transaction.

1. SAVEPOINT <savepoint_name>

See SAVEPOINT for more information.

SELECT

Retrieves rows from a table or view.

1. [ WITH [ RECURSIVE1 ] <with_query> [, ...] ]
2. SELECT [ALL | DISTINCT [ON (<expression> [, ...])]]
3. * | <expression >[[AS] <output_name>] [, ...]
4. [FROM <from_item> [, ...]]
5. [WHERE <condition>]
6. [GROUP BY <grouping_element> [, ...]]
7. [HAVING <condition> [, ...]]
8. [WINDOW <window_name> AS (<window_specification>)]
9. [{UNION | INTERSECT | EXCEPT} [ALL] <select>]
10. [ORDER BY <expression> [ASC | DESC | USING <operator>] [NULLS {FIRST | LAST}] [, ...]]
11. [LIMIT {<count> | ALL}]
12. [OFFSET <start>]
13. [FOR {UPDATE | SHARE} [OF <table_name> [, ...]] [NOWAIT] [...]]

See SELECT for more information.

SELECT INTO

Defines a new table from the results of a query.

1. [ WITH [ RECURSIVE1 ] <with_query> [, ...] ]
2. SELECT [ALL | DISTINCT [ON ( <expression> [, ...] )]]
3. * | <expression> [AS <output_name>] [, ...]
4. INTO [TEMPORARY | TEMP] [TABLE] <new_table>
5. [FROM <from_item> [, ...]]
6. [WHERE <condition>]
7. [GROUP BY <expression> [, ...]]
8. [HAVING <condition> [, ...]]
9. [{UNION | INTERSECT | EXCEPT} [ALL] <select>]
10. [ORDER BY <expression> [ASC | DESC | USING <operator>] [NULLS {FIRST | LAST}] [, ...]]
11. [LIMIT {<count> | ALL}]
12. [OFFSET <start>]
13. [FOR {UPDATE | SHARE} [OF <table_name> [, ...]] [NOWAIT]
14. [...]]

See SELECT INTO for more information.

SET

Changes the value of a Greenplum Database configuration parameter.

1. SET [SESSION | LOCAL] <configuration_parameter> {TO | =} <value> |
2. '<value>' | DEFAULT}

4. SET [SESSION | LOCAL] TIME ZONE {<timezone> | LOCAL | DEFAULT}

See SET for more information.

SET ROLE

Sets the current role identifier of the current session.

1. SET [SESSION | LOCAL] ROLE <rolename>

3. SET [SESSION | LOCAL] ROLE NONE

5. RESET ROLE

See SET ROLE for more information.

SET SESSION AUTHORIZATION

Sets the session role identifier and the current role identifier of the current session.

1. SET [SESSION | LOCAL] SESSION AUTHORIZATION <rolename>

3. SET [SESSION | LOCAL] SESSION AUTHORIZATION DEFAULT

5. RESET SESSION AUTHORIZATION

See SET SESSION AUTHORIZATION for more information.

SE

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