/* * *** Do not change this file by hand. It is automatically * *** generated from the DocBook documentation. * * generated by * /usr/bin/perl create_help.pl ../../../doc/src/sgml/ref sql_help.h * */ #ifndef SQL_HELP_H #define SQL_HELP_H struct _helpStruct { char *cmd; /* the command name */ char *help; /* the help associated with it */ char *syntax; /* the syntax associated with it */ }; static struct _helpStruct QL_HELP[] = { { "ABORT", "abort the current transaction", "ABORT [ WORK | TRANSACTION ]" }, { "ALTER DATABASE", "change a database", "ALTER DATABASE name SET variable { TO | = } { value | DEFAULT }\nALTER DATABASE name RESET variable" }, { "ALTER GROUP", "add users to a group or remove users from a group", "ALTER GROUP name ADD USER username [, ... ]\nALTER GROUP name DROP USER username [, ... ]" }, { "ALTER TABLE", "change the definition of a table", "ALTER TABLE [ ONLY ] table [ * ]\n ADD [ COLUMN ] column type [ column_constraint [ ... ] ]\nALTER TABLE [ ONLY ] table [ * ]\n DROP [ COLUMN ] column [ RESTRICT | CASCADE ]\nALTER TABLE [ ONLY ] table [ * ]\n ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }\nALTER TABLE [ ONLY ] table [ * ]\n ALTER [ COLUMN ] column { SET | DROP } NOT NULL\nALTER TABLE [ ONLY ] table [ * ]\n ALTER [ COLUMN ] column SET STATISTICS integer\nALTER TABLE [ ONLY ] table [ * ]\n ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }\nALTER TABLE [ ONLY ] table [ * ]\n RENAME [ COLUMN ] column TO new_column\nALTER TABLE table\n RENAME TO new_table\nALTER TABLE [ ONLY ] table [ * ]\n ADD table_constraint\nALTER TABLE [ ONLY ] table [ * ]\n DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]\nALTER TABLE table\n OWNER TO new_owner" }, { "ALTER TRIGGER", "change the definition of a trigger", "ALTER TRIGGER trigger ON table\n RENAME TO newname" }, { "ALTER USER", "change a database user account", "ALTER USER username [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n\n [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' \n | CREATEDB | NOCREATEDB\n | CREATEUSER | NOCREATEUSER \n | VALID UNTIL 'abstime'\n\nALTER USER username SET variable { TO | = } { value | DEFAULT }\nALTER USER username RESET variable" }, { "ANALYZE", "collect statistics about a database", "ANALYZE [ VERBOSE ] [ table [ (column [, ...] ) ] ]" }, { "BEGIN", "start a transaction block", "BEGIN [ WORK | TRANSACTION ]" }, { "CHECKPOINT", "force a transaction log checkpoint", "CHECKPOINT" }, { "CLOSE", "close a cursor", "CLOSE cursor" }, { "CLUSTER", "cluster a table according to an index", "CLUSTER indexname ON tablename" }, { "COMMENT", "define or change the comment of an object", "COMMENT ON\n[\n TABLE object_name |\n COLUMN table_name.column_name |\n AGGREGATE agg_name (agg_type) |\n CONSTRAINT constraint_name ON table_name |\n DATABASE object_name |\n DOMAIN object_name |\n FUNCTION func_name (arg1_type, arg2_type, ...) |\n INDEX object_name |\n OPERATOR op (leftoperand_type, rightoperand_type) |\n RULE rule_name ON table_name |\n SCHEMA object_name |\n SEQUENCE object_name |\n TRIGGER trigger_name ON table_name |\n TYPE object_name |\n VIEW object_name\n] IS 'text'" }, { "COMMIT", "commit the current transaction", "COMMIT [ WORK | TRANSACTION ]" }, { "CONNECT", "Connect database", "CONNECT TO dbname[@server[:port]] | DEFAULT\n\ [AS connect_name] [USER user_name [password | NULL]];\n\ ex)\n\ CONNECT TO dbname@xxx.com AS db1 USER admin;\n\ CONNECT TO postgres USER postgres;"}, { "COPY", "copy data between files and tables", "COPY table [ ( column [, ...] ) ]\n FROM { 'filename' | stdin }\n [ [ WITH ] \n [ BINARY ] \n [ OIDS ]\n [ DELIMITER [ AS ] 'delimiter' ]\n [ NULL [ AS ] 'null string' ] ]\nCOPY table [ ( column [, ...] ) ]\n TO { 'filename' | stdout }\n [ [ WITH ] \n [ BINARY ]\n [ OIDS ]\n [ DELIMITER [ AS ] 'delimiter' ]\n [ NULL [ AS ] 'null string' ] ]" }, { "COPY TABLE()", "Copies data between *client-side* files and server tables", "COPY table([ c1, .. ]) {TO|FROM}{ 'filename' | stdout | stdin }\n\ [ [USING] DELIMITERS 'delimiter' ]\n\ [ WITH NULL AS 'null string' ]\n\ ex)\n\ COPY table() from '/tmp/test.dat'\n\ COPY table(oid,a1,a2) to '/tmp/test.dat' WITH NULL AS 'NULL'" }, { "CREATE AGGREGATE", "define a new aggregate function", "CREATE AGGREGATE name ( BASETYPE = input_data_type,\n SFUNC = sfunc, STYPE = state_type\n [ , FINALFUNC = ffunc ]\n [ , INITCOND = initial_condition ] )" }, { "CREATE CAST", "define a user-defined cast", "CREATE CAST (sourcetype AS targettype)\n WITH FUNCTION funcname (argtype)\n [ AS ASSIGNMENT | AS IMPLICIT ]\n\nCREATE CAST (sourcetype AS targettype)\n WITHOUT FUNCTION\n [ AS ASSIGNMENT | AS IMPLICIT ]" }, { "CREATE CONSTRAINT TRIGGER", "define a new constraint trigger", "CREATE CONSTRAINT TRIGGER name\n AFTER events ON\n relation constraint attributes\n FOR EACH ROW EXECUTE PROCEDURE func '(' args ')'" }, { "CREATE CONVERSION", "define a user-defined conversion", "CREATE [DEFAULT] CONVERSION conversion_name\n FOR source_encoding TO dest_encoding FROM funcname" }, { "CREATE DATABASE", "create a new database", "CREATE DATABASE name\n [ [ WITH ] [ OWNER [=] dbowner ]\n [ LOCATION [=] 'dbpath' ]\n [ TEMPLATE [=] template ]\n [ ENCODING [=] encoding ] ]" }, { "CREATE DOMAIN", "define a new domain", "CREATE DOMAIN domainname [AS] data_type\n [ DEFAULT default_expr ]\n [ constraint [, ... ] ]\n\nwhere constraint is:\n\n[ CONSTRAINT constraint_name ]\n{ NOT NULL | NULL }" }, { "CREATE FUNCTION", "define a new function", "CREATE [ OR REPLACE ] FUNCTION name ( [ argtype [, ...] ] )\n RETURNS rettype\n { LANGUAGE langname\n | IMMUTABLE | STABLE | VOLATILE\n | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT\n | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER\n | AS 'definition'\n | AS 'obj_file', 'link_symbol'\n } ...\n [ WITH ( attribute [, ...] ) ]" }, { "CREATE GROUP", "define a new user group", "CREATE GROUP name [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n\n SYSID gid\n | USER username [, ...]" }, { "CREATE INDEX", "define a new index", "CREATE [ UNIQUE ] INDEX index_name ON table\n [ USING acc_method ] ( column [ ops_name ] [, ...] )\n [ WHERE predicate ]\nCREATE [ UNIQUE ] INDEX index_name ON table\n [ USING acc_method ] ( func_name( column [, ... ]) [ ops_name ] )\n [ WHERE predicate ]" }, { "CREATE LANGUAGE", "define a new procedural language", "CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE langname\n HANDLER call_handler [ VALIDATOR valfunction ]" }, { "CREATE OPERATOR CLASS", "define a new operator class for indexes", "CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING access_method AS\n { OPERATOR strategy_number operator_id [ ( type, type ) ] [ RECHECK ]\n | FUNCTION support_number func_name ( parameter_types )\n | STORAGE storage_type\n } [, ... ]" }, { "CREATE OPERATOR", "define a new operator", "CREATE OPERATOR name ( PROCEDURE = func_name\n [, LEFTARG = lefttype\n ] [, RIGHTARG = righttype ]\n [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]\n [, RESTRICT = res_proc ] [, JOIN = join_proc ]\n [, HASHES ] [, MERGES ]\n [, SORT1 = left_sort_op ] [, SORT2 = right_sort_op ]\n [, LTCMP = less_than_op ] [, GTCMP = greater_than_op ] )" }, { "CREATE RULE", "define a new rewrite rule", "CREATE [ OR REPLACE ] RULE name AS ON event\n TO table [ WHERE condition ]\n DO [ INSTEAD ] action\n\nwhere action can be:\n\nNOTHING\n| query\n| ( query ; query ... )" }, { "CREATE SCHEMA", "define a new schema", "CREATE SCHEMA schemaname [ AUTHORIZATION username ] [ schema_element [ ... ] ]\nCREATE SCHEMA AUTHORIZATION username [ schema_element [ ... ] ]" }, { "CREATE SEQUENCE", "define a new sequence generator", "CREATE [ TEMPORARY | TEMP ] SEQUENCE seqname [ INCREMENT increment ]\n [ MINVALUE minvalue ] [ MAXVALUE maxvalue ]\n [ START start ] [ CACHE cache ] [ CYCLE ]" }, { "CREATE TABLE", "define a new table", "CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (\n { column_name data_type [ DEFAULT default_expr ] [ column_constraint [, ... ] ]\n | table_constraint } [, ... ]\n)\n[ INHERITS ( parent_table [, ... ] ) ]\n[ WITH OIDS | WITHOUT OIDS ]\n\nwhere column_constraint is:\n\n[ CONSTRAINT constraint_name ]\n{ NOT NULL | NULL | UNIQUE | PRIMARY KEY |\n CHECK (expression) |\n REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]\n [ ON DELETE action ] [ ON UPDATE action ] }\n[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n\nand table_constraint is:\n\n[ CONSTRAINT constraint_name ]\n{ UNIQUE ( column_name [, ... ] ) |\n PRIMARY KEY ( column_name [, ... ] ) |\n CHECK ( expression ) |\n FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]\n [ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ] }\n[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]" }, { "CREATE TABLE AS", "create a new table from the results of a query", "CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ]\n AS query" }, { "CREATE TRIGGER", "define a new trigger", "CREATE TRIGGER name { BEFORE | AFTER } { event [OR ...] }\n ON table FOR EACH { ROW | STATEMENT }\n EXECUTE PROCEDURE func ( arguments )" }, { "CREATE TYPE", "define a new data type", "CREATE TYPE typename ( INPUT = input_function, OUTPUT = output_function\n , INTERNALLENGTH = { internallength | VARIABLE }\n [ , DEFAULT = default ]\n [ , ELEMENT = element ] [ , DELIMITER = delimiter ]\n [ , PASSEDBYVALUE ]\n [ , ALIGNMENT = alignment ]\n [ , STORAGE = storage ]\n)\n\nCREATE TYPE typename AS\n ( column_name data_type [, ... ] )" }, { "CREATE USER", "define a new database user account", "CREATE USER username [ [ WITH ] option [ ... ] ]\n\nwhere option can be:\n \n SYSID uid \n | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'\n | CREATEDB | NOCREATEDB\n | CREATEUSER | NOCREATEUSER\n | IN GROUP groupname [, ...]\n | VALID UNTIL 'abstime'" }, { "CREATE VIEW", "define a new view", "CREATE [ OR REPLACE ] VIEW view [ ( column name list ) ] AS SELECT query" }, { "DEALLOCATE", "remove a prepared query", "DEALLOCATE [ PREPARE ] plan_name" }, { "DECLARE", "define a cursor", "DECLARE cursorname [ BINARY ] [ INSENSITIVE ] [ SCROLL ]\n CURSOR FOR query\n [ FOR { READ ONLY | UPDATE [ OF column [, ...] ] ]" }, { "DELETE", "delete rows of a table", "DELETE FROM [ ONLY ] table [ WHERE condition ]" }, { "DISCONNECT", "Disconnect database", "DISCONNECT { connect_name | CURRENT | DEFAULT | ALL }\n\ ex)\n\ CONNECT TO dbname@xxx.com AS db1 USER xuser\n\ DISCONNECT db1"}, { "DROP AGGREGATE", "remove a user-defined aggregate function", "DROP AGGREGATE name ( type ) [ CASCADE | RESTRICT ]" }, { "DROP CAST", "remove a user-defined cast", "DROP CAST (sourcetype AS targettype)\n [ CASCADE | RESTRICT ]" }, { "DROP CONVERSION", "remove a user-defined conversion", "DROP CONVERSION conversion_name\n [ CASCADE | RESTRICT ]" }, { "DROP DATABASE", "remove a database", "DROP DATABASE name" }, { "DROP DOMAIN", "remove a user-defined domain", "DROP DOMAIN domainname [, ...] [ CASCADE | RESTRICT ]" }, { "DROP FUNCTION", "remove a user-defined function", "DROP FUNCTION name ( [ type [, ...] ] ) [ CASCADE | RESTRICT ]" }, { "DROP GROUP", "remove a user group", "DROP GROUP name" }, { "DROP INDEX", "remove an index", "DROP INDEX index_name [, ...] [ CASCADE | RESTRICT ]" }, { "DROP LANGUAGE", "remove a user-defined procedural language", "DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]" }, { "DROP OPERATOR CLASS", "remove a user-defined operator class", "DROP OPERATOR CLASS name USING access_method [ CASCADE | RESTRICT ]" }, { "DROP OPERATOR", "remove a user-defined operator", "DROP OPERATOR id ( lefttype | NONE , righttype | NONE ) [ CASCADE | RESTRICT ]" }, { "DROP RULE", "remove a rewrite rule", "DROP RULE name ON relation [ CASCADE | RESTRICT ]" }, { "DROP SCHEMA", "remove a schema", "DROP SCHEMA name [, ...] [ CASCADE | RESTRICT ]" }, { "DROP SEQUENCE", "remove a sequence", "DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]" }, { "DROP TABLE", "remove a table", "DROP TABLE name [, ...] [ CASCADE | RESTRICT ]" }, { "DROP TRIGGER", "remove a trigger", "DROP TRIGGER name ON table [ CASCADE | RESTRICT ]" }, { "DROP TYPE", "remove a user-defined data type", "DROP TYPE typename [, ...] [ CASCADE | RESTRICT ]" }, { "DROP USER", "remove a database user account", "DROP USER name" }, { "DROP VIEW", "remove a view", "DROP VIEW name [, ...] [ CASCADE | RESTRICT ]" }, { "END", "commit the current transaction", "END [ WORK | TRANSACTION ]" }, { "EXECUTE", "execute a prepared query", "EXECUTE plan_name [ (parameter [, ...] ) ]" }, { "EXPLAIN", "show the execution plan of a statement", "EXPLAIN [ ANALYZE ] [ VERBOSE ] query" }, { "FETCH", "retrieve rows from a table using a cursor", "FETCH [ direction ] [ count ] { IN | FROM } cursor\nFETCH [ FORWARD | BACKWARD | RELATIVE ] [ # | ALL | NEXT | PRIOR ]\n { IN | FROM } cursor" }, { "FETCH INTO", "Gets rows using a cursor and set value to the SHELL variableo ", "FETCH [ FORWARD | BACKWARD | RELATIVE ]\n\ [ { [ # | ALL | NEXT | PRIOR ] } ] { IN | FROM } cursor\n\ [ INTO {:host_var [[INDICATOR] :ind_var], ...}]\n\ FETCH cursor\n\ [ INTO {:host_var [[INDICATOR] :ind_var], ...}]"}, { "GRANT", "define access privileges", "GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }\n [,...] | ALL [ PRIVILEGES ] }\n ON [ TABLE ] tablename [, ...]\n TO { username | GROUP groupname | PUBLIC } [, ...]\n\nGRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }\n ON DATABASE dbname [, ...]\n TO { username | GROUP groupname | PUBLIC } [, ...]\n\nGRANT { EXECUTE | ALL [ PRIVILEGES ] }\n ON FUNCTION funcname ([type, ...]) [, ...]\n TO { username | GROUP groupname | PUBLIC } [, ...]\n\nGRANT { USAGE | ALL [ PRIVILEGES ] }\n ON LANGUAGE langname [, ...]\n TO { username | GROUP groupname | PUBLIC } [, ...]\n\nGRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }\n ON SCHEMA schemaname [, ...]\n TO { username | GROUP groupname | PUBLIC } [, ...]" }, { "INSERT", "create new rows in a table", "INSERT INTO table [ ( column [, ...] ) ]\n { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) | SELECT query }" }, { "LISTEN", "listen for a notification", "LISTEN name" }, { "LOAD", "load or reload a shared library file", "LOAD 'filename'" }, { "LOCK", "explicitly lock a table", "LOCK [ TABLE ] name [, ...]\nLOCK [ TABLE ] name [, ...] IN lockmode MODE\n\nwhere lockmode is one of:\n\n ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE |\n SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE" }, { "MOVE", "position a cursor on a specified row of a table", "MOVE [ direction ] [ count ] \n { IN | FROM } cursor" }, { "NOTIFY", "generate a notification", "NOTIFY name" }, { "PREPARE", "create a prepared query", "PREPARE plan_name [ (datatype [, ...] ) ] AS query" }, { "REINDEX", "rebuild corrupted indexes", "REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ]" }, { "RESET", "restore the value of a run-time parameter to a default value", "RESET variable" }, { "REVOKE", "remove access privileges", "REVOKE { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }\n [,...] | ALL [ PRIVILEGES ] }\n ON [ TABLE ] tablename [, ...]\n FROM { username | GROUP groupname | PUBLIC } [, ...]\n\nREVOKE { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }\n ON DATABASE dbname [, ...]\n FROM { username | GROUP groupname | PUBLIC } [, ...]\n\nREVOKE { EXECUTE | ALL [ PRIVILEGES ] }\n ON FUNCTION funcname ([type, ...]) [, ...]\n FROM { username | GROUP groupname | PUBLIC } [, ...]\n\nREVOKE { USAGE | ALL [ PRIVILEGES ] }\n ON LANGUAGE langname [, ...]\n FROM { username | GROUP groupname | PUBLIC } [, ...]\n\nREVOKE { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }\n ON SCHEMA schemaname [, ...]\n FROM { username | GROUP groupname | PUBLIC } [, ...]" }, { "ROLLBACK", "abort the current transaction", "ROLLBACK [ WORK | TRANSACTION ]" }, { "SELECT", "retrieve rows from a table or view", "SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]\n * | expression [ AS output_name ] [, ...]\n [ FROM from_item [, ...] ]\n [ WHERE condition ]\n [ GROUP BY expression [, ...] ]\n [ HAVING condition [, ...] ]\n [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]\n [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]\n [ LIMIT { count | ALL } ]\n [ OFFSET start ]\n [ FOR UPDATE [ OF tablename [, ...] ] ]\n\nwhere from_item can be:\n\n[ ONLY ] table_name [ * ]\n [ [ AS ] alias [ ( column_alias_list ) ] ]\n|\n( select )\n [ AS ] alias [ ( column_alias_list ) ]\n|\ntable_function_name ( [ argument [, ...] ] )\n [ AS ] alias [ ( column_alias_list | column_definition_list ) ]\n|\ntable_function_name ( [ argument [, ...] ] )\n AS ( column_definition_list )\n|\nfrom_item [ NATURAL ] join_type from_item\n [ ON join_condition | USING ( join_column_list ) ]" }, { "SELECT INTO", "create a new table from the results of a query", "SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]\n * | expression [ AS output_name ] [, ...]\n INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table\n [ FROM from_item [, ...] ]\n [ WHERE condition ]\n [ GROUP BY expression [, ...] ]\n [ HAVING condition [, ...] ]\n [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]\n [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]\n [ LIMIT { count | ALL } ]\n [ OFFSET start ]\n [ FOR UPDATE [ OF tablename [, ...] ] ]" }, { "SET", "change a run-time parameter", "SET [ SESSION | LOCAL ] variable { TO | = } { value | 'value' | DEFAULT }\nSET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }" }, { "SET CONNECTION", "Set current connection_name", "SET CONNECTION { connect_name | DEFAULT }" }, { "SET CONSTRAINTS", "set the constraint mode of the current transaction", "SET CONSTRAINTS { ALL | constraint [, ...] } { DEFERRED | IMMEDIATE }" }, { "SET EXEC_SQL_OPTION", "Set *exec_sql* bash builtin function to option", "SET EXEC_SQL_OPTION DEFAULT\n\ SET EXEC_SQL_OPTION CGI;\n\ SET option_name[=value]\n\ ex)\n\ set OPTION_ECHO=ON; ...turn on ECHO mode\n\ set OPTION_ECHO=OFF; ...turn off ECHO mode\n\ set OPTION_SEPARATOR=','; ...set SEPARATOR to ','\n\ set OPTION_SEPARATOR; ...set SEPARATOR to DEFAULT\n\ set option_nullstring='*N*'; ...set NULL_STRING to '*N*'\n"}, { "SET SESSION AUTHORIZATION", "set the session user identifier and the current user identifier of the current session", "SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username\nSET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT\nRESET SESSION AUTHORIZATION" }, { "SET TRANSACTION", "set the characteristics of the current transaction", "SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }\nSET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL\n { READ COMMITTED | SERIALIZABLE }" }, { "SHOW", "show the value of a run-time parameter", "SHOW name" }, { "START TRANSACTION", "start a transaction block", "START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ]" }, { "TRUNCATE", "empty a table", "TRUNCATE [ TABLE ] name" }, { "UNLISTEN", "stop listening for a notification", "UNLISTEN { notifyname | * }" }, { "UPDATE", "update rows of a table", "UPDATE [ ONLY ] table SET col = expression [, ...]\n [ FROM fromlist ]\n [ WHERE condition ]" }, { "VACUUM", "garbage-collect and optionally analyze a database", "VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]\nVACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]" }, { NULL, NULL, NULL } /* End of list marker */ }; /***#define QL_HELP_COUNT 85***/ #define QL_HELP_COUNT 91 #endif /* SQL_HELP_H */