******************** HELP test ********************
 
# (7.2) 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 ] [, ...] ]
    [ FOR UPDATE [ OF tablename [, ...] ] ]
    [ LIMIT { count | ALL } ]
    [ OFFSET start ]

where from_item can be:

[ ONLY ] table_name [ * ]
    [ [ AS ] alias [ ( column_alias_list ) ] ]
|
( select )
    [ AS ] alias [ ( column_alias_list ) ]
|
from_item [ NATURAL ] join_type from_item
    [ ON join_condition | USING ( join_column_list ) ]

# (7.2) 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.2) 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.2) 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.2) SQL command: SET CONNECTION
  Description: Set current connection_name
  Syntax :
SET CONNECTION { connect_name | DEFAULT }

# (7.2) 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.2) 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 GROUP               ALTER TABLE              
    ALTER USER                ANALYZE                   BEGIN                    
    CHECKPOINT                CLOSE                     CLUSTER                  
    COMMENT                   COMMIT                    CONNECT                  
    COPY                      COPY TABLE()              CREATE AGGREGATE         
    CREATE CONSTRAINT TRIGGER CREATE DATABASE           CREATE FUNCTION          
    CREATE GROUP              CREATE INDEX              CREATE LANGUAGE          
    CREATE OPERATOR           CREATE RULE               CREATE SEQUENCE          
    CREATE TABLE              CREATE TABLE AS           CREATE TRIGGER           
    CREATE TYPE               CREATE USER               CREATE VIEW              
    DECLARE                   DELETE                    DISCONNECT               
    DROP AGGREGATE            DROP DATABASE             DROP FUNCTION            
    DROP GROUP                DROP INDEX                DROP LANGUAGE            
    DROP OPERATOR             DROP RULE                 DROP SEQUENCE            
    DROP TABLE                DROP TRIGGER              DROP TYPE                
    DROP USER                 DROP VIEW                 END                      
    EXPLAIN                   FETCH                     FETCH INTO               
    GRANT                     INSERT                    LISTEN                   
    LOAD                      LOCK                      MOVE                     
    NOTIFY                    REINDEX                   RESET                    
    REVOKE                    ROLLBACK                  SELECT                   
    SELECT INTO               SET                       SET EXEC_SQL_OPTION      
    SET CONNECTION            SET CONSTRAINTS           SET SESSION AUTHORIZATION
    SET TRANSACTION           SHOW                      TRUNCATE                 
    UNLISTEN                  UPDATE                    VACUUM                   
# (7.2) SQL command: ABORT
  Description: abort the current transaction
  Syntax :
ABORT [ WORK | TRANSACTION ]

# (7.2) 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.2) 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 [ * ]
    ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }
ALTER TABLE [ ONLY ] table [ * ]
    ALTER [ COLUMN ] column SET STATISTICS integer
ALTER TABLE [ ONLY ] table [ * ]
    RENAME [ COLUMN ] column TO newcolumn
ALTER TABLE table
    RENAME TO newtable
ALTER TABLE table
    ADD table constraint definition
ALTER TABLE [ ONLY ] table 
	DROP CONSTRAINT constraint { RESTRICT | CASCADE }
ALTER TABLE table
	OWNER TO new owner

# (7.2) 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'

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

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

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

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

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

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

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

# (7.2) 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.2) SQL command: COPY
  Description: copy data between files and tables
  Syntax :
COPY [ BINARY ] table [ WITH OIDS ]
    FROM { 'filename' | stdin }
    [ [USING] DELIMITERS 'delimiter' ]
    [ WITH NULL AS 'null string' ]
COPY [ BINARY ] table [ WITH OIDS ]
    TO { 'filename' | stdout }
    [ [USING] DELIMITERS 'delimiter' ]
    [ WITH NULL AS 'null string' ]

# (7.2) 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.2) 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.2) 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.2) SQL command: CREATE DATABASE
  Description: create a new database
  Syntax :
CREATE DATABASE name
    [ WITH [ LOCATION = 'dbpath' ]
           [ TEMPLATE = template ]
           [ ENCODING = encoding ] ]

# (7.2) SQL command: CREATE FUNCTION
  Description: define a new function
  Syntax :
CREATE [ OR REPLACE ] FUNCTION name ( [ argtype [, ...] ] )
    RETURNS rettype
    AS 'definition'
    LANGUAGE langname
    [ WITH ( attribute [, ...] ) ]
CREATE [ OR REPLACE ] FUNCTION name ( [ argtype [, ...] ] )
    RETURNS rettype
    AS 'obj_file', 'link_symbol'
    LANGUAGE langname
    [ WITH ( attribute [, ...] ) ]

# (7.2) 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.2) 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.2) SQL command: CREATE LANGUAGE
  Description: define a new procedural language
  Syntax :
CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE langname
    HANDLER call_handler

# (7.2) 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 ] [, SORT1 = left_sort_op ] [, SORT2 = right_sort_op ] )

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

where action can be:

NOTHING
|
query
|
( query ; query ... )
|
[ query ; query ... ]

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

# (7.2) 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.2) 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.2) 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.2) SQL command: CREATE TYPE
  Description: define a new data type
  Syntax :
CREATE TYPE typename ( INPUT = input_function, OUTPUT = output_function
      , INTERNALLENGTH = { internallength | VARIABLE }
    [ , EXTERNALLENGTH = { externallength | VARIABLE } ]
    [ , DEFAULT = default ]
    [ , ELEMENT = element ] [ , DELIMITER = delimiter ]
    [ , SEND = send_function ] [ , RECEIVE = receive_function ]
    [ , PASSEDBYVALUE ]
    [ , ALIGNMENT = alignment ]
    [ , STORAGE = storage ]
)

# (7.2) 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.2) SQL command: CREATE VIEW
  Description: define a new view
  Syntax :
CREATE VIEW view [ ( column name list ) ] AS SELECT query

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

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

# (7.2) 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.2) SQL command: DROP AGGREGATE
  Description: remove a user-defined aggregate function
  Syntax :
DROP AGGREGATE name ( type )

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

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

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

# (7.2) SQL command: DROP INDEX
  Description: remove an index
  Syntax :
DROP INDEX index_name [, ...]

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

# (7.2) SQL command: DROP OPERATOR
  Description: remove a user-defined operator
  Syntax :
DROP OPERATOR id ( lefttype | NONE , righttype | NONE )

# (7.2) SQL command: DROP RULE
  Description: remove a rewrite rule
  Syntax :
DROP RULE name [, ...]

# (7.2) SQL command: DROP SEQUENCE
  Description: remove a sequence
  Syntax :
DROP SEQUENCE name [, ...]

# (7.2) SQL command: DROP TABLE
  Description: remove a table
  Syntax :
DROP TABLE name [, ...]

# (7.2) SQL command: DROP TRIGGER
  Description: remove a trigger
  Syntax :
DROP TRIGGER name ON table

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

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

# (7.2) SQL command: DROP VIEW
  Description: remove a view
  Syntax :
DROP VIEW name [, ...]

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

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

# (7.2) 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.2) 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.2) SQL command: GRANT
  Description: define access privileges
  Syntax :
GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] }
    ON [ TABLE ] objectname [, ...]
    TO { username | GROUP groupname | PUBLIC } [, ...]

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

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

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

# (7.2) 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.2) SQL command: MOVE
  Description: position a cursor on a specified row of a table
  Syntax :
MOVE [ direction ] [ count ] 
    { IN | FROM } cursor

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

# (7.2) SQL command: REINDEX
  Description: recover a corrupted system index
  Syntax :
REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ]

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

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

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

# (7.2) 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 ] [, ...] ]
    [ FOR UPDATE [ OF tablename [, ...] ] ]
    [ LIMIT { count | ALL } ]
    [ OFFSET start ]

where from_item can be:

[ ONLY ] table_name [ * ]
    [ [ AS ] alias [ ( column_alias_list ) ] ]
|
( select )
    [ AS ] alias [ ( column_alias_list ) ]
|
from_item [ NATURAL ] join_type from_item
    [ ON join_condition | USING ( join_column_list ) ]

# (7.2) 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 ] [, ...] ]
    [ FOR UPDATE [ OF tablename [, ...] ] ]
    [ LIMIT [ start , ] { count | ALL } ]
    [ OFFSET start ]

where from_item can be:

[ ONLY ] table_name [ * ]
    [ [ AS ] alias [ ( column_alias_list ) ] ]
|
( select )
    [ AS ] alias [ ( column_alias_list ) ]
|
from_item [ NATURAL ] join_type from_item
    [ ON join_condition | USING ( join_column_list ) ]

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

# (7.2) 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.2) SQL command: SET CONNECTION
  Description: Set current connection_name
  Syntax :
SET CONNECTION { connect_name | DEFAULT }

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

# (7.2) SQL command: SET SESSION AUTHORIZATION
  Description: set the session user identifier and the current user identifier of the current session
  Syntax :
SET SESSION AUTHORIZATION 'username'

# (7.2) 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.2) SQL command: SHOW
  Description: show the value of a run-time parameter
  Syntax :
SHOW name

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

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

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

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