******************** HELP test ********************
 
# (7.3) SQL command: SELECT
  Description: retrieve rows from a table or view
  Syntax :
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
    * | expression [ AS output_name ] [, ...]
    [ FROM from_item [, ...] ]
    [ WHERE condition ]
    [ GROUP BY expression [, ...] ]
    [ HAVING condition [, ...] ]
    [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
    [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
    [ LIMIT { count | ALL } ]
    [ OFFSET start ]
    [ FOR UPDATE [ OF tablename [, ...] ] ]

where from_item can be:

[ ONLY ] table_name [ * ]
    [ [ AS ] alias [ ( column_alias_list ) ] ]
|
( select )
    [ AS ] alias [ ( column_alias_list ) ]
|
table_function_name ( [ argument [, ...] ] )
    [ AS ] alias [ ( column_alias_list | column_definition_list ) ]
|
table_function_name ( [ argument [, ...] ] )
    AS ( column_definition_list )
|
from_item [ NATURAL ] join_type from_item
    [ ON join_condition | USING ( join_column_list ) ]

# (7.3) SQL command: CREATE TABLE
  Description: define a new table
  Syntax :
CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
    { column_name data_type [ DEFAULT default_expr ] [ column_constraint [, ... ] ]
    | table_constraint }  [, ... ]
)
[ INHERITS ( parent_table [, ... ] ) ]
[ WITH OIDS | WITHOUT OIDS ]

where column_constraint is:

[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | UNIQUE | PRIMARY KEY |
  CHECK (expression) |
  REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]
    [ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

and table_constraint is:

[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
  PRIMARY KEY ( column_name [, ... ] ) |
  CHECK ( expression ) |
  FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
    [ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

# (7.3) SQL command: CONNECT
  Description: Connect database
  Syntax :
CONNECT TO dbname[@server[:port]] | DEFAULT
      [AS connect_name] [USER user_name [password | NULL]];
      ex)
      CONNECT TO dbname@xxx.com AS db1 USER admin;
      CONNECT TO postgres USER postgres;

# (7.3) SQL command: DISCONNECT
  Description: Disconnect database
  Syntax :
DISCONNECT { connect_name | CURRENT | DEFAULT | ALL }
      ex)
      CONNECT TO dbname@xxx.com AS db1 USER xuser
      DISCONNECT db1

# (7.3) SQL command: SET CONNECTION
  Description: Set current connection_name
  Syntax :
SET CONNECTION { connect_name | DEFAULT }

# (7.3) SQL command: SET EXEC_SQL_OPTION
  Description: Set *exec_sql* bash builtin function to option
  Syntax :
SET EXEC_SQL_OPTION DEFAULT
      SET EXEC_SQL_OPTION CGI;
      SET option_name[=value]
      ex)
      set OPTION_ECHO=ON;          ...turn on  ECHO mode
      set OPTION_ECHO=OFF;         ...turn off ECHO mode
      set OPTION_SEPARATOR=',';    ...set SEPARATOR to ','
      set OPTION_SEPARATOR;        ...set SEPARATOR to DEFAULT
      set option_nullstring='*N*'; ...set NULL_STRING to '*N*'


# (7.3) SQL command: COPY TABLE()
  Description: Copies data between *client-side* files and server tables
  Syntax :
COPY table([ c1, .. ]) {TO|FROM}{ 'filename' | stdout | stdin }
      [ [USING] DELIMITERS 'delimiter' ]
      [ WITH NULL AS 'null string' ]
      ex)
      COPY table() from '/tmp/test.dat'
      COPY table(oid,a1,a2) to '/tmp/test.dat' WITH NULL AS 'NULL'

# HELP: Command Name List:
    ABORT                     ALTER DATABASE            ALTER GROUP              
    ALTER TABLE               ALTER TRIGGER             ALTER USER               
    ANALYZE                   BEGIN                     CHECKPOINT               
    CLOSE                     CLUSTER                   COMMENT                  
    COMMIT                    CONNECT                   COPY                     
    COPY TABLE()              CREATE AGGREGATE          CREATE CAST              
    CREATE CONSTRAINT TRIGGER CREATE CONVERSION         CREATE DATABASE          
    CREATE DOMAIN             CREATE FUNCTION           CREATE GROUP             
    CREATE INDEX              CREATE LANGUAGE           CREATE OPERATOR CLASS    
    CREATE OPERATOR           CREATE RULE               CREATE SCHEMA            
    CREATE SEQUENCE           CREATE TABLE              CREATE TABLE AS          
    CREATE TRIGGER            CREATE TYPE               CREATE USER              
    CREATE VIEW               DEALLOCATE                DECLARE                  
    DELETE                    DISCONNECT                DROP AGGREGATE           
    DROP CAST                 DROP CONVERSION           DROP DATABASE            
    DROP DOMAIN               DROP FUNCTION             DROP GROUP               
    DROP INDEX                DROP LANGUAGE             DROP OPERATOR CLASS      
    DROP OPERATOR             DROP RULE                 DROP SCHEMA              
    DROP SEQUENCE             DROP TABLE                DROP TRIGGER             
    DROP TYPE                 DROP USER                 DROP VIEW                
    END                       EXECUTE                   EXPLAIN                  
    FETCH                     FETCH INTO                GRANT                    
    INSERT                    LISTEN                    LOAD                     
    LOCK                      MOVE                      NOTIFY                   
    PREPARE                   REINDEX                   RESET                    
    REVOKE                    ROLLBACK                  SELECT                   
    SELECT INTO               SET                       SET CONNECTION           
    SET CONSTRAINTS           SET EXEC_SQL_OPTION       SET SESSION AUTHORIZATION
    SET TRANSACTION           SHOW                      START TRANSACTION        
    TRUNCATE                  UNLISTEN                  UPDATE                   
    VACUUM                    
# (7.3) SQL command: ABORT
  Description: abort the current transaction
  Syntax :
ABORT [ WORK | TRANSACTION ]

# (7.3) SQL command: ALTER DATABASE
  Description: change a database
  Syntax :
ALTER DATABASE name SET variable { TO | = } { value | DEFAULT }
ALTER DATABASE name RESET variable

# (7.3) SQL command: ALTER GROUP
  Description: add users to a group or remove users from a group
  Syntax :
ALTER GROUP name ADD USER username [, ... ]
ALTER GROUP name DROP USER username [, ... ]

# (7.3) SQL command: ALTER TABLE
  Description: change the definition of a table
  Syntax :
ALTER TABLE [ ONLY ] table [ * ]
    ADD [ COLUMN ] column type [ column_constraint [ ... ] ]
ALTER TABLE [ ONLY ] table [ * ]
    DROP [ COLUMN ] column [ RESTRICT | CASCADE ]
ALTER TABLE [ ONLY ] table [ * ]
    ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }
ALTER TABLE [ ONLY ] table [ * ]
    ALTER [ COLUMN ] column { SET | DROP } NOT NULL
ALTER TABLE [ ONLY ] table [ * ]
    ALTER [ COLUMN ] column SET STATISTICS integer
ALTER TABLE [ ONLY ] table [ * ]
    ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
ALTER TABLE [ ONLY ] table [ * ]
    RENAME [ COLUMN ] column TO new_column
ALTER TABLE table
    RENAME TO new_table
ALTER TABLE [ ONLY ] table [ * ]
    ADD table_constraint
ALTER TABLE [ ONLY ] table [ * ]
    DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
ALTER TABLE table
    OWNER TO new_owner

# (7.3) SQL command: ALTER TRIGGER
  Description: change the definition of a trigger
  Syntax :
ALTER TRIGGER trigger ON table
    RENAME TO newname

# (7.3) SQL command: ALTER USER
  Description: change a database user account
  Syntax :
ALTER USER username [ [ WITH ] option [ ... ] ]

where option can be:

      [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' 
    | CREATEDB | NOCREATEDB
    | CREATEUSER | NOCREATEUSER 
    | VALID UNTIL 'abstime'

ALTER USER username SET variable { TO | = } { value | DEFAULT }
ALTER USER username RESET variable

# (7.3) SQL command: ANALYZE
  Description: collect statistics about a database
  Syntax :
ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]

# (7.3) SQL command: BEGIN
  Description: start a transaction block
  Syntax :
BEGIN [ WORK | TRANSACTION ]

# (7.3) SQL command: CHECKPOINT
  Description: force a transaction log checkpoint
  Syntax :
CHECKPOINT

# (7.3) SQL command: CLOSE
  Description: close a cursor
  Syntax :
CLOSE cursor

# (7.3) SQL command: CLUSTER
  Description: cluster a table according to an index
  Syntax :
CLUSTER indexname ON tablename

# (7.3) SQL command: COMMENT
  Description: define or change the comment of an object
  Syntax :
COMMENT ON
[
  TABLE object_name |
  COLUMN table_name.column_name |
  AGGREGATE agg_name (agg_type) |
  CONSTRAINT constraint_name ON table_name |
  DATABASE object_name |
  DOMAIN object_name |
  FUNCTION func_name (arg1_type, arg2_type, ...) |
  INDEX object_name |
  OPERATOR op (leftoperand_type, rightoperand_type) |
  RULE rule_name ON table_name |
  SCHEMA object_name |
  SEQUENCE object_name |
  TRIGGER trigger_name ON table_name |
  TYPE object_name |
  VIEW object_name
] IS 'text'

# (7.3) SQL command: COMMIT
  Description: commit the current transaction
  Syntax :
COMMIT [ WORK | TRANSACTION ]

# (7.3) SQL command: CONNECT
  Description: Connect database
  Syntax :
CONNECT TO dbname[@server[:port]] | DEFAULT
      [AS connect_name] [USER user_name [password | NULL]];
      ex)
      CONNECT TO dbname@xxx.com AS db1 USER admin;
      CONNECT TO postgres USER postgres;

# (7.3) SQL command: COPY
  Description: copy data between files and tables
  Syntax :
COPY table [ ( column [, ...] ) ]
    FROM { 'filename' | stdin }
    [ [ WITH ] 
          [ BINARY ] 
          [ OIDS ]
          [ DELIMITER [ AS ] 'delimiter' ]
          [ NULL [ AS ] 'null string' ] ]
COPY table [ ( column [, ...] ) ]
    TO { 'filename' | stdout }
    [ [ WITH ] 
          [ BINARY ]
          [ OIDS ]
          [ DELIMITER [ AS ] 'delimiter' ]
          [ NULL [ AS ] 'null string' ] ]

# (7.3) SQL command: COPY TABLE()
  Description: Copies data between *client-side* files and server tables
  Syntax :
COPY table([ c1, .. ]) {TO|FROM}{ 'filename' | stdout | stdin }
      [ [USING] DELIMITERS 'delimiter' ]
      [ WITH NULL AS 'null string' ]
      ex)
      COPY table() from '/tmp/test.dat'
      COPY table(oid,a1,a2) to '/tmp/test.dat' WITH NULL AS 'NULL'

# (7.3) SQL command: CREATE AGGREGATE
  Description: define a new aggregate function
  Syntax :
CREATE AGGREGATE name ( BASETYPE = input_data_type,
    SFUNC = sfunc, STYPE = state_type
    [ , FINALFUNC = ffunc ]
    [ , INITCOND = initial_condition ] )

# (7.3) SQL command: CREATE CAST
  Description: define a user-defined cast
  Syntax :
CREATE CAST (sourcetype AS targettype)
    WITH FUNCTION funcname (argtype)
    [ AS ASSIGNMENT | AS IMPLICIT ]

CREATE CAST (sourcetype AS targettype)
    WITHOUT FUNCTION
    [ AS ASSIGNMENT | AS IMPLICIT ]

# (7.3) SQL command: CREATE CONSTRAINT TRIGGER
  Description: define a new constraint trigger
  Syntax :
CREATE CONSTRAINT TRIGGER name
    AFTER events ON
    relation constraint attributes
    FOR EACH ROW EXECUTE PROCEDURE func '(' args ')'

# (7.3) SQL command: CREATE CONVERSION
  Description: define a user-defined conversion
  Syntax :
CREATE [DEFAULT] CONVERSION conversion_name
    FOR source_encoding TO dest_encoding FROM funcname

# (7.3) SQL command: CREATE DATABASE
  Description: create a new database
  Syntax :
CREATE DATABASE name
    [ [ WITH ] [ OWNER [=] dbowner ]
           [ LOCATION [=] 'dbpath' ]
           [ TEMPLATE [=] template ]
           [ ENCODING [=] encoding ] ]

# (7.3) SQL command: CREATE DOMAIN
  Description: define a new domain
  Syntax :
CREATE DOMAIN domainname [AS] data_type
    [ DEFAULT default_expr ]
    [ constraint [, ... ] ]

where constraint is:

[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL }

# (7.3) SQL command: CREATE FUNCTION
  Description: define a new function
  Syntax :
CREATE [ OR REPLACE ] FUNCTION name ( [ argtype [, ...] ] )
    RETURNS rettype
  { LANGUAGE langname
    | IMMUTABLE | STABLE | VOLATILE
    | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
    | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER
    | AS 'definition'
    | AS 'obj_file', 'link_symbol'
  } ...
    [ WITH ( attribute [, ...] ) ]

# (7.3) SQL command: CREATE GROUP
  Description: define a new user group
  Syntax :
CREATE GROUP name [ [ WITH ] option [ ... ] ]

where option can be:

     SYSID gid
   | USER  username [, ...]

# (7.3) SQL command: CREATE INDEX
  Description: define a new index
  Syntax :
CREATE [ UNIQUE ] INDEX index_name ON table
    [ USING acc_method ] ( column [ ops_name ] [, ...] )
    [ WHERE predicate ]
CREATE [ UNIQUE ] INDEX index_name ON table
    [ USING acc_method ] ( func_name( column [, ... ]) [ ops_name ] )
    [ WHERE predicate ]

# (7.3) SQL command: CREATE LANGUAGE
  Description: define a new procedural language
  Syntax :
CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE langname
    HANDLER call_handler [ VALIDATOR valfunction ]

# (7.3) SQL command: CREATE OPERATOR CLASS
  Description: define a new operator class for indexes
  Syntax :
CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING access_method AS
  {  OPERATOR strategy_number operator_id [ ( type, type ) ] [ RECHECK ]
   | FUNCTION support_number func_name ( parameter_types )
   | STORAGE storage_type
  } [, ... ]

# (7.3) SQL command: CREATE OPERATOR
  Description: define a new operator
  Syntax :
CREATE OPERATOR name ( PROCEDURE = func_name
     [, LEFTARG = lefttype
     ] [, RIGHTARG = righttype ]
     [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]
     [, RESTRICT = res_proc ] [, JOIN = join_proc ]
     [, HASHES ] [, MERGES ]
     [, SORT1 = left_sort_op ] [, SORT2 = right_sort_op ]
     [, LTCMP = less_than_op ] [, GTCMP = greater_than_op ] )

# (7.3) SQL command: CREATE RULE
  Description: define a new rewrite rule
  Syntax :
CREATE [ OR REPLACE ] RULE name AS ON event
    TO table [ WHERE condition ]
    DO [ INSTEAD ] action

where action can be:

NOTHING
| query
| ( query ; query ... )

# (7.3) SQL command: CREATE SCHEMA
  Description: define a new schema
  Syntax :
CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ]
CREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]

# (7.3) SQL command: CREATE SEQUENCE
  Description: define a new sequence generator
  Syntax :
CREATE [ TEMPORARY | TEMP ] SEQUENCE seqname [ INCREMENT increment ]
    [ MINVALUE minvalue ] [ MAXVALUE maxvalue ]
    [ START start ] [ CACHE cache ] [ CYCLE ]

# (7.3) SQL command: CREATE TABLE
  Description: define a new table
  Syntax :
CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
    { column_name data_type [ DEFAULT default_expr ] [ column_constraint [, ... ] ]
    | table_constraint }  [, ... ]
)
[ INHERITS ( parent_table [, ... ] ) ]
[ WITH OIDS | WITHOUT OIDS ]

where column_constraint is:

[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | UNIQUE | PRIMARY KEY |
  CHECK (expression) |
  REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]
    [ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

and table_constraint is:

[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
  PRIMARY KEY ( column_name [, ... ] ) |
  CHECK ( expression ) |
  FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
    [ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

# (7.3) SQL command: CREATE TABLE AS
  Description: create a new table from the results of a query
  Syntax :
CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ]
    AS query

# (7.3) SQL command: CREATE TRIGGER
  Description: define a new trigger
  Syntax :
CREATE TRIGGER name { BEFORE | AFTER } { event [OR ...] }
    ON table FOR EACH { ROW | STATEMENT }
    EXECUTE PROCEDURE func ( arguments )

# (7.3) SQL command: CREATE TYPE
  Description: define a new data type
  Syntax :
CREATE TYPE typename ( INPUT = input_function, OUTPUT = output_function
      , INTERNALLENGTH = { internallength | VARIABLE }
    [ , DEFAULT = default ]
    [ , ELEMENT = element ] [ , DELIMITER = delimiter ]
    [ , PASSEDBYVALUE ]
    [ , ALIGNMENT = alignment ]
    [ , STORAGE = storage ]
)

CREATE TYPE typename AS
    ( column_name data_type [, ... ] )

# (7.3) SQL command: CREATE USER
  Description: define a new database user account
  Syntax :
CREATE USER username [ [ WITH ] option [ ... ] ]

where option can be:
    
      SYSID uid 
    | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
    | CREATEDB | NOCREATEDB
    | CREATEUSER | NOCREATEUSER
    | IN GROUP groupname [, ...]
    | VALID UNTIL 'abstime'

# (7.3) SQL command: CREATE VIEW
  Description: define a new view
  Syntax :
CREATE [ OR REPLACE ] VIEW view [ ( column name list ) ] AS SELECT query

# (7.3) SQL command: DEALLOCATE
  Description: remove a prepared query
  Syntax :
DEALLOCATE [ PREPARE ] plan_name

# (7.3) SQL command: DECLARE
  Description: define a cursor
  Syntax :
DECLARE cursorname [ BINARY ] [ INSENSITIVE ] [ SCROLL ]
    CURSOR FOR query
    [ FOR { READ ONLY | UPDATE [ OF column [, ...] ] ]

# (7.3) SQL command: DELETE
  Description: delete rows of a table
  Syntax :
DELETE FROM [ ONLY ] table [ WHERE condition ]

# (7.3) SQL command: DISCONNECT
  Description: Disconnect database
  Syntax :
DISCONNECT { connect_name | CURRENT | DEFAULT | ALL }
      ex)
      CONNECT TO dbname@xxx.com AS db1 USER xuser
      DISCONNECT db1

# (7.3) SQL command: DROP AGGREGATE
  Description: remove a user-defined aggregate function
  Syntax :
DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP CAST
  Description: remove a user-defined cast
  Syntax :
DROP CAST (sourcetype AS targettype)
    [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP CONVERSION
  Description: remove a user-defined conversion
  Syntax :
DROP CONVERSION conversion_name
    [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP DATABASE
  Description: remove a database
  Syntax :
DROP DATABASE name

# (7.3) SQL command: DROP DOMAIN
  Description: remove a user-defined domain
  Syntax :
DROP DOMAIN domainname [, ...]  [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP FUNCTION
  Description: remove a user-defined function
  Syntax :
DROP FUNCTION name ( [ type [, ...] ] ) [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP GROUP
  Description: remove a user group
  Syntax :
DROP GROUP name

# (7.3) SQL command: DROP INDEX
  Description: remove an index
  Syntax :
DROP INDEX index_name [, ...] [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP LANGUAGE
  Description: remove a user-defined procedural language
  Syntax :
DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP OPERATOR CLASS
  Description: remove a user-defined operator class
  Syntax :
DROP OPERATOR CLASS name USING access_method [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP OPERATOR
  Description: remove a user-defined operator
  Syntax :
DROP OPERATOR id ( lefttype | NONE , righttype | NONE ) [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP RULE
  Description: remove a rewrite rule
  Syntax :
DROP RULE name ON relation [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP SCHEMA
  Description: remove a schema
  Syntax :
DROP SCHEMA name [, ...] [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP SEQUENCE
  Description: remove a sequence
  Syntax :
DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP TABLE
  Description: remove a table
  Syntax :
DROP TABLE name [, ...] [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP TRIGGER
  Description: remove a trigger
  Syntax :
DROP TRIGGER name ON table [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP TYPE
  Description: remove a user-defined data type
  Syntax :
DROP TYPE typename [, ...] [ CASCADE | RESTRICT ]

# (7.3) SQL command: DROP USER
  Description: remove a database user account
  Syntax :
DROP USER name

# (7.3) SQL command: DROP VIEW
  Description: remove a view
  Syntax :
DROP VIEW name [, ...] [ CASCADE | RESTRICT ]

# (7.3) SQL command: END
  Description: commit the current transaction
  Syntax :
END [ WORK | TRANSACTION ]

# (7.3) SQL command: EXECUTE
  Description: execute a prepared query
  Syntax :
EXECUTE plan_name [ (parameter [, ...] ) ]

# (7.3) SQL command: EXPLAIN
  Description: show the execution plan of a statement
  Syntax :
EXPLAIN [ ANALYZE ] [ VERBOSE ] query

# (7.3) SQL command: FETCH
  Description: retrieve rows from a table using a cursor
  Syntax :
FETCH [ direction ] [ count ] { IN | FROM } cursor
FETCH [ FORWARD | BACKWARD | RELATIVE ] [ # | ALL | NEXT | PRIOR ]
    { IN | FROM } cursor

# (7.3) SQL command: FETCH INTO
  Description: Gets rows using a cursor and set value to the SHELL variableo 
  Syntax :
FETCH [ FORWARD | BACKWARD | RELATIVE ]
      [ { [ # | ALL | NEXT | PRIOR ] } ] { IN | FROM } cursor
      [ INTO {:host_var [[INDICATOR] :ind_var], ...}]
      FETCH cursor
      [ INTO {:host_var [[INDICATOR] :ind_var], ...}]

# (7.3) SQL command: GRANT
  Description: define access privileges
  Syntax :
GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
    [,...] | ALL [ PRIVILEGES ] }
    ON [ TABLE ] tablename [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

GRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
    ON DATABASE dbname [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

GRANT { EXECUTE | ALL [ PRIVILEGES ] }
    ON FUNCTION funcname ([type, ...]) [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

GRANT { USAGE | ALL [ PRIVILEGES ] }
    ON LANGUAGE langname [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
    ON SCHEMA schemaname [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

# (7.3) SQL command: INSERT
  Description: create new rows in a table
  Syntax :
INSERT INTO table [ ( column [, ...] ) ]
    { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) | SELECT query }

# (7.3) SQL command: LISTEN
  Description: listen for a notification
  Syntax :
LISTEN name

# (7.3) SQL command: LOAD
  Description: load or reload a shared library file
  Syntax :
LOAD 'filename'

# (7.3) SQL command: LOCK
  Description: explicitly lock a table
  Syntax :
LOCK [ TABLE ] name [, ...]
LOCK [ TABLE ] name [, ...] IN lockmode MODE

where lockmode is one of:

	ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE |
	SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE

# (7.3) SQL command: MOVE
  Description: position a cursor on a specified row of a table
  Syntax :
MOVE [ direction ] [ count ] 
    { IN | FROM } cursor

# (7.3) SQL command: NOTIFY
  Description: generate a notification
  Syntax :
NOTIFY name

# (7.3) SQL command: PREPARE
  Description: create a prepared query
  Syntax :
PREPARE plan_name [ (datatype [, ...] ) ] AS query

# (7.3) SQL command: REINDEX
  Description: rebuild corrupted indexes
  Syntax :
REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ]

# (7.3) SQL command: RESET
  Description: restore the value of a run-time parameter to a default value
  Syntax :
RESET variable

# (7.3) SQL command: REVOKE
  Description: remove access privileges
  Syntax :
REVOKE { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
    [,...] | ALL [ PRIVILEGES ] }
    ON [ TABLE ] tablename [, ...]
    FROM { username | GROUP groupname | PUBLIC } [, ...]

REVOKE { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
    ON DATABASE dbname [, ...]
    FROM { username | GROUP groupname | PUBLIC } [, ...]

REVOKE { EXECUTE | ALL [ PRIVILEGES ] }
    ON FUNCTION funcname ([type, ...]) [, ...]
    FROM { username | GROUP groupname | PUBLIC } [, ...]

REVOKE { USAGE | ALL [ PRIVILEGES ] }
    ON LANGUAGE langname [, ...]
    FROM { username | GROUP groupname | PUBLIC } [, ...]

REVOKE { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
    ON SCHEMA schemaname [, ...]
    FROM { username | GROUP groupname | PUBLIC } [, ...]

# (7.3) SQL command: ROLLBACK
  Description: abort the current transaction
  Syntax :
ROLLBACK [ WORK | TRANSACTION ]

# (7.3) SQL command: SELECT
  Description: retrieve rows from a table or view
  Syntax :
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
    * | expression [ AS output_name ] [, ...]
    [ FROM from_item [, ...] ]
    [ WHERE condition ]
    [ GROUP BY expression [, ...] ]
    [ HAVING condition [, ...] ]
    [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
    [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
    [ LIMIT { count | ALL } ]
    [ OFFSET start ]
    [ FOR UPDATE [ OF tablename [, ...] ] ]

where from_item can be:

[ ONLY ] table_name [ * ]
    [ [ AS ] alias [ ( column_alias_list ) ] ]
|
( select )
    [ AS ] alias [ ( column_alias_list ) ]
|
table_function_name ( [ argument [, ...] ] )
    [ AS ] alias [ ( column_alias_list | column_definition_list ) ]
|
table_function_name ( [ argument [, ...] ] )
    AS ( column_definition_list )
|
from_item [ NATURAL ] join_type from_item
    [ ON join_condition | USING ( join_column_list ) ]

# (7.3) SQL command: SELECT INTO
  Description: create a new table from the results of a query
  Syntax :
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
    * | expression [ AS output_name ] [, ...]
    INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
    [ FROM from_item [, ...] ]
    [ WHERE condition ]
    [ GROUP BY expression [, ...] ]
    [ HAVING condition [, ...] ]
    [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
    [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
    [ LIMIT { count | ALL } ]
    [ OFFSET start ]
    [ FOR UPDATE [ OF tablename [, ...] ] ]

# (7.3) SQL command: SET
  Description: change a run-time parameter
  Syntax :
SET [ SESSION | LOCAL ] variable { TO | = } { value | 'value' | DEFAULT }
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }

# (7.3) SQL command: SET CONNECTION
  Description: Set current connection_name
  Syntax :
SET CONNECTION { connect_name | DEFAULT }

# (7.3) SQL command: SET CONSTRAINTS
  Description: set the constraint mode of the current transaction
  Syntax :
SET CONSTRAINTS { ALL | constraint [, ...] } { DEFERRED | IMMEDIATE }

# (7.3) SQL command: SET EXEC_SQL_OPTION
  Description: Set *exec_sql* bash builtin function to option
  Syntax :
SET EXEC_SQL_OPTION DEFAULT
      SET EXEC_SQL_OPTION CGI;
      SET option_name[=value]
      ex)
      set OPTION_ECHO=ON;          ...turn on  ECHO mode
      set OPTION_ECHO=OFF;         ...turn off ECHO mode
      set OPTION_SEPARATOR=',';    ...set SEPARATOR to ','
      set OPTION_SEPARATOR;        ...set SEPARATOR to DEFAULT
      set option_nullstring='*N*'; ...set NULL_STRING to '*N*'


# (7.3) SQL command: SET SESSION AUTHORIZATION
  Description: set the session user identifier and the current user identifier of the current session
  Syntax :
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION

# (7.3) SQL command: SET TRANSACTION
  Description: set the characteristics of the current transaction
  Syntax :
SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL
    { READ COMMITTED | SERIALIZABLE }

# (7.3) SQL command: SHOW
  Description: show the value of a run-time parameter
  Syntax :
SHOW name

# (7.3) SQL command: START TRANSACTION
  Description: start a transaction block
  Syntax :
START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ]

# (7.3) SQL command: TRUNCATE
  Description: empty a table
  Syntax :
TRUNCATE [ TABLE ] name

# (7.3) SQL command: UNLISTEN
  Description: stop listening for a notification
  Syntax :
UNLISTEN { notifyname | * }

# (7.3) SQL command: UPDATE
  Description: update rows of a table
  Syntax :
UPDATE [ ONLY ] table SET col = expression [, ...]
    [ FROM fromlist ]
    [ WHERE condition ]

# (7.3) SQL command: VACUUM
  Description: garbage-collect and optionally analyze a database
  Syntax :
VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]
VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]