2
* *** Do not change this file by hand. It is automatically
3
* *** generated from the DocBook documentation.
6
* /usr/local/bin/suidperl create_help.pl ../../../doc/src/sgml/ref sql_help
13
sql_help_ABORT(PQExpBuffer buf)
15
appendPQExpBuffer(buf,
16
"ABORT [ WORK | TRANSACTION ]");
20
sql_help_ALTER_AGGREGATE(PQExpBuffer buf)
22
appendPQExpBuffer(buf,
23
"ALTER AGGREGATE %s ( %s [ , ... ] ) RENAME TO %s\n"
24
"ALTER AGGREGATE %s ( %s [ , ... ] ) OWNER TO %s\n"
25
"ALTER AGGREGATE %s ( %s [ , ... ] ) SET SCHEMA %s",
38
sql_help_ALTER_COLLATION(PQExpBuffer buf)
40
appendPQExpBuffer(buf,
41
"ALTER COLLATION %s RENAME TO %s\n"
42
"ALTER COLLATION %s OWNER TO %s\n"
43
"ALTER COLLATION %s SET SCHEMA %s",
53
sql_help_ALTER_CONVERSION(PQExpBuffer buf)
55
appendPQExpBuffer(buf,
56
"ALTER CONVERSION %s RENAME TO %s\n"
57
"ALTER CONVERSION %s OWNER TO %s\n"
58
"ALTER CONVERSION %s SET SCHEMA %s",
68
sql_help_ALTER_DATABASE(PQExpBuffer buf)
70
appendPQExpBuffer(buf,
71
"ALTER DATABASE %s [ [ WITH ] %s [ ... ] ]\n"
75
" CONNECTION LIMIT %s\n"
77
"ALTER DATABASE %s RENAME TO %s\n"
79
"ALTER DATABASE %s OWNER TO %s\n"
81
"ALTER DATABASE %s SET TABLESPACE %s\n"
83
"ALTER DATABASE %s SET %s { TO | = } { %s | DEFAULT }\n"
84
"ALTER DATABASE %s SET %s FROM CURRENT\n"
85
"ALTER DATABASE %s RESET %s\n"
86
"ALTER DATABASE %s RESET ALL",
89
_("where option can be:"),
98
_("configuration_parameter"),
101
_("configuration_parameter"),
103
_("configuration_parameter"),
108
sql_help_ALTER_DEFAULT_PRIVILEGES(PQExpBuffer buf)
110
appendPQExpBuffer(buf,
111
"ALTER DEFAULT PRIVILEGES\n"
112
" [ FOR { ROLE | USER } %s [, ...] ]\n"
113
" [ IN SCHEMA %s [, ...] ]\n"
118
"GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }\n"
119
" [, ...] | ALL [ PRIVILEGES ] }\n"
121
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
123
"GRANT { { USAGE | SELECT | UPDATE }\n"
124
" [, ...] | ALL [ PRIVILEGES ] }\n"
126
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
128
"GRANT { EXECUTE | ALL [ PRIVILEGES ] }\n"
130
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
132
"REVOKE [ GRANT OPTION FOR ]\n"
133
" { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }\n"
134
" [, ...] | ALL [ PRIVILEGES ] }\n"
136
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
137
" [ CASCADE | RESTRICT ]\n"
139
"REVOKE [ GRANT OPTION FOR ]\n"
140
" { { USAGE | SELECT | UPDATE }\n"
141
" [, ...] | ALL [ PRIVILEGES ] }\n"
143
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
144
" [ CASCADE | RESTRICT ]\n"
146
"REVOKE [ GRANT OPTION FOR ]\n"
147
" { EXECUTE | ALL [ PRIVILEGES ] }\n"
149
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
150
" [ CASCADE | RESTRICT ]",
153
_("abbreviated_grant_or_revoke"),
154
_("where abbreviated_grant_or_revoke is one of:"),
164
sql_help_ALTER_DOMAIN(PQExpBuffer buf)
166
appendPQExpBuffer(buf,
168
" { SET DEFAULT %s | DROP DEFAULT }\n"
170
" { SET | DROP } NOT NULL\n"
174
" DROP CONSTRAINT %s [ RESTRICT | CASCADE ]\n"
183
_("domain_constraint"),
185
_("constraint_name"),
193
sql_help_ALTER_EXTENSION(PQExpBuffer buf)
195
appendPQExpBuffer(buf,
196
"ALTER EXTENSION %s UPDATE [ TO %s ]\n"
197
"ALTER EXTENSION %s SET SCHEMA %s\n"
198
"ALTER EXTENSION %s ADD %s\n"
199
"ALTER EXTENSION %s DROP %s\n"
203
" AGGREGATE %s (%s [, ...] ) |\n"
204
" CAST (%s AS %s) |\n"
208
" FOREIGN DATA WRAPPER %s |\n"
209
" FOREIGN TABLE %s |\n"
210
" FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] ) |\n"
211
" OPERATOR %s (%s, %s) |\n"
212
" OPERATOR CLASS %s USING %s |\n"
213
" OPERATOR FAMILY %s USING %s |\n"
214
" [ PROCEDURAL ] LANGUAGE %s |\n"
219
" TEXT SEARCH CONFIGURATION %s |\n"
220
" TEXT SEARCH DICTIONARY %s |\n"
221
" TEXT SEARCH PARSER %s |\n"
222
" TEXT SEARCH TEMPLATE %s |\n"
233
_("where member_object is:"),
268
sql_help_ALTER_FOREIGN_DATA_WRAPPER(PQExpBuffer buf)
270
appendPQExpBuffer(buf,
271
"ALTER FOREIGN DATA WRAPPER %s\n"
272
" [ HANDLER %s | NO HANDLER ]\n"
273
" [ VALIDATOR %s | NO VALIDATOR ]\n"
274
" [ OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ]) ]\n"
275
"ALTER FOREIGN DATA WRAPPER %s OWNER TO %s",
277
_("handler_function"),
278
_("validator_function"),
286
sql_help_ALTER_FOREIGN_TABLE(PQExpBuffer buf)
288
appendPQExpBuffer(buf,
289
"ALTER FOREIGN TABLE %s\n"
291
"ALTER FOREIGN TABLE %s\n"
292
" RENAME [ COLUMN ] %s TO %s\n"
293
"ALTER FOREIGN TABLE %s\n"
295
"ALTER FOREIGN TABLE %s\n"
300
" ADD [ COLUMN ] %s %s\n"
301
" DROP [ COLUMN ] [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n"
302
" ALTER [ COLUMN ] %s [ SET DATA ] TYPE %s\n"
303
" ALTER [ COLUMN ] %s { SET | DROP } NOT NULL\n"
305
" OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ])",
315
_("where action is one of:"),
328
sql_help_ALTER_FUNCTION(PQExpBuffer buf)
330
appendPQExpBuffer(buf,
331
"ALTER FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] )\n"
332
" %s [ ... ] [ RESTRICT ]\n"
333
"ALTER FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] )\n"
335
"ALTER FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] )\n"
337
"ALTER FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] )\n"
342
" CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT\n"
343
" IMMUTABLE | STABLE | VOLATILE\n"
344
" [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n"
347
" SET %s { TO | = } { %s | DEFAULT }\n"
348
" SET %s FROM CURRENT\n"
371
_("where action is one of:"),
374
_("configuration_parameter"),
376
_("configuration_parameter"),
377
_("configuration_parameter"));
381
sql_help_ALTER_GROUP(PQExpBuffer buf)
383
appendPQExpBuffer(buf,
384
"ALTER GROUP %s ADD USER %s [, ... ]\n"
385
"ALTER GROUP %s DROP USER %s [, ... ]\n"
387
"ALTER GROUP %s RENAME TO %s",
397
sql_help_ALTER_INDEX(PQExpBuffer buf)
399
appendPQExpBuffer(buf,
400
"ALTER INDEX %s RENAME TO %s\n"
401
"ALTER INDEX %s SET TABLESPACE %s\n"
402
"ALTER INDEX %s SET ( %s = %s [, ... ] )\n"
403
"ALTER INDEX %s RESET ( %s [, ... ] )",
407
_("tablespace_name"),
409
_("storage_parameter"),
412
_("storage_parameter"));
416
sql_help_ALTER_LANGUAGE(PQExpBuffer buf)
418
appendPQExpBuffer(buf,
419
"ALTER [ PROCEDURAL ] LANGUAGE %s RENAME TO %s\n"
420
"ALTER [ PROCEDURAL ] LANGUAGE %s OWNER TO %s",
428
sql_help_ALTER_LARGE_OBJECT(PQExpBuffer buf)
430
appendPQExpBuffer(buf,
431
"ALTER LARGE OBJECT %s OWNER TO %s",
432
_("large_object_oid"),
437
sql_help_ALTER_OPERATOR(PQExpBuffer buf)
439
appendPQExpBuffer(buf,
440
"ALTER OPERATOR %s ( { %s | NONE } , { %s | NONE } ) OWNER TO %s\n"
441
"ALTER OPERATOR %s ( { %s | NONE } , { %s | NONE } ) SET SCHEMA %s",
453
sql_help_ALTER_OPERATOR_CLASS(PQExpBuffer buf)
455
appendPQExpBuffer(buf,
456
"ALTER OPERATOR CLASS %s USING %s RENAME TO %s\n"
457
"ALTER OPERATOR CLASS %s USING %s OWNER TO %s\n"
458
"ALTER OPERATOR CLASS %s USING %s SET SCHEMA %s",
471
sql_help_ALTER_OPERATOR_FAMILY(PQExpBuffer buf)
473
appendPQExpBuffer(buf,
474
"ALTER OPERATOR FAMILY %s USING %s ADD\n"
475
" { OPERATOR %s %s ( %s, %s ) [ FOR SEARCH | FOR ORDER BY %s ]\n"
476
" | FUNCTION %s [ ( %s [ , %s ] ) ] %s ( %s [, ...] )\n"
478
"ALTER OPERATOR FAMILY %s USING %s DROP\n"
479
" { OPERATOR %s ( %s [ , %s ] )\n"
480
" | FUNCTION %s ( %s [ , %s ] )\n"
482
"ALTER OPERATOR FAMILY %s USING %s RENAME TO %s\n"
483
"ALTER OPERATOR FAMILY %s USING %s OWNER TO %s\n"
484
"ALTER OPERATOR FAMILY %s USING %s SET SCHEMA %s",
487
_("strategy_number"),
491
_("sort_family_name"),
499
_("strategy_number"),
517
sql_help_ALTER_ROLE(PQExpBuffer buf)
519
appendPQExpBuffer(buf,
520
"ALTER ROLE %s [ [ WITH ] %s [ ... ] ]\n"
524
" SUPERUSER | NOSUPERUSER\n"
525
" | CREATEDB | NOCREATEDB\n"
526
" | CREATEROLE | NOCREATEROLE\n"
527
" | CREATEUSER | NOCREATEUSER\n"
528
" | INHERIT | NOINHERIT\n"
529
" | LOGIN | NOLOGIN\n"
530
" | REPLICATION | NOREPLICATION\n"
531
" | CONNECTION LIMIT %s\n"
532
" | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '%s'\n"
533
" | VALID UNTIL '%s'\n"
535
"ALTER ROLE %s RENAME TO %s\n"
537
"ALTER ROLE %s [ IN DATABASE %s ] SET %s { TO | = } { %s | DEFAULT }\n"
538
"ALTER ROLE %s [ IN DATABASE %s ] SET %s FROM CURRENT\n"
539
"ALTER ROLE %s [ IN DATABASE %s ] RESET %s\n"
540
"ALTER ROLE %s [ IN DATABASE %s ] RESET ALL",
543
_("where option can be:"),
551
_("configuration_parameter"),
555
_("configuration_parameter"),
558
_("configuration_parameter"),
564
sql_help_ALTER_SCHEMA(PQExpBuffer buf)
566
appendPQExpBuffer(buf,
567
"ALTER SCHEMA %s RENAME TO %s\n"
568
"ALTER SCHEMA %s OWNER TO %s",
576
sql_help_ALTER_SEQUENCE(PQExpBuffer buf)
578
appendPQExpBuffer(buf,
579
"ALTER SEQUENCE %s [ INCREMENT [ BY ] %s ]\n"
580
" [ MINVALUE %s | NO MINVALUE ] [ MAXVALUE %s | NO MAXVALUE ]\n"
581
" [ START [ WITH ] %s ]\n"
582
" [ RESTART [ [ WITH ] %s ] ]\n"
583
" [ CACHE %s ] [ [ NO ] CYCLE ]\n"
584
" [ OWNED BY { %s.%s | NONE } ]\n"
585
"ALTER SEQUENCE %s OWNER TO %s\n"
586
"ALTER SEQUENCE %s RENAME TO %s\n"
587
"ALTER SEQUENCE %s SET SCHEMA %s",
606
sql_help_ALTER_SERVER(PQExpBuffer buf)
608
appendPQExpBuffer(buf,
609
"ALTER SERVER %s [ VERSION '%s' ]\n"
610
" [ OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ] ) ]\n"
611
"ALTER SERVER %s OWNER TO %s",
621
sql_help_ALTER_TABLE(PQExpBuffer buf)
623
appendPQExpBuffer(buf,
624
"ALTER TABLE [ ONLY ] %s [ * ]\n"
626
"ALTER TABLE [ ONLY ] %s [ * ]\n"
627
" RENAME [ COLUMN ] %s TO %s\n"
635
" ADD [ COLUMN ] %s %s [ COLLATE %s ] [ %s [ ... ] ]\n"
636
" DROP [ COLUMN ] [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n"
637
" ALTER [ COLUMN ] %s [ SET DATA ] TYPE %s [ COLLATE %s ] [ USING %s ]\n"
638
" ALTER [ COLUMN ] %s SET DEFAULT %s\n"
639
" ALTER [ COLUMN ] %s DROP DEFAULT\n"
640
" ALTER [ COLUMN ] %s { SET | DROP } NOT NULL\n"
641
" ALTER [ COLUMN ] %s SET STATISTICS %s\n"
642
" ALTER [ COLUMN ] %s SET ( %s = %s [, ... ] )\n"
643
" ALTER [ COLUMN ] %s RESET ( %s [, ... ] )\n"
644
" ALTER [ COLUMN ] %s SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }\n"
647
" ADD %s [ NOT VALID ]\n"
648
" VALIDATE CONSTRAINT %s\n"
649
" DROP CONSTRAINT [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n"
650
" DISABLE TRIGGER [ %s | ALL | USER ]\n"
651
" ENABLE TRIGGER [ %s | ALL | USER ]\n"
652
" ENABLE REPLICA TRIGGER %s\n"
653
" ENABLE ALWAYS TRIGGER %s\n"
656
" ENABLE REPLICA RULE %s\n"
657
" ENABLE ALWAYS RULE %s\n"
659
" SET WITHOUT CLUSTER\n"
661
" SET WITHOUT OIDS\n"
662
" SET ( %s = %s [, ... ] )\n"
663
" RESET ( %s [, ... ] )\n"
669
" SET TABLESPACE %s\n"
673
" [ CONSTRAINT %s ]\n"
674
" { UNIQUE | PRIMARY KEY } USING INDEX %s\n"
675
" [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]",
685
_("where action is one of:"),
689
_("column_constraint"),
702
_("attribute_option"),
705
_("attribute_option"),
707
_("table_constraint"),
708
_("table_constraint_using_index"),
709
_("table_constraint"),
710
_("constraint_name"),
711
_("constraint_name"),
716
_("rewrite_rule_name"),
717
_("rewrite_rule_name"),
718
_("rewrite_rule_name"),
719
_("rewrite_rule_name"),
721
_("storage_parameter"),
723
_("storage_parameter"),
729
_("and table_constraint_using_index is:"),
730
_("constraint_name"),
735
sql_help_ALTER_TABLESPACE(PQExpBuffer buf)
737
appendPQExpBuffer(buf,
738
"ALTER TABLESPACE %s RENAME TO %s\n"
739
"ALTER TABLESPACE %s OWNER TO %s\n"
740
"ALTER TABLESPACE %s SET ( %s = %s [, ... ] )\n"
741
"ALTER TABLESPACE %s RESET ( %s [, ... ] )",
747
_("tablespace_option"),
750
_("tablespace_option"));
754
sql_help_ALTER_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf)
756
appendPQExpBuffer(buf,
757
"ALTER TEXT SEARCH CONFIGURATION %s\n"
758
" ADD MAPPING FOR %s [, ... ] WITH %s [, ... ]\n"
759
"ALTER TEXT SEARCH CONFIGURATION %s\n"
760
" ALTER MAPPING FOR %s [, ... ] WITH %s [, ... ]\n"
761
"ALTER TEXT SEARCH CONFIGURATION %s\n"
762
" ALTER MAPPING REPLACE %s WITH %s\n"
763
"ALTER TEXT SEARCH CONFIGURATION %s\n"
764
" ALTER MAPPING FOR %s [, ... ] REPLACE %s WITH %s\n"
765
"ALTER TEXT SEARCH CONFIGURATION %s\n"
766
" DROP MAPPING [ IF EXISTS ] FOR %s [, ... ]\n"
767
"ALTER TEXT SEARCH CONFIGURATION %s RENAME TO %s\n"
768
"ALTER TEXT SEARCH CONFIGURATION %s OWNER TO %s\n"
769
"ALTER TEXT SEARCH CONFIGURATION %s SET SCHEMA %s",
772
_("dictionary_name"),
775
_("dictionary_name"),
794
sql_help_ALTER_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf)
796
appendPQExpBuffer(buf,
797
"ALTER TEXT SEARCH DICTIONARY %s (\n"
798
" %s [ = %s ] [, ... ]\n"
800
"ALTER TEXT SEARCH DICTIONARY %s RENAME TO %s\n"
801
"ALTER TEXT SEARCH DICTIONARY %s OWNER TO %s\n"
802
"ALTER TEXT SEARCH DICTIONARY %s SET SCHEMA %s",
815
sql_help_ALTER_TEXT_SEARCH_PARSER(PQExpBuffer buf)
817
appendPQExpBuffer(buf,
818
"ALTER TEXT SEARCH PARSER %s RENAME TO %s\n"
819
"ALTER TEXT SEARCH PARSER %s SET SCHEMA %s",
827
sql_help_ALTER_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf)
829
appendPQExpBuffer(buf,
830
"ALTER TEXT SEARCH TEMPLATE %s RENAME TO %s\n"
831
"ALTER TEXT SEARCH TEMPLATE %s SET SCHEMA %s",
839
sql_help_ALTER_TRIGGER(PQExpBuffer buf)
841
appendPQExpBuffer(buf,
842
"ALTER TRIGGER %s ON %s RENAME TO %s",
849
sql_help_ALTER_TYPE(PQExpBuffer buf)
851
appendPQExpBuffer(buf,
852
"ALTER TYPE %s %s [, ... ]\n"
853
"ALTER TYPE %s OWNER TO %s\n"
854
"ALTER TYPE %s RENAME ATTRIBUTE %s TO %s\n"
855
"ALTER TYPE %s RENAME TO %s [ CASCADE | RESTRICT ]\n"
856
"ALTER TYPE %s SET SCHEMA %s\n"
857
"ALTER TYPE %s ADD VALUE %s [ { BEFORE | AFTER } %s ]\n"
861
" ADD ATTRIBUTE %s %s [ COLLATE %s ] [ CASCADE | RESTRICT ]\n"
862
" DROP ATTRIBUTE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]\n"
863
" ALTER ATTRIBUTE %s [ SET DATA ] TYPE %s [ COLLATE %s ] [ CASCADE | RESTRICT ]",
870
_("new_attribute_name"),
877
_("existing_enum_value"),
878
_("where action is one of:"),
889
sql_help_ALTER_USER(PQExpBuffer buf)
891
appendPQExpBuffer(buf,
892
"ALTER USER %s [ [ WITH ] %s [ ... ] ]\n"
896
" SUPERUSER | NOSUPERUSER\n"
897
" | CREATEDB | NOCREATEDB\n"
898
" | CREATEROLE | NOCREATEROLE\n"
899
" | CREATEUSER | NOCREATEUSER\n"
900
" | INHERIT | NOINHERIT\n"
901
" | LOGIN | NOLOGIN\n"
902
" | REPLICATION | NOREPLICATION\n"
903
" | CONNECTION LIMIT %s\n"
904
" | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '%s'\n"
905
" | VALID UNTIL '%s'\n"
907
"ALTER USER %s RENAME TO %s\n"
909
"ALTER USER %s SET %s { TO | = } { %s | DEFAULT }\n"
910
"ALTER USER %s SET %s FROM CURRENT\n"
911
"ALTER USER %s RESET %s\n"
912
"ALTER USER %s RESET ALL",
915
_("where option can be:"),
922
_("configuration_parameter"),
925
_("configuration_parameter"),
927
_("configuration_parameter"),
932
sql_help_ALTER_USER_MAPPING(PQExpBuffer buf)
934
appendPQExpBuffer(buf,
935
"ALTER USER MAPPING FOR { %s | USER | CURRENT_USER | PUBLIC }\n"
937
" OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ] )",
945
sql_help_ALTER_VIEW(PQExpBuffer buf)
947
appendPQExpBuffer(buf,
948
"ALTER VIEW %s ALTER [ COLUMN ] %s SET DEFAULT %s\n"
949
"ALTER VIEW %s ALTER [ COLUMN ] %s DROP DEFAULT\n"
950
"ALTER VIEW %s OWNER TO %s\n"
951
"ALTER VIEW %s RENAME TO %s\n"
952
"ALTER VIEW %s SET SCHEMA %s",
967
sql_help_ANALYZE(PQExpBuffer buf)
969
appendPQExpBuffer(buf,
970
"ANALYZE [ VERBOSE ] [ %s [ ( %s [, ...] ) ] ]",
976
sql_help_BEGIN(PQExpBuffer buf)
978
appendPQExpBuffer(buf,
979
"BEGIN [ WORK | TRANSACTION ] [ %s [, ...] ]\n"
983
" ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n"
984
" READ WRITE | READ ONLY\n"
985
" [ NOT ] DEFERRABLE",
986
_("transaction_mode"),
987
_("where transaction_mode is one of:"));
991
sql_help_CHECKPOINT(PQExpBuffer buf)
993
appendPQExpBuffer(buf,
998
sql_help_CLOSE(PQExpBuffer buf)
1000
appendPQExpBuffer(buf,
1001
"CLOSE { %s | ALL }",
1006
sql_help_CLUSTER(PQExpBuffer buf)
1008
appendPQExpBuffer(buf,
1009
"CLUSTER [VERBOSE] %s [ USING %s ]\n"
1010
"CLUSTER [VERBOSE]",
1016
sql_help_COMMENT(PQExpBuffer buf)
1018
appendPQExpBuffer(buf,
1023
" AGGREGATE %s (%s [, ...] ) |\n"
1024
" CAST (%s AS %s) |\n"
1026
" CONSTRAINT %s ON %s |\n"
1027
" CONVERSION %s |\n"
1031
" FOREIGN DATA WRAPPER %s |\n"
1032
" FOREIGN TABLE %s |\n"
1033
" FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] ) |\n"
1035
" LARGE OBJECT %s |\n"
1036
" OPERATOR %s (%s, %s) |\n"
1037
" OPERATOR CLASS %s USING %s |\n"
1038
" OPERATOR FAMILY %s USING %s |\n"
1039
" [ PROCEDURAL ] LANGUAGE %s |\n"
1041
" RULE %s ON %s |\n"
1045
" TABLESPACE %s |\n"
1046
" TEXT SEARCH CONFIGURATION %s |\n"
1047
" TEXT SEARCH DICTIONARY %s |\n"
1048
" TEXT SEARCH PARSER %s |\n"
1049
" TEXT SEARCH TEMPLATE %s |\n"
1050
" TRIGGER %s ON %s |\n"
1062
_("constraint_name"),
1075
_("large_object_oid"),
1103
sql_help_COMMIT(PQExpBuffer buf)
1105
appendPQExpBuffer(buf,
1106
"COMMIT [ WORK | TRANSACTION ]");
1110
sql_help_COMMIT_PREPARED(PQExpBuffer buf)
1112
appendPQExpBuffer(buf,
1113
"COMMIT PREPARED %s",
1114
_("transaction_id"));
1118
sql_help_COPY(PQExpBuffer buf)
1120
appendPQExpBuffer(buf,
1121
"COPY %s [ ( %s [, ...] ) ]\n"
1122
" FROM { '%s' | STDIN }\n"
1123
" [ [ WITH ] ( %s [, ...] ) ]\n"
1125
"COPY { %s [ ( %s [, ...] ) ] | ( %s ) }\n"
1126
" TO { '%s' | STDOUT }\n"
1127
" [ [ WITH ] ( %s [, ...] ) ]\n"
1138
" FORCE_QUOTE { ( %s [, ...] ) | * }\n"
1139
" FORCE_NOT_NULL ( %s [, ...] ) |\n"
1150
_("where option can be one of:"),
1153
_("delimiter_character"),
1156
_("quote_character"),
1157
_("escape_character"),
1160
_("encoding_name"));
1164
sql_help_CREATE_AGGREGATE(PQExpBuffer buf)
1166
appendPQExpBuffer(buf,
1167
"CREATE AGGREGATE %s ( %s [ , ... ] ) (\n"
1170
" [ , FINALFUNC = %s ]\n"
1171
" [ , INITCOND = %s ]\n"
1172
" [ , SORTOP = %s ]\n"
1177
"CREATE AGGREGATE %s (\n"
1181
" [ , FINALFUNC = %s ]\n"
1182
" [ , INITCOND = %s ]\n"
1183
" [ , SORTOP = %s ]\n"
1186
_("input_data_type"),
1188
_("state_data_type"),
1190
_("initial_condition"),
1192
_("or the old syntax"),
1196
_("state_data_type"),
1198
_("initial_condition"),
1199
_("sort_operator"));
1203
sql_help_CREATE_CAST(PQExpBuffer buf)
1205
appendPQExpBuffer(buf,
1206
"CREATE CAST (%s AS %s)\n"
1207
" WITH FUNCTION %s (%s [, ...])\n"
1208
" [ AS ASSIGNMENT | AS IMPLICIT ]\n"
1210
"CREATE CAST (%s AS %s)\n"
1211
" WITHOUT FUNCTION\n"
1212
" [ AS ASSIGNMENT | AS IMPLICIT ]\n"
1214
"CREATE CAST (%s AS %s)\n"
1216
" [ AS ASSIGNMENT | AS IMPLICIT ]",
1228
sql_help_CREATE_COLLATION(PQExpBuffer buf)
1230
appendPQExpBuffer(buf,
1231
"CREATE COLLATION %s (\n"
1232
" [ LOCALE = %s, ]\n"
1233
" [ LC_COLLATE = %s, ]\n"
1234
" [ LC_CTYPE = %s ]\n"
1236
"CREATE COLLATION %s FROM %s",
1242
_("existing_collation"));
1246
sql_help_CREATE_CONVERSION(PQExpBuffer buf)
1248
appendPQExpBuffer(buf,
1249
"CREATE [ DEFAULT ] CONVERSION %s\n"
1250
" FOR %s TO %s FROM %s",
1252
_("source_encoding"),
1254
_("function_name"));
1258
sql_help_CREATE_DATABASE(PQExpBuffer buf)
1260
appendPQExpBuffer(buf,
1261
"CREATE DATABASE %s\n"
1262
" [ [ WITH ] [ OWNER [=] %s ]\n"
1263
" [ TEMPLATE [=] %s ]\n"
1264
" [ ENCODING [=] %s ]\n"
1265
" [ LC_COLLATE [=] %s ]\n"
1266
" [ LC_CTYPE [=] %s ]\n"
1267
" [ TABLESPACE [=] %s ]\n"
1268
" [ CONNECTION LIMIT [=] %s ] ]",
1280
sql_help_CREATE_DOMAIN(PQExpBuffer buf)
1282
appendPQExpBuffer(buf,
1283
"CREATE DOMAIN %s [ AS ] %s\n"
1290
"[ CONSTRAINT %s ]\n"
1291
"{ NOT NULL | NULL | CHECK (%s) }",
1297
_("where constraint is:"),
1298
_("constraint_name"),
1303
sql_help_CREATE_EXTENSION(PQExpBuffer buf)
1305
appendPQExpBuffer(buf,
1306
"CREATE EXTENSION [ IF NOT EXISTS ] %s\n"
1307
" [ WITH ] [ SCHEMA %s ]\n"
1310
_("extension_name"),
1317
sql_help_CREATE_FOREIGN_DATA_WRAPPER(PQExpBuffer buf)
1319
appendPQExpBuffer(buf,
1320
"CREATE FOREIGN DATA WRAPPER %s\n"
1321
" [ HANDLER %s | NO HANDLER ]\n"
1322
" [ VALIDATOR %s | NO VALIDATOR ]\n"
1323
" [ OPTIONS ( %s '%s' [, ... ] ) ]",
1325
_("handler_function"),
1326
_("validator_function"),
1332
sql_help_CREATE_FOREIGN_TABLE(PQExpBuffer buf)
1334
appendPQExpBuffer(buf,
1335
"CREATE FOREIGN TABLE [ IF NOT EXISTS ] %s ( [\n"
1336
" { %s %s [ NULL | NOT NULL ] }\n"
1340
"[ OPTIONS ( %s '%s' [, ... ] ) ]",
1350
sql_help_CREATE_FUNCTION(PQExpBuffer buf)
1352
appendPQExpBuffer(buf,
1353
"CREATE [ OR REPLACE ] FUNCTION\n"
1354
" %s ( [ [ %s ] [ %s ] %s [ { DEFAULT | = } %s ] [, ...] ] )\n"
1356
" | RETURNS TABLE ( %s %s [, ...] ) ]\n"
1359
" | IMMUTABLE | STABLE | VOLATILE\n"
1360
" | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT\n"
1361
" | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n"
1364
" | SET %s { TO %s | = %s | FROM CURRENT }\n"
1366
" | AS '%s', '%s'\n"
1368
" [ WITH ( %s [, ...] ) ]",
1378
_("execution_cost"),
1380
_("configuration_parameter"),
1390
sql_help_CREATE_GROUP(PQExpBuffer buf)
1392
appendPQExpBuffer(buf,
1393
"CREATE GROUP %s [ [ WITH ] %s [ ... ] ]\n"
1397
" SUPERUSER | NOSUPERUSER\n"
1398
" | CREATEDB | NOCREATEDB\n"
1399
" | CREATEROLE | NOCREATEROLE\n"
1400
" | CREATEUSER | NOCREATEUSER\n"
1401
" | INHERIT | NOINHERIT\n"
1402
" | LOGIN | NOLOGIN\n"
1403
" | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '%s'\n"
1404
" | VALID UNTIL '%s'\n"
1405
" | IN ROLE %s [, ...]\n"
1406
" | IN GROUP %s [, ...]\n"
1407
" | ROLE %s [, ...]\n"
1408
" | ADMIN %s [, ...]\n"
1409
" | USER %s [, ...]\n"
1413
_("where option can be:"),
1425
sql_help_CREATE_INDEX(PQExpBuffer buf)
1427
appendPQExpBuffer(buf,
1428
"CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ %s ] ON %s [ USING %s ]\n"
1429
" ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )\n"
1430
" [ WITH ( %s = %s [, ... ] ) ]\n"
1431
" [ TABLESPACE %s ]\n"
1440
_("storage_parameter"),
1447
sql_help_CREATE_LANGUAGE(PQExpBuffer buf)
1449
appendPQExpBuffer(buf,
1450
"CREATE [ OR REPLACE ] [ PROCEDURAL ] LANGUAGE %s\n"
1451
"CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE %s\n"
1452
" HANDLER %s [ INLINE %s ] [ VALIDATOR %s ]",
1456
_("inline_handler"),
1461
sql_help_CREATE_OPERATOR(PQExpBuffer buf)
1463
appendPQExpBuffer(buf,
1464
"CREATE OPERATOR %s (\n"
1466
" [, LEFTARG = %s ] [, RIGHTARG = %s ]\n"
1467
" [, COMMUTATOR = %s ] [, NEGATOR = %s ]\n"
1468
" [, RESTRICT = %s ] [, JOIN = %s ]\n"
1469
" [, HASHES ] [, MERGES ]\n"
1482
sql_help_CREATE_OPERATOR_CLASS(PQExpBuffer buf)
1484
appendPQExpBuffer(buf,
1485
"CREATE OPERATOR CLASS %s [ DEFAULT ] FOR TYPE %s\n"
1486
" USING %s [ FAMILY %s ] AS\n"
1487
" { OPERATOR %s %s [ ( %s, %s ) ] [ FOR SEARCH | FOR ORDER BY %s ]\n"
1488
" | FUNCTION %s [ ( %s [ , %s ] ) ] %s ( %s [, ...] )\n"
1495
_("strategy_number"),
1499
_("sort_family_name"),
1500
_("support_number"),
1509
sql_help_CREATE_OPERATOR_FAMILY(PQExpBuffer buf)
1511
appendPQExpBuffer(buf,
1512
"CREATE OPERATOR FAMILY %s USING %s",
1518
sql_help_CREATE_ROLE(PQExpBuffer buf)
1520
appendPQExpBuffer(buf,
1521
"CREATE ROLE %s [ [ WITH ] %s [ ... ] ]\n"
1525
" SUPERUSER | NOSUPERUSER\n"
1526
" | CREATEDB | NOCREATEDB\n"
1527
" | CREATEROLE | NOCREATEROLE\n"
1528
" | CREATEUSER | NOCREATEUSER\n"
1529
" | INHERIT | NOINHERIT\n"
1530
" | LOGIN | NOLOGIN\n"
1531
" | REPLICATION | NOREPLICATION\n"
1532
" | CONNECTION LIMIT %s\n"
1533
" | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '%s'\n"
1534
" | VALID UNTIL '%s'\n"
1535
" | IN ROLE %s [, ...]\n"
1536
" | IN GROUP %s [, ...]\n"
1537
" | ROLE %s [, ...]\n"
1538
" | ADMIN %s [, ...]\n"
1539
" | USER %s [, ...]\n"
1543
_("where option can be:"),
1556
sql_help_CREATE_RULE(PQExpBuffer buf)
1558
appendPQExpBuffer(buf,
1559
"CREATE [ OR REPLACE ] RULE %s AS ON %s\n"
1560
" TO %s [ WHERE %s ]\n"
1561
" DO [ ALSO | INSTEAD ] { NOTHING | %s | ( %s ; %s ... ) }",
1572
sql_help_CREATE_SCHEMA(PQExpBuffer buf)
1574
appendPQExpBuffer(buf,
1575
"CREATE SCHEMA %s [ AUTHORIZATION %s ] [ %s [ ... ] ]\n"
1576
"CREATE SCHEMA AUTHORIZATION %s [ %s [ ... ] ]",
1579
_("schema_element"),
1581
_("schema_element"));
1585
sql_help_CREATE_SEQUENCE(PQExpBuffer buf)
1587
appendPQExpBuffer(buf,
1588
"CREATE [ TEMPORARY | TEMP ] SEQUENCE %s [ INCREMENT [ BY ] %s ]\n"
1589
" [ MINVALUE %s | NO MINVALUE ] [ MAXVALUE %s | NO MAXVALUE ]\n"
1590
" [ START [ WITH ] %s ] [ CACHE %s ] [ [ NO ] CYCLE ]\n"
1591
" [ OWNED BY { %s.%s | NONE } ]",
1603
sql_help_CREATE_SERVER(PQExpBuffer buf)
1605
appendPQExpBuffer(buf,
1606
"CREATE SERVER %s [ TYPE '%s' ] [ VERSION '%s' ]\n"
1607
" FOREIGN DATA WRAPPER %s\n"
1608
" [ OPTIONS ( %s '%s' [, ... ] ) ]",
1611
_("server_version"),
1618
sql_help_CREATE_TABLE(PQExpBuffer buf)
1620
appendPQExpBuffer(buf,
1621
"CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s ( [\n"
1622
" { %s %s [ COLLATE %s ] [ %s [ ... ] ]\n"
1624
" | LIKE %s [ %s ... ] }\n"
1627
"[ INHERITS ( %s [, ... ] ) ]\n"
1628
"[ WITH ( %s [= %s] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n"
1629
"[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n"
1630
"[ TABLESPACE %s ]\n"
1632
"CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s\n"
1634
" { %s WITH OPTIONS [ %s [ ... ] ]\n"
1638
"[ WITH ( %s [= %s] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n"
1639
"[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n"
1640
"[ TABLESPACE %s ]\n"
1644
"[ CONSTRAINT %s ]\n"
1650
" PRIMARY KEY %s |\n"
1651
" REFERENCES %s [ ( %s ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]\n"
1652
" [ ON DELETE %s ] [ ON UPDATE %s ] }\n"
1653
"[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n"
1657
"[ CONSTRAINT %s ]\n"
1658
"{ CHECK ( %s ) |\n"
1659
" UNIQUE ( %s [, ... ] ) %s |\n"
1660
" PRIMARY KEY ( %s [, ... ] ) %s |\n"
1661
" EXCLUDE [ USING %s ] ( %s WITH %s [, ... ] ) %s [ WHERE ( %s ) ] |\n"
1662
" FOREIGN KEY ( %s [, ... ] ) REFERENCES %s [ ( %s [, ... ] ) ]\n"
1663
" [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE %s ] [ ON UPDATE %s ] }\n"
1664
"[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n"
1668
"{ INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES | STORAGE | COMMENTS | ALL }\n"
1672
"[ WITH ( %s [= %s] [, ... ] ) ]\n"
1673
"[ USING INDEX TABLESPACE %s ]\n"
1677
"{ %s | ( %s ) } [ %s ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]",
1682
_("column_constraint"),
1683
_("table_constraint"),
1687
_("storage_parameter"),
1693
_("column_constraint"),
1694
_("table_constraint"),
1695
_("storage_parameter"),
1698
_("where column_constraint is:"),
1699
_("constraint_name"),
1702
_("index_parameters"),
1703
_("index_parameters"),
1708
_("and table_constraint is:"),
1709
_("constraint_name"),
1712
_("index_parameters"),
1714
_("index_parameters"),
1716
_("exclude_element"),
1718
_("index_parameters"),
1725
_("and like_option is:"),
1726
_("index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:"),
1727
_("storage_parameter"),
1730
_("exclude_element in an EXCLUDE constraint is:"),
1737
sql_help_CREATE_TABLE_AS(PQExpBuffer buf)
1739
appendPQExpBuffer(buf,
1740
"CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE %s\n"
1741
" [ (%s [, ...] ) ]\n"
1742
" [ WITH ( %s [= %s] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n"
1743
" [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n"
1744
" [ TABLESPACE %s ]\n"
1746
" [ WITH [ NO ] DATA ]",
1749
_("storage_parameter"),
1756
sql_help_CREATE_TABLESPACE(PQExpBuffer buf)
1758
appendPQExpBuffer(buf,
1759
"CREATE TABLESPACE %s [ OWNER %s ] LOCATION '%s'",
1760
_("tablespace_name"),
1766
sql_help_CREATE_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf)
1768
appendPQExpBuffer(buf,
1769
"CREATE TEXT SEARCH CONFIGURATION %s (\n"
1775
_("source_config"));
1779
sql_help_CREATE_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf)
1781
appendPQExpBuffer(buf,
1782
"CREATE TEXT SEARCH DICTIONARY %s (\n"
1784
" [, %s = %s [, ... ]]\n"
1793
sql_help_CREATE_TEXT_SEARCH_PARSER(PQExpBuffer buf)
1795
appendPQExpBuffer(buf,
1796
"CREATE TEXT SEARCH PARSER %s (\n"
1798
" GETTOKEN = %s ,\n"
1801
" [, HEADLINE = %s ]\n"
1804
_("start_function"),
1805
_("gettoken_function"),
1807
_("lextypes_function"),
1808
_("headline_function"));
1812
sql_help_CREATE_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf)
1814
appendPQExpBuffer(buf,
1815
"CREATE TEXT SEARCH TEMPLATE %s (\n"
1816
" [ INIT = %s , ]\n"
1821
_("lexize_function"));
1825
sql_help_CREATE_TRIGGER(PQExpBuffer buf)
1827
appendPQExpBuffer(buf,
1828
"CREATE [ CONSTRAINT ] TRIGGER %s { BEFORE | AFTER | INSTEAD OF } { %s [ OR ... ] }\n"
1831
" { NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }\n"
1832
" [ FOR [ EACH ] { ROW | STATEMENT } ]\n"
1833
" [ WHEN ( %s ) ]\n"
1834
" EXECUTE PROCEDURE %s ( %s )\n"
1839
" UPDATE [ OF %s [, ... ] ]\n"
1845
_("referenced_table_name"),
1849
_("where event can be one of:"),
1854
sql_help_CREATE_TYPE(PQExpBuffer buf)
1856
appendPQExpBuffer(buf,
1857
"CREATE TYPE %s AS\n"
1858
" ( [ %s %s [ COLLATE %s ] [, ... ] ] )\n"
1860
"CREATE TYPE %s AS ENUM\n"
1861
" ( [ '%s' [, ... ] ] )\n"
1863
"CREATE TYPE %s (\n"
1866
" [ , RECEIVE = %s ]\n"
1867
" [ , SEND = %s ]\n"
1868
" [ , TYPMOD_IN = %s ]\n"
1869
" [ , TYPMOD_OUT = %s ]\n"
1870
" [ , ANALYZE = %s ]\n"
1871
" [ , INTERNALLENGTH = { %s | VARIABLE } ]\n"
1872
" [ , PASSEDBYVALUE ]\n"
1873
" [ , ALIGNMENT = %s ]\n"
1874
" [ , STORAGE = %s ]\n"
1875
" [ , LIKE = %s ]\n"
1876
" [ , CATEGORY = %s ]\n"
1877
" [ , PREFERRED = %s ]\n"
1878
" [ , DEFAULT = %s ]\n"
1879
" [ , ELEMENT = %s ]\n"
1880
" [ , DELIMITER = %s ]\n"
1881
" [ , COLLATABLE = %s ]\n"
1886
_("attribute_name"),
1892
_("input_function"),
1893
_("output_function"),
1894
_("receive_function"),
1896
_("type_modifier_input_function"),
1897
_("type_modifier_output_function"),
1898
_("analyze_function"),
1899
_("internallength"),
1913
sql_help_CREATE_USER(PQExpBuffer buf)
1915
appendPQExpBuffer(buf,
1916
"CREATE USER %s [ [ WITH ] %s [ ... ] ]\n"
1920
" SUPERUSER | NOSUPERUSER\n"
1921
" | CREATEDB | NOCREATEDB\n"
1922
" | CREATEROLE | NOCREATEROLE\n"
1923
" | CREATEUSER | NOCREATEUSER\n"
1924
" | INHERIT | NOINHERIT\n"
1925
" | LOGIN | NOLOGIN\n"
1926
" | REPLICATION | NOREPLICATION\n"
1927
" | CONNECTION LIMIT %s\n"
1928
" | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '%s'\n"
1929
" | VALID UNTIL '%s'\n"
1930
" | IN ROLE %s [, ...]\n"
1931
" | IN GROUP %s [, ...]\n"
1932
" | ROLE %s [, ...]\n"
1933
" | ADMIN %s [, ...]\n"
1934
" | USER %s [, ...]\n"
1938
_("where option can be:"),
1951
sql_help_CREATE_USER_MAPPING(PQExpBuffer buf)
1953
appendPQExpBuffer(buf,
1954
"CREATE USER MAPPING FOR { %s | USER | CURRENT_USER | PUBLIC }\n"
1956
" [ OPTIONS ( %s '%s' [ , ... ] ) ]",
1964
sql_help_CREATE_VIEW(PQExpBuffer buf)
1966
appendPQExpBuffer(buf,
1967
"CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW %s [ ( %s [, ...] ) ]\n"
1975
sql_help_DEALLOCATE(PQExpBuffer buf)
1977
appendPQExpBuffer(buf,
1978
"DEALLOCATE [ PREPARE ] { %s | ALL }",
1983
sql_help_DECLARE(PQExpBuffer buf)
1985
appendPQExpBuffer(buf,
1986
"DECLARE %s [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ]\n"
1987
" CURSOR [ { WITH | WITHOUT } HOLD ] FOR %s",
1993
sql_help_DELETE(PQExpBuffer buf)
1995
appendPQExpBuffer(buf,
1996
"[ WITH [ RECURSIVE ] %s [, ...] ]\n"
1997
"DELETE FROM [ ONLY ] %s [ [ AS ] %s ]\n"
1999
" [ WHERE %s | WHERE CURRENT OF %s ]\n"
2000
" [ RETURNING * | %s [ [ AS ] %s ] [, ...] ]",
2007
_("output_expression"),
2012
sql_help_DISCARD(PQExpBuffer buf)
2014
appendPQExpBuffer(buf,
2015
"DISCARD { ALL | PLANS | TEMPORARY | TEMP }");
2019
sql_help_DO(PQExpBuffer buf)
2021
appendPQExpBuffer(buf,
2022
"DO [ LANGUAGE %s ] %s",
2028
sql_help_DROP_AGGREGATE(PQExpBuffer buf)
2030
appendPQExpBuffer(buf,
2031
"DROP AGGREGATE [ IF EXISTS ] %s ( %s [ , ... ] ) [ CASCADE | RESTRICT ]",
2037
sql_help_DROP_CAST(PQExpBuffer buf)
2039
appendPQExpBuffer(buf,
2040
"DROP CAST [ IF EXISTS ] (%s AS %s) [ CASCADE | RESTRICT ]",
2046
sql_help_DROP_COLLATION(PQExpBuffer buf)
2048
appendPQExpBuffer(buf,
2049
"DROP COLLATION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2054
sql_help_DROP_CONVERSION(PQExpBuffer buf)
2056
appendPQExpBuffer(buf,
2057
"DROP CONVERSION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2062
sql_help_DROP_DATABASE(PQExpBuffer buf)
2064
appendPQExpBuffer(buf,
2065
"DROP DATABASE [ IF EXISTS ] %s",
2070
sql_help_DROP_DOMAIN(PQExpBuffer buf)
2072
appendPQExpBuffer(buf,
2073
"DROP DOMAIN [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2078
sql_help_DROP_EXTENSION(PQExpBuffer buf)
2080
appendPQExpBuffer(buf,
2081
"DROP EXTENSION [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2082
_("extension_name"));
2086
sql_help_DROP_FOREIGN_DATA_WRAPPER(PQExpBuffer buf)
2088
appendPQExpBuffer(buf,
2089
"DROP FOREIGN DATA WRAPPER [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2094
sql_help_DROP_FOREIGN_TABLE(PQExpBuffer buf)
2096
appendPQExpBuffer(buf,
2097
"DROP FOREIGN TABLE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2102
sql_help_DROP_FUNCTION(PQExpBuffer buf)
2104
appendPQExpBuffer(buf,
2105
"DROP FUNCTION [ IF EXISTS ] %s ( [ [ %s ] [ %s ] %s [, ...] ] )\n"
2106
" [ CASCADE | RESTRICT ]",
2114
sql_help_DROP_GROUP(PQExpBuffer buf)
2116
appendPQExpBuffer(buf,
2117
"DROP GROUP [ IF EXISTS ] %s [, ...]",
2122
sql_help_DROP_INDEX(PQExpBuffer buf)
2124
appendPQExpBuffer(buf,
2125
"DROP INDEX [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2130
sql_help_DROP_LANGUAGE(PQExpBuffer buf)
2132
appendPQExpBuffer(buf,
2133
"DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2138
sql_help_DROP_OPERATOR(PQExpBuffer buf)
2140
appendPQExpBuffer(buf,
2141
"DROP OPERATOR [ IF EXISTS ] %s ( { %s | NONE } , { %s | NONE } ) [ CASCADE | RESTRICT ]",
2148
sql_help_DROP_OPERATOR_CLASS(PQExpBuffer buf)
2150
appendPQExpBuffer(buf,
2151
"DROP OPERATOR CLASS [ IF EXISTS ] %s USING %s [ CASCADE | RESTRICT ]",
2157
sql_help_DROP_OPERATOR_FAMILY(PQExpBuffer buf)
2159
appendPQExpBuffer(buf,
2160
"DROP OPERATOR FAMILY [ IF EXISTS ] %s USING %s [ CASCADE | RESTRICT ]",
2166
sql_help_DROP_OWNED(PQExpBuffer buf)
2168
appendPQExpBuffer(buf,
2169
"DROP OWNED BY %s [, ...] [ CASCADE | RESTRICT ]",
2174
sql_help_DROP_ROLE(PQExpBuffer buf)
2176
appendPQExpBuffer(buf,
2177
"DROP ROLE [ IF EXISTS ] %s [, ...]",
2182
sql_help_DROP_RULE(PQExpBuffer buf)
2184
appendPQExpBuffer(buf,
2185
"DROP RULE [ IF EXISTS ] %s ON %s [ CASCADE | RESTRICT ]",
2191
sql_help_DROP_SCHEMA(PQExpBuffer buf)
2193
appendPQExpBuffer(buf,
2194
"DROP SCHEMA [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2199
sql_help_DROP_SEQUENCE(PQExpBuffer buf)
2201
appendPQExpBuffer(buf,
2202
"DROP SEQUENCE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2207
sql_help_DROP_SERVER(PQExpBuffer buf)
2209
appendPQExpBuffer(buf,
2210
"DROP SERVER [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2215
sql_help_DROP_TABLE(PQExpBuffer buf)
2217
appendPQExpBuffer(buf,
2218
"DROP TABLE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2223
sql_help_DROP_TABLESPACE(PQExpBuffer buf)
2225
appendPQExpBuffer(buf,
2226
"DROP TABLESPACE [ IF EXISTS ] %s",
2227
_("tablespace_name"));
2231
sql_help_DROP_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf)
2233
appendPQExpBuffer(buf,
2234
"DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2239
sql_help_DROP_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf)
2241
appendPQExpBuffer(buf,
2242
"DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2247
sql_help_DROP_TEXT_SEARCH_PARSER(PQExpBuffer buf)
2249
appendPQExpBuffer(buf,
2250
"DROP TEXT SEARCH PARSER [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2255
sql_help_DROP_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf)
2257
appendPQExpBuffer(buf,
2258
"DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
2263
sql_help_DROP_TRIGGER(PQExpBuffer buf)
2265
appendPQExpBuffer(buf,
2266
"DROP TRIGGER [ IF EXISTS ] %s ON %s [ CASCADE | RESTRICT ]",
2272
sql_help_DROP_TYPE(PQExpBuffer buf)
2274
appendPQExpBuffer(buf,
2275
"DROP TYPE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2280
sql_help_DROP_USER(PQExpBuffer buf)
2282
appendPQExpBuffer(buf,
2283
"DROP USER [ IF EXISTS ] %s [, ...]",
2288
sql_help_DROP_USER_MAPPING(PQExpBuffer buf)
2290
appendPQExpBuffer(buf,
2291
"DROP USER MAPPING [ IF EXISTS ] FOR { %s | USER | CURRENT_USER | PUBLIC } SERVER %s",
2297
sql_help_DROP_VIEW(PQExpBuffer buf)
2299
appendPQExpBuffer(buf,
2300
"DROP VIEW [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
2305
sql_help_END(PQExpBuffer buf)
2307
appendPQExpBuffer(buf,
2308
"END [ WORK | TRANSACTION ]");
2312
sql_help_EXECUTE(PQExpBuffer buf)
2314
appendPQExpBuffer(buf,
2315
"EXECUTE %s [ ( %s [, ...] ) ]",
2321
sql_help_EXPLAIN(PQExpBuffer buf)
2323
appendPQExpBuffer(buf,
2324
"EXPLAIN [ ( %s [, ...] ) ] %s\n"
2325
"EXPLAIN [ ANALYZE ] [ VERBOSE ] %s\n"
2333
" FORMAT { TEXT | XML | JSON | YAML }",
2337
_("where option can be one of:"),
2345
sql_help_FETCH(PQExpBuffer buf)
2347
appendPQExpBuffer(buf,
2348
"FETCH [ %s [ FROM | IN ] ] %s\n"
2368
_("where direction can be empty or one of:"),
2377
sql_help_GRANT(PQExpBuffer buf)
2379
appendPQExpBuffer(buf,
2380
"GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }\n"
2381
" [, ...] | ALL [ PRIVILEGES ] }\n"
2382
" ON { [ TABLE ] %s [, ...]\n"
2383
" | ALL TABLES IN SCHEMA %s [, ...] }\n"
2384
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2386
"GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( %s [, ...] )\n"
2387
" [, ...] | ALL [ PRIVILEGES ] ( %s [, ...] ) }\n"
2388
" ON [ TABLE ] %s [, ...]\n"
2389
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2391
"GRANT { { USAGE | SELECT | UPDATE }\n"
2392
" [, ...] | ALL [ PRIVILEGES ] }\n"
2393
" ON { SEQUENCE %s [, ...]\n"
2394
" | ALL SEQUENCES IN SCHEMA %s [, ...] }\n"
2395
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2397
"GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }\n"
2398
" ON DATABASE %s [, ...]\n"
2399
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2401
"GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
2402
" ON FOREIGN DATA WRAPPER %s [, ...]\n"
2403
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2405
"GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
2406
" ON FOREIGN SERVER %s [, ...]\n"
2407
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2409
"GRANT { EXECUTE | ALL [ PRIVILEGES ] }\n"
2410
" ON { FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] ) [, ...]\n"
2411
" | ALL FUNCTIONS IN SCHEMA %s [, ...] }\n"
2412
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2414
"GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
2415
" ON LANGUAGE %s [, ...]\n"
2416
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2418
"GRANT { { SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] }\n"
2419
" ON LARGE OBJECT %s [, ...]\n"
2420
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2422
"GRANT { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }\n"
2423
" ON SCHEMA %s [, ...]\n"
2424
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2426
"GRANT { CREATE | ALL [ PRIVILEGES ] }\n"
2427
" ON TABLESPACE %s [, ...]\n"
2428
" TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
2430
"GRANT %s [, ...] TO %s [, ...] [ WITH ADMIN OPTION ]",
2459
_("tablespace_name"),
2466
sql_help_INSERT(PQExpBuffer buf)
2468
appendPQExpBuffer(buf,
2469
"[ WITH [ RECURSIVE ] %s [, ...] ]\n"
2470
"INSERT INTO %s [ ( %s [, ...] ) ]\n"
2471
" { DEFAULT VALUES | VALUES ( { %s | DEFAULT } [, ...] ) [, ...] | %s }\n"
2472
" [ RETURNING * | %s [ [ AS ] %s ] [, ...] ]",
2478
_("output_expression"),
2483
sql_help_LISTEN(PQExpBuffer buf)
2485
appendPQExpBuffer(buf,
2491
sql_help_LOAD(PQExpBuffer buf)
2493
appendPQExpBuffer(buf,
2499
sql_help_LOCK(PQExpBuffer buf)
2501
appendPQExpBuffer(buf,
2502
"LOCK [ TABLE ] [ ONLY ] %s [, ...] [ IN %s MODE ] [ NOWAIT ]\n"
2506
" ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE\n"
2507
" | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE",
2510
_("where lockmode is one of:"));
2514
sql_help_MOVE(PQExpBuffer buf)
2516
appendPQExpBuffer(buf,
2517
"MOVE [ %s [ FROM | IN ] ] %s\n"
2537
_("where direction can be empty or one of:"),
2546
sql_help_NOTIFY(PQExpBuffer buf)
2548
appendPQExpBuffer(buf,
2549
"NOTIFY %s [ , %s ]",
2555
sql_help_PREPARE(PQExpBuffer buf)
2557
appendPQExpBuffer(buf,
2558
"PREPARE %s [ ( %s [, ...] ) ] AS %s",
2565
sql_help_PREPARE_TRANSACTION(PQExpBuffer buf)
2567
appendPQExpBuffer(buf,
2568
"PREPARE TRANSACTION %s",
2569
_("transaction_id"));
2573
sql_help_REASSIGN_OWNED(PQExpBuffer buf)
2575
appendPQExpBuffer(buf,
2576
"REASSIGN OWNED BY %s [, ...] TO %s",
2582
sql_help_REINDEX(PQExpBuffer buf)
2584
appendPQExpBuffer(buf,
2585
"REINDEX { INDEX | TABLE | DATABASE | SYSTEM } %s [ FORCE ]",
2590
sql_help_RELEASE_SAVEPOINT(PQExpBuffer buf)
2592
appendPQExpBuffer(buf,
2593
"RELEASE [ SAVEPOINT ] %s",
2594
_("savepoint_name"));
2598
sql_help_RESET(PQExpBuffer buf)
2600
appendPQExpBuffer(buf,
2603
_("configuration_parameter"));
2607
sql_help_REVOKE(PQExpBuffer buf)
2609
appendPQExpBuffer(buf,
2610
"REVOKE [ GRANT OPTION FOR ]\n"
2611
" { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }\n"
2612
" [, ...] | ALL [ PRIVILEGES ] }\n"
2613
" ON { [ TABLE ] %s [, ...]\n"
2614
" | ALL TABLES IN SCHEMA %s [, ...] }\n"
2615
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2616
" [ CASCADE | RESTRICT ]\n"
2618
"REVOKE [ GRANT OPTION FOR ]\n"
2619
" { { SELECT | INSERT | UPDATE | REFERENCES } ( %s [, ...] )\n"
2620
" [, ...] | ALL [ PRIVILEGES ] ( %s [, ...] ) }\n"
2621
" ON [ TABLE ] %s [, ...]\n"
2622
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2623
" [ CASCADE | RESTRICT ]\n"
2625
"REVOKE [ GRANT OPTION FOR ]\n"
2626
" { { USAGE | SELECT | UPDATE }\n"
2627
" [, ...] | ALL [ PRIVILEGES ] }\n"
2628
" ON { SEQUENCE %s [, ...]\n"
2629
" | ALL SEQUENCES IN SCHEMA %s [, ...] }\n"
2630
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2631
" [ CASCADE | RESTRICT ]\n"
2633
"REVOKE [ GRANT OPTION FOR ]\n"
2634
" { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }\n"
2635
" ON DATABASE %s [, ...]\n"
2636
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2637
" [ CASCADE | RESTRICT ]\n"
2639
"REVOKE [ GRANT OPTION FOR ]\n"
2640
" { USAGE | ALL [ PRIVILEGES ] }\n"
2641
" ON FOREIGN DATA WRAPPER %s [, ...]\n"
2642
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2643
" [ CASCADE | RESTRICT ]\n"
2645
"REVOKE [ GRANT OPTION FOR ]\n"
2646
" { USAGE | ALL [ PRIVILEGES ] }\n"
2647
" ON FOREIGN SERVER %s [, ...]\n"
2648
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2649
" [ CASCADE | RESTRICT ]\n"
2651
"REVOKE [ GRANT OPTION FOR ]\n"
2652
" { EXECUTE | ALL [ PRIVILEGES ] }\n"
2653
" ON { FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] ) [, ...]\n"
2654
" | ALL FUNCTIONS IN SCHEMA %s [, ...] }\n"
2655
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2656
" [ CASCADE | RESTRICT ]\n"
2658
"REVOKE [ GRANT OPTION FOR ]\n"
2659
" { USAGE | ALL [ PRIVILEGES ] }\n"
2660
" ON LANGUAGE %s [, ...]\n"
2661
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2662
" [ CASCADE | RESTRICT ]\n"
2664
"REVOKE [ GRANT OPTION FOR ]\n"
2665
" { { SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] }\n"
2666
" ON LARGE OBJECT %s [, ...]\n"
2667
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2668
" [ CASCADE | RESTRICT ]\n"
2670
"REVOKE [ GRANT OPTION FOR ]\n"
2671
" { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }\n"
2672
" ON SCHEMA %s [, ...]\n"
2673
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2674
" [ CASCADE | RESTRICT ]\n"
2676
"REVOKE [ GRANT OPTION FOR ]\n"
2677
" { CREATE | ALL [ PRIVILEGES ] }\n"
2678
" ON TABLESPACE %s [, ...]\n"
2679
" FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
2680
" [ CASCADE | RESTRICT ]\n"
2682
"REVOKE [ ADMIN OPTION FOR ]\n"
2683
" %s [, ...] FROM %s [, ...]\n"
2684
" [ CASCADE | RESTRICT ]",
2713
_("tablespace_name"),
2720
sql_help_ROLLBACK(PQExpBuffer buf)
2722
appendPQExpBuffer(buf,
2723
"ROLLBACK [ WORK | TRANSACTION ]");
2727
sql_help_ROLLBACK_PREPARED(PQExpBuffer buf)
2729
appendPQExpBuffer(buf,
2730
"ROLLBACK PREPARED %s",
2731
_("transaction_id"));
2735
sql_help_ROLLBACK_TO_SAVEPOINT(PQExpBuffer buf)
2737
appendPQExpBuffer(buf,
2738
"ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] %s",
2739
_("savepoint_name"));
2743
sql_help_SAVEPOINT(PQExpBuffer buf)
2745
appendPQExpBuffer(buf,
2747
_("savepoint_name"));
2751
sql_help_SECURITY_LABEL(PQExpBuffer buf)
2753
appendPQExpBuffer(buf,
2754
"SECURITY LABEL [ FOR %s ] ON\n"
2758
" AGGREGATE %s (%s [, ...] ) |\n"
2760
" FOREIGN TABLE %s\n"
2761
" FUNCTION %s ( [ [ %s ] [ %s ] %s [, ...] ] ) |\n"
2762
" LARGE OBJECT %s |\n"
2763
" [ PROCEDURAL ] LANGUAGE %s |\n"
2781
_("large_object_oid"),
2791
sql_help_SELECT(PQExpBuffer buf)
2793
appendPQExpBuffer(buf,
2794
"[ WITH [ RECURSIVE ] %s [, ...] ]\n"
2795
"SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n"
2796
" * | %s [ [ AS ] %s ] [, ...]\n"
2797
" [ FROM %s [, ...] ]\n"
2799
" [ GROUP BY %s [, ...] ]\n"
2800
" [ HAVING %s [, ...] ]\n"
2801
" [ WINDOW %s AS ( %s ) [, ...] ]\n"
2802
" [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n"
2803
" [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n"
2804
" [ LIMIT { %s | ALL } ]\n"
2805
" [ OFFSET %s [ ROW | ROWS ] ]\n"
2806
" [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]\n"
2807
" [ FOR { UPDATE | SHARE } [ OF %s [, ...] ] [ NOWAIT ] [...] ]\n"
2811
" [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
2812
" ( %s ) [ AS ] %s [ ( %s [, ...] ) ]\n"
2813
" %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
2814
" %s ( [ %s [, ...] ] ) [ AS ] %s [ ( %s [, ...] | %s [, ...] ) ]\n"
2815
" %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n"
2816
" %s [ NATURAL ] %s %s [ ON %s | USING ( %s [, ...] ) ]\n"
2820
" %s [ ( %s [, ...] ) ] AS ( %s | %s | %s | %s )\n"
2822
"TABLE [ ONLY ] %s [ * ]",
2832
_("window_definition"),
2840
_("where from_item can be one of:"),
2847
_("with_query_name"),
2854
_("column_definition"),
2857
_("column_definition"),
2861
_("join_condition"),
2863
_("and with_query is:"),
2864
_("with_query_name"),
2874
sql_help_SELECT_INTO(PQExpBuffer buf)
2876
appendPQExpBuffer(buf,
2877
"[ WITH [ RECURSIVE ] %s [, ...] ]\n"
2878
"SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n"
2879
" * | %s [ [ AS ] %s ] [, ...]\n"
2880
" INTO [ TEMPORARY | TEMP | UNLOGGED ] [ TABLE ] %s\n"
2881
" [ FROM %s [, ...] ]\n"
2883
" [ GROUP BY %s [, ...] ]\n"
2884
" [ HAVING %s [, ...] ]\n"
2885
" [ WINDOW %s AS ( %s ) [, ...] ]\n"
2886
" [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n"
2887
" [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n"
2888
" [ LIMIT { %s | ALL } ]\n"
2889
" [ OFFSET %s [ ROW | ROWS ] ]\n"
2890
" [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]\n"
2891
" [ FOR { UPDATE | SHARE } [ OF %s [, ...] ] [ NOWAIT ] [...] ]",
2902
_("window_definition"),
2913
sql_help_SET(PQExpBuffer buf)
2915
appendPQExpBuffer(buf,
2916
"SET [ SESSION | LOCAL ] %s { TO | = } { %s | '%s' | DEFAULT }\n"
2917
"SET [ SESSION | LOCAL ] TIME ZONE { %s | LOCAL | DEFAULT }",
2918
_("configuration_parameter"),
2925
sql_help_SET_CONSTRAINTS(PQExpBuffer buf)
2927
appendPQExpBuffer(buf,
2928
"SET CONSTRAINTS { ALL | %s [, ...] } { DEFERRED | IMMEDIATE }",
2933
sql_help_SET_ROLE(PQExpBuffer buf)
2935
appendPQExpBuffer(buf,
2936
"SET [ SESSION | LOCAL ] ROLE %s\n"
2937
"SET [ SESSION | LOCAL ] ROLE NONE\n"
2943
sql_help_SET_SESSION_AUTHORIZATION(PQExpBuffer buf)
2945
appendPQExpBuffer(buf,
2946
"SET [ SESSION | LOCAL ] SESSION AUTHORIZATION %s\n"
2947
"SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT\n"
2948
"RESET SESSION AUTHORIZATION",
2953
sql_help_SET_TRANSACTION(PQExpBuffer buf)
2955
appendPQExpBuffer(buf,
2956
"SET TRANSACTION %s [, ...]\n"
2957
"SET SESSION CHARACTERISTICS AS TRANSACTION %s [, ...]\n"
2961
" ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n"
2962
" READ WRITE | READ ONLY\n"
2963
" [ NOT ] DEFERRABLE",
2964
_("transaction_mode"),
2965
_("transaction_mode"),
2966
_("where transaction_mode is one of:"));
2970
sql_help_SHOW(PQExpBuffer buf)
2972
appendPQExpBuffer(buf,
2979
sql_help_START_TRANSACTION(PQExpBuffer buf)
2981
appendPQExpBuffer(buf,
2982
"START TRANSACTION [ %s [, ...] ]\n"
2986
" ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n"
2987
" READ WRITE | READ ONLY\n"
2988
" [ NOT ] DEFERRABLE",
2989
_("transaction_mode"),
2990
_("where transaction_mode is one of:"));
2994
sql_help_TABLE(PQExpBuffer buf)
2996
appendPQExpBuffer(buf,
2997
"[ WITH [ RECURSIVE ] %s [, ...] ]\n"
2998
"SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n"
2999
" * | %s [ [ AS ] %s ] [, ...]\n"
3000
" [ FROM %s [, ...] ]\n"
3002
" [ GROUP BY %s [, ...] ]\n"
3003
" [ HAVING %s [, ...] ]\n"
3004
" [ WINDOW %s AS ( %s ) [, ...] ]\n"
3005
" [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n"
3006
" [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n"
3007
" [ LIMIT { %s | ALL } ]\n"
3008
" [ OFFSET %s [ ROW | ROWS ] ]\n"
3009
" [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]\n"
3010
" [ FOR { UPDATE | SHARE } [ OF %s [, ...] ] [ NOWAIT ] [...] ]\n"
3014
" [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
3015
" ( %s ) [ AS ] %s [ ( %s [, ...] ) ]\n"
3016
" %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
3017
" %s ( [ %s [, ...] ] ) [ AS ] %s [ ( %s [, ...] | %s [, ...] ) ]\n"
3018
" %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n"
3019
" %s [ NATURAL ] %s %s [ ON %s | USING ( %s [, ...] ) ]\n"
3023
" %s [ ( %s [, ...] ) ] AS ( %s | %s | %s | %s )\n"
3025
"TABLE [ ONLY ] %s [ * ]",
3035
_("window_definition"),
3043
_("where from_item can be one of:"),
3050
_("with_query_name"),
3057
_("column_definition"),
3060
_("column_definition"),
3064
_("join_condition"),
3066
_("and with_query is:"),
3067
_("with_query_name"),
3077
sql_help_TRUNCATE(PQExpBuffer buf)
3079
appendPQExpBuffer(buf,
3080
"TRUNCATE [ TABLE ] [ ONLY ] %s [, ... ]\n"
3081
" [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]",
3086
sql_help_UNLISTEN(PQExpBuffer buf)
3088
appendPQExpBuffer(buf,
3089
"UNLISTEN { %s | * }",
3094
sql_help_UPDATE(PQExpBuffer buf)
3096
appendPQExpBuffer(buf,
3097
"[ WITH [ RECURSIVE ] %s [, ...] ]\n"
3098
"UPDATE [ ONLY ] %s [ [ AS ] %s ]\n"
3099
" SET { %s = { %s | DEFAULT } |\n"
3100
" ( %s [, ...] ) = ( { %s | DEFAULT } [, ...] ) } [, ...]\n"
3102
" [ WHERE %s | WHERE CURRENT OF %s ]\n"
3103
" [ RETURNING * | %s [ [ AS ] %s ] [, ...] ]",
3114
_("output_expression"),
3119
sql_help_VACUUM(PQExpBuffer buf)
3121
appendPQExpBuffer(buf,
3122
"VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ %s [ (%s [, ...] ) ] ]\n"
3123
"VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ %s ]\n"
3124
"VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ %s [ (%s [, ...] ) ] ]",
3133
sql_help_VALUES(PQExpBuffer buf)
3135
appendPQExpBuffer(buf,
3136
"VALUES ( %s [, ...] ) [, ...]\n"
3137
" [ ORDER BY %s [ ASC | DESC | USING %s ] [, ...] ]\n"
3138
" [ LIMIT { %s | ALL } ]\n"
3139
" [ OFFSET %s [ ROW | ROWS ] ]\n"
3140
" [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]",
3142
_("sort_expression"),
3150
sql_help_WITH(PQExpBuffer buf)
3152
appendPQExpBuffer(buf,
3153
"[ WITH [ RECURSIVE ] %s [, ...] ]\n"
3154
"SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n"
3155
" * | %s [ [ AS ] %s ] [, ...]\n"
3156
" [ FROM %s [, ...] ]\n"
3158
" [ GROUP BY %s [, ...] ]\n"
3159
" [ HAVING %s [, ...] ]\n"
3160
" [ WINDOW %s AS ( %s ) [, ...] ]\n"
3161
" [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n"
3162
" [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n"
3163
" [ LIMIT { %s | ALL } ]\n"
3164
" [ OFFSET %s [ ROW | ROWS ] ]\n"
3165
" [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]\n"
3166
" [ FOR { UPDATE | SHARE } [ OF %s [, ...] ] [ NOWAIT ] [...] ]\n"
3170
" [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
3171
" ( %s ) [ AS ] %s [ ( %s [, ...] ) ]\n"
3172
" %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
3173
" %s ( [ %s [, ...] ] ) [ AS ] %s [ ( %s [, ...] | %s [, ...] ) ]\n"
3174
" %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n"
3175
" %s [ NATURAL ] %s %s [ ON %s | USING ( %s [, ...] ) ]\n"
3179
" %s [ ( %s [, ...] ) ] AS ( %s | %s | %s | %s )\n"
3181
"TABLE [ ONLY ] %s [ * ]",
3191
_("window_definition"),
3199
_("where from_item can be one of:"),
3206
_("with_query_name"),
3213
_("column_definition"),
3216
_("column_definition"),
3220
_("join_condition"),
3222
_("and with_query is:"),
3223
_("with_query_name"),
added
removed
src/bin/psql/sql_help.c
