Line data Source code
1 : /*
2 : * *** Do not change this file by hand. It is automatically
3 : * *** generated from the DocBook documentation.
4 : *
5 : * generated by src/bin/psql/create_help.pl
6 : *
7 : */
8 :
9 : #define N_(x) (x) /* gettext noop */
10 :
11 : #include "postgres_fe.h"
12 : #include "sql_help.h"
13 :
14 : static void
15 0 : sql_help_ABORT(PQExpBuffer buf)
16 : {
17 0 : appendPQExpBuffer(buf,
18 : "ABORT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]");
19 0 : }
20 :
21 : static void
22 0 : sql_help_ALTER_AGGREGATE(PQExpBuffer buf)
23 : {
24 0 : appendPQExpBuffer(buf,
25 : "ALTER AGGREGATE %s ( %s ) RENAME TO %s\n"
26 : "ALTER AGGREGATE %s ( %s )\n"
27 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
28 : "ALTER AGGREGATE %s ( %s ) SET SCHEMA %s\n"
29 : "\n"
30 : "%s\n"
31 : "\n"
32 : "* |\n"
33 : "[ %s ] [ %s ] %s [ , ... ] |\n"
34 : "[ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ]",
35 : _("name"),
36 : _("aggregate_signature"),
37 : _("new_name"),
38 : _("name"),
39 : _("aggregate_signature"),
40 : _("new_owner"),
41 : _("name"),
42 : _("aggregate_signature"),
43 : _("new_schema"),
44 : _("where aggregate_signature is:"),
45 : _("argmode"),
46 : _("argname"),
47 : _("argtype"),
48 : _("argmode"),
49 : _("argname"),
50 : _("argtype"),
51 : _("argmode"),
52 : _("argname"),
53 : _("argtype"));
54 0 : }
55 :
56 : static void
57 0 : sql_help_ALTER_COLLATION(PQExpBuffer buf)
58 : {
59 0 : appendPQExpBuffer(buf,
60 : "ALTER COLLATION %s REFRESH VERSION\n"
61 : "\n"
62 : "ALTER COLLATION %s RENAME TO %s\n"
63 : "ALTER COLLATION %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
64 : "ALTER COLLATION %s SET SCHEMA %s",
65 : _("name"),
66 : _("name"),
67 : _("new_name"),
68 : _("name"),
69 : _("new_owner"),
70 : _("name"),
71 : _("new_schema"));
72 0 : }
73 :
74 : static void
75 0 : sql_help_ALTER_CONVERSION(PQExpBuffer buf)
76 : {
77 0 : appendPQExpBuffer(buf,
78 : "ALTER CONVERSION %s RENAME TO %s\n"
79 : "ALTER CONVERSION %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
80 : "ALTER CONVERSION %s SET SCHEMA %s",
81 : _("name"),
82 : _("new_name"),
83 : _("name"),
84 : _("new_owner"),
85 : _("name"),
86 : _("new_schema"));
87 0 : }
88 :
89 : static void
90 0 : sql_help_ALTER_DATABASE(PQExpBuffer buf)
91 : {
92 0 : appendPQExpBuffer(buf,
93 : "ALTER DATABASE %s [ [ WITH ] %s [ ... ] ]\n"
94 : "\n"
95 : "%s\n"
96 : "\n"
97 : " ALLOW_CONNECTIONS %s\n"
98 : " CONNECTION LIMIT %s\n"
99 : " IS_TEMPLATE %s\n"
100 : "\n"
101 : "ALTER DATABASE %s RENAME TO %s\n"
102 : "\n"
103 : "ALTER DATABASE %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
104 : "\n"
105 : "ALTER DATABASE %s SET TABLESPACE %s\n"
106 : "\n"
107 : "ALTER DATABASE %s REFRESH COLLATION VERSION\n"
108 : "\n"
109 : "ALTER DATABASE %s SET %s { TO | = } { %s | DEFAULT }\n"
110 : "ALTER DATABASE %s SET %s FROM CURRENT\n"
111 : "ALTER DATABASE %s RESET %s\n"
112 : "ALTER DATABASE %s RESET ALL",
113 : _("name"),
114 : _("option"),
115 : _("where option can be:"),
116 : _("allowconn"),
117 : _("connlimit"),
118 : _("istemplate"),
119 : _("name"),
120 : _("new_name"),
121 : _("name"),
122 : _("new_owner"),
123 : _("name"),
124 : _("new_tablespace"),
125 : _("name"),
126 : _("name"),
127 : _("configuration_parameter"),
128 : _("value"),
129 : _("name"),
130 : _("configuration_parameter"),
131 : _("name"),
132 : _("configuration_parameter"),
133 : _("name"));
134 0 : }
135 :
136 : static void
137 0 : sql_help_ALTER_DEFAULT_PRIVILEGES(PQExpBuffer buf)
138 : {
139 0 : appendPQExpBuffer(buf,
140 : "ALTER DEFAULT PRIVILEGES\n"
141 : " [ FOR { ROLE | USER } %s [, ...] ]\n"
142 : " [ IN SCHEMA %s [, ...] ]\n"
143 : " %s\n"
144 : "\n"
145 : "%s\n"
146 : "\n"
147 : "GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN }\n"
148 : " [, ...] | ALL [ PRIVILEGES ] }\n"
149 : " ON TABLES\n"
150 : " TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
151 : "\n"
152 : "GRANT { { USAGE | SELECT | UPDATE }\n"
153 : " [, ...] | ALL [ PRIVILEGES ] }\n"
154 : " ON SEQUENCES\n"
155 : " TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
156 : "\n"
157 : "GRANT { EXECUTE | ALL [ PRIVILEGES ] }\n"
158 : " ON { FUNCTIONS | ROUTINES }\n"
159 : " TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
160 : "\n"
161 : "GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
162 : " ON TYPES\n"
163 : " TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
164 : "\n"
165 : "GRANT { { USAGE | CREATE }\n"
166 : " [, ...] | ALL [ PRIVILEGES ] }\n"
167 : " ON SCHEMAS\n"
168 : " TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
169 : "\n"
170 : "GRANT { { SELECT | UPDATE }\n"
171 : " [, ...] | ALL [ PRIVILEGES ] }\n"
172 : " ON LARGE OBJECTS\n"
173 : " TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n"
174 : "\n"
175 : "REVOKE [ GRANT OPTION FOR ]\n"
176 : " { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN }\n"
177 : " [, ...] | ALL [ PRIVILEGES ] }\n"
178 : " ON TABLES\n"
179 : " FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
180 : " [ CASCADE | RESTRICT ]\n"
181 : "\n"
182 : "REVOKE [ GRANT OPTION FOR ]\n"
183 : " { { USAGE | SELECT | UPDATE }\n"
184 : " [, ...] | ALL [ PRIVILEGES ] }\n"
185 : " ON SEQUENCES\n"
186 : " FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
187 : " [ CASCADE | RESTRICT ]\n"
188 : "\n"
189 : "REVOKE [ GRANT OPTION FOR ]\n"
190 : " { EXECUTE | ALL [ PRIVILEGES ] }\n"
191 : " ON { FUNCTIONS | ROUTINES }\n"
192 : " FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
193 : " [ CASCADE | RESTRICT ]\n"
194 : "\n"
195 : "REVOKE [ GRANT OPTION FOR ]\n"
196 : " { USAGE | ALL [ PRIVILEGES ] }\n"
197 : " ON TYPES\n"
198 : " FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
199 : " [ CASCADE | RESTRICT ]\n"
200 : "\n"
201 : "REVOKE [ GRANT OPTION FOR ]\n"
202 : " { { USAGE | CREATE }\n"
203 : " [, ...] | ALL [ PRIVILEGES ] }\n"
204 : " ON SCHEMAS\n"
205 : " FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
206 : " [ CASCADE | RESTRICT ]\n"
207 : "\n"
208 : "REVOKE [ GRANT OPTION FOR ]\n"
209 : " { { SELECT | UPDATE }\n"
210 : " [, ...] | ALL [ PRIVILEGES ] }\n"
211 : " ON LARGE OBJECTS\n"
212 : " FROM { [ GROUP ] %s | PUBLIC } [, ...]\n"
213 : " [ CASCADE | RESTRICT ]",
214 : _("target_role"),
215 : _("schema_name"),
216 : _("abbreviated_grant_or_revoke"),
217 : _("where abbreviated_grant_or_revoke is one of:"),
218 : _("role_name"),
219 : _("role_name"),
220 : _("role_name"),
221 : _("role_name"),
222 : _("role_name"),
223 : _("role_name"),
224 : _("role_name"),
225 : _("role_name"),
226 : _("role_name"),
227 : _("role_name"),
228 : _("role_name"),
229 : _("role_name"));
230 0 : }
231 :
232 : static void
233 0 : sql_help_ALTER_DOMAIN(PQExpBuffer buf)
234 : {
235 0 : appendPQExpBuffer(buf,
236 : "ALTER DOMAIN %s\n"
237 : " { SET DEFAULT %s | DROP DEFAULT }\n"
238 : "ALTER DOMAIN %s\n"
239 : " { SET | DROP } NOT NULL\n"
240 : "ALTER DOMAIN %s\n"
241 : " ADD %s [ NOT VALID ]\n"
242 : "ALTER DOMAIN %s\n"
243 : " DROP CONSTRAINT [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n"
244 : "ALTER DOMAIN %s\n"
245 : " RENAME CONSTRAINT %s TO %s\n"
246 : "ALTER DOMAIN %s\n"
247 : " VALIDATE CONSTRAINT %s\n"
248 : "ALTER DOMAIN %s\n"
249 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
250 : "ALTER DOMAIN %s\n"
251 : " RENAME TO %s\n"
252 : "ALTER DOMAIN %s\n"
253 : " SET SCHEMA %s\n"
254 : "\n"
255 : "%s\n"
256 : "\n"
257 : "[ CONSTRAINT %s ]\n"
258 : "{ NOT NULL | CHECK (%s) }",
259 : _("name"),
260 : _("expression"),
261 : _("name"),
262 : _("name"),
263 : _("domain_constraint"),
264 : _("name"),
265 : _("constraint_name"),
266 : _("name"),
267 : _("constraint_name"),
268 : _("new_constraint_name"),
269 : _("name"),
270 : _("constraint_name"),
271 : _("name"),
272 : _("new_owner"),
273 : _("name"),
274 : _("new_name"),
275 : _("name"),
276 : _("new_schema"),
277 : _("where domain_constraint is:"),
278 : _("constraint_name"),
279 : _("expression"));
280 0 : }
281 :
282 : static void
283 0 : sql_help_ALTER_EVENT_TRIGGER(PQExpBuffer buf)
284 : {
285 0 : appendPQExpBuffer(buf,
286 : "ALTER EVENT TRIGGER %s DISABLE\n"
287 : "ALTER EVENT TRIGGER %s ENABLE [ REPLICA | ALWAYS ]\n"
288 : "ALTER EVENT TRIGGER %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
289 : "ALTER EVENT TRIGGER %s RENAME TO %s",
290 : _("name"),
291 : _("name"),
292 : _("name"),
293 : _("new_owner"),
294 : _("name"),
295 : _("new_name"));
296 0 : }
297 :
298 : static void
299 0 : sql_help_ALTER_EXTENSION(PQExpBuffer buf)
300 : {
301 0 : appendPQExpBuffer(buf,
302 : "ALTER EXTENSION %s UPDATE [ TO %s ]\n"
303 : "ALTER EXTENSION %s SET SCHEMA %s\n"
304 : "ALTER EXTENSION %s ADD %s\n"
305 : "ALTER EXTENSION %s DROP %s\n"
306 : "\n"
307 : "%s\n"
308 : "\n"
309 : " ACCESS METHOD %s |\n"
310 : " AGGREGATE %s ( %s ) |\n"
311 : " CAST (%s AS %s) |\n"
312 : " COLLATION %s |\n"
313 : " CONVERSION %s |\n"
314 : " DOMAIN %s |\n"
315 : " EVENT TRIGGER %s |\n"
316 : " FOREIGN DATA WRAPPER %s |\n"
317 : " FOREIGN TABLE %s |\n"
318 : " FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
319 : " MATERIALIZED VIEW %s |\n"
320 : " OPERATOR %s (%s, %s) |\n"
321 : " OPERATOR CLASS %s USING %s |\n"
322 : " OPERATOR FAMILY %s USING %s |\n"
323 : " [ PROCEDURAL ] LANGUAGE %s |\n"
324 : " PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
325 : " ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
326 : " SCHEMA %s |\n"
327 : " SEQUENCE %s |\n"
328 : " SERVER %s |\n"
329 : " TABLE %s |\n"
330 : " TEXT SEARCH CONFIGURATION %s |\n"
331 : " TEXT SEARCH DICTIONARY %s |\n"
332 : " TEXT SEARCH PARSER %s |\n"
333 : " TEXT SEARCH TEMPLATE %s |\n"
334 : " TRANSFORM FOR %s LANGUAGE %s |\n"
335 : " TYPE %s |\n"
336 : " VIEW %s\n"
337 : "\n"
338 : "%s\n"
339 : "\n"
340 : "* |\n"
341 : "[ %s ] [ %s ] %s [ , ... ] |\n"
342 : "[ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ]",
343 : _("name"),
344 : _("new_version"),
345 : _("name"),
346 : _("new_schema"),
347 : _("name"),
348 : _("member_object"),
349 : _("name"),
350 : _("member_object"),
351 : _("where member_object is:"),
352 : _("object_name"),
353 : _("aggregate_name"),
354 : _("aggregate_signature"),
355 : _("source_type"),
356 : _("target_type"),
357 : _("object_name"),
358 : _("object_name"),
359 : _("object_name"),
360 : _("object_name"),
361 : _("object_name"),
362 : _("object_name"),
363 : _("function_name"),
364 : _("argmode"),
365 : _("argname"),
366 : _("argtype"),
367 : _("object_name"),
368 : _("operator_name"),
369 : _("left_type"),
370 : _("right_type"),
371 : _("object_name"),
372 : _("index_method"),
373 : _("object_name"),
374 : _("index_method"),
375 : _("object_name"),
376 : _("procedure_name"),
377 : _("argmode"),
378 : _("argname"),
379 : _("argtype"),
380 : _("routine_name"),
381 : _("argmode"),
382 : _("argname"),
383 : _("argtype"),
384 : _("object_name"),
385 : _("object_name"),
386 : _("object_name"),
387 : _("object_name"),
388 : _("object_name"),
389 : _("object_name"),
390 : _("object_name"),
391 : _("object_name"),
392 : _("type_name"),
393 : _("lang_name"),
394 : _("object_name"),
395 : _("object_name"),
396 : _("and aggregate_signature is:"),
397 : _("argmode"),
398 : _("argname"),
399 : _("argtype"),
400 : _("argmode"),
401 : _("argname"),
402 : _("argtype"),
403 : _("argmode"),
404 : _("argname"),
405 : _("argtype"));
406 0 : }
407 :
408 : static void
409 0 : sql_help_ALTER_FOREIGN_DATA_WRAPPER(PQExpBuffer buf)
410 : {
411 0 : appendPQExpBuffer(buf,
412 : "ALTER FOREIGN DATA WRAPPER %s\n"
413 : " [ HANDLER %s | NO HANDLER ]\n"
414 : " [ VALIDATOR %s | NO VALIDATOR ]\n"
415 : " [ OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ]) ]\n"
416 : "ALTER FOREIGN DATA WRAPPER %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
417 : "ALTER FOREIGN DATA WRAPPER %s RENAME TO %s",
418 : _("name"),
419 : _("handler_function"),
420 : _("validator_function"),
421 : _("option"),
422 : _("value"),
423 : _("name"),
424 : _("new_owner"),
425 : _("name"),
426 : _("new_name"));
427 0 : }
428 :
429 : static void
430 0 : sql_help_ALTER_FOREIGN_TABLE(PQExpBuffer buf)
431 : {
432 0 : appendPQExpBuffer(buf,
433 : "ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] %s [ * ]\n"
434 : " %s [, ... ]\n"
435 : "ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] %s [ * ]\n"
436 : " RENAME [ COLUMN ] %s TO %s\n"
437 : "ALTER FOREIGN TABLE [ IF EXISTS ] %s\n"
438 : " RENAME TO %s\n"
439 : "ALTER FOREIGN TABLE [ IF EXISTS ] %s\n"
440 : " SET SCHEMA %s\n"
441 : "\n"
442 : "%s\n"
443 : "\n"
444 : " ADD [ COLUMN ] %s %s [ COLLATE %s ] [ %s [ ... ] ]\n"
445 : " DROP [ COLUMN ] [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n"
446 : " ALTER [ COLUMN ] %s [ SET DATA ] TYPE %s [ COLLATE %s ]\n"
447 : " ALTER [ COLUMN ] %s SET DEFAULT %s\n"
448 : " ALTER [ COLUMN ] %s DROP DEFAULT\n"
449 : " ALTER [ COLUMN ] %s { SET | DROP } NOT NULL\n"
450 : " ALTER [ COLUMN ] %s SET STATISTICS %s\n"
451 : " ALTER [ COLUMN ] %s SET ( %s = %s [, ... ] )\n"
452 : " ALTER [ COLUMN ] %s RESET ( %s [, ... ] )\n"
453 : " ALTER [ COLUMN ] %s SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\n"
454 : " ALTER [ COLUMN ] %s OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ])\n"
455 : " ADD %s [ NOT VALID ]\n"
456 : " VALIDATE CONSTRAINT %s\n"
457 : " DROP CONSTRAINT [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n"
458 : " DISABLE TRIGGER [ %s | ALL | USER ]\n"
459 : " ENABLE TRIGGER [ %s | ALL | USER ]\n"
460 : " ENABLE REPLICA TRIGGER %s\n"
461 : " ENABLE ALWAYS TRIGGER %s\n"
462 : " SET WITHOUT OIDS\n"
463 : " INHERIT %s\n"
464 : " NO INHERIT %s\n"
465 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
466 : " OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ])",
467 : _("name"),
468 : _("action"),
469 : _("name"),
470 : _("column_name"),
471 : _("new_column_name"),
472 : _("name"),
473 : _("new_name"),
474 : _("name"),
475 : _("new_schema"),
476 : _("where action is one of:"),
477 : _("column_name"),
478 : _("data_type"),
479 : _("collation"),
480 : _("column_constraint"),
481 : _("column_name"),
482 : _("column_name"),
483 : _("data_type"),
484 : _("collation"),
485 : _("column_name"),
486 : _("expression"),
487 : _("column_name"),
488 : _("column_name"),
489 : _("column_name"),
490 : _("integer"),
491 : _("column_name"),
492 : _("attribute_option"),
493 : _("value"),
494 : _("column_name"),
495 : _("attribute_option"),
496 : _("column_name"),
497 : _("column_name"),
498 : _("option"),
499 : _("value"),
500 : _("table_constraint"),
501 : _("constraint_name"),
502 : _("constraint_name"),
503 : _("trigger_name"),
504 : _("trigger_name"),
505 : _("trigger_name"),
506 : _("trigger_name"),
507 : _("parent_table"),
508 : _("parent_table"),
509 : _("new_owner"),
510 : _("option"),
511 : _("value"));
512 0 : }
513 :
514 : static void
515 0 : sql_help_ALTER_FUNCTION(PQExpBuffer buf)
516 : {
517 0 : appendPQExpBuffer(buf,
518 : "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
519 : " %s [ ... ] [ RESTRICT ]\n"
520 : "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
521 : " RENAME TO %s\n"
522 : "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
523 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
524 : "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
525 : " SET SCHEMA %s\n"
526 : "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
527 : " [ NO ] DEPENDS ON EXTENSION %s\n"
528 : "\n"
529 : "%s\n"
530 : "\n"
531 : " CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT\n"
532 : " IMMUTABLE | STABLE | VOLATILE\n"
533 : " [ NOT ] LEAKPROOF\n"
534 : " [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n"
535 : " PARALLEL { UNSAFE | RESTRICTED | SAFE }\n"
536 : " COST %s\n"
537 : " ROWS %s\n"
538 : " SUPPORT %s\n"
539 : " SET %s { TO | = } { %s | DEFAULT }\n"
540 : " SET %s FROM CURRENT\n"
541 : " RESET %s\n"
542 : " RESET ALL",
543 : _("name"),
544 : _("argmode"),
545 : _("argname"),
546 : _("argtype"),
547 : _("action"),
548 : _("name"),
549 : _("argmode"),
550 : _("argname"),
551 : _("argtype"),
552 : _("new_name"),
553 : _("name"),
554 : _("argmode"),
555 : _("argname"),
556 : _("argtype"),
557 : _("new_owner"),
558 : _("name"),
559 : _("argmode"),
560 : _("argname"),
561 : _("argtype"),
562 : _("new_schema"),
563 : _("name"),
564 : _("argmode"),
565 : _("argname"),
566 : _("argtype"),
567 : _("extension_name"),
568 : _("where action is one of:"),
569 : _("execution_cost"),
570 : _("result_rows"),
571 : _("support_function"),
572 : _("configuration_parameter"),
573 : _("value"),
574 : _("configuration_parameter"),
575 : _("configuration_parameter"));
576 0 : }
577 :
578 : static void
579 0 : sql_help_ALTER_GROUP(PQExpBuffer buf)
580 : {
581 0 : appendPQExpBuffer(buf,
582 : "ALTER GROUP %s ADD USER %s [, ... ]\n"
583 : "ALTER GROUP %s DROP USER %s [, ... ]\n"
584 : "\n"
585 : "%s\n"
586 : "\n"
587 : " %s\n"
588 : " | CURRENT_ROLE\n"
589 : " | CURRENT_USER\n"
590 : " | SESSION_USER\n"
591 : "\n"
592 : "ALTER GROUP %s RENAME TO %s",
593 : _("role_specification"),
594 : _("user_name"),
595 : _("role_specification"),
596 : _("user_name"),
597 : _("where role_specification can be:"),
598 : _("role_name"),
599 : _("group_name"),
600 : _("new_name"));
601 0 : }
602 :
603 : static void
604 0 : sql_help_ALTER_INDEX(PQExpBuffer buf)
605 : {
606 0 : appendPQExpBuffer(buf,
607 : "ALTER INDEX [ IF EXISTS ] %s RENAME TO %s\n"
608 : "ALTER INDEX [ IF EXISTS ] %s SET TABLESPACE %s\n"
609 : "ALTER INDEX %s ATTACH PARTITION %s\n"
610 : "ALTER INDEX %s [ NO ] DEPENDS ON EXTENSION %s\n"
611 : "ALTER INDEX [ IF EXISTS ] %s SET ( %s [= %s] [, ... ] )\n"
612 : "ALTER INDEX [ IF EXISTS ] %s RESET ( %s [, ... ] )\n"
613 : "ALTER INDEX [ IF EXISTS ] %s ALTER [ COLUMN ] %s\n"
614 : " SET STATISTICS %s\n"
615 : "ALTER INDEX ALL IN TABLESPACE %s [ OWNED BY %s [, ... ] ]\n"
616 : " SET TABLESPACE %s [ NOWAIT ]",
617 : _("name"),
618 : _("new_name"),
619 : _("name"),
620 : _("tablespace_name"),
621 : _("name"),
622 : _("index_name"),
623 : _("name"),
624 : _("extension_name"),
625 : _("name"),
626 : _("storage_parameter"),
627 : _("value"),
628 : _("name"),
629 : _("storage_parameter"),
630 : _("name"),
631 : _("column_number"),
632 : _("integer"),
633 : _("name"),
634 : _("role_name"),
635 : _("new_tablespace"));
636 0 : }
637 :
638 : static void
639 0 : sql_help_ALTER_LANGUAGE(PQExpBuffer buf)
640 : {
641 0 : appendPQExpBuffer(buf,
642 : "ALTER [ PROCEDURAL ] LANGUAGE %s RENAME TO %s\n"
643 : "ALTER [ PROCEDURAL ] LANGUAGE %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }",
644 : _("name"),
645 : _("new_name"),
646 : _("name"),
647 : _("new_owner"));
648 0 : }
649 :
650 : static void
651 0 : sql_help_ALTER_LARGE_OBJECT(PQExpBuffer buf)
652 : {
653 0 : appendPQExpBuffer(buf,
654 : "ALTER LARGE OBJECT %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }",
655 : _("large_object_oid"),
656 : _("new_owner"));
657 0 : }
658 :
659 : static void
660 0 : sql_help_ALTER_MATERIALIZED_VIEW(PQExpBuffer buf)
661 : {
662 0 : appendPQExpBuffer(buf,
663 : "ALTER MATERIALIZED VIEW [ IF EXISTS ] %s\n"
664 : " %s [, ... ]\n"
665 : "ALTER MATERIALIZED VIEW %s\n"
666 : " [ NO ] DEPENDS ON EXTENSION %s\n"
667 : "ALTER MATERIALIZED VIEW [ IF EXISTS ] %s\n"
668 : " RENAME [ COLUMN ] %s TO %s\n"
669 : "ALTER MATERIALIZED VIEW [ IF EXISTS ] %s\n"
670 : " RENAME TO %s\n"
671 : "ALTER MATERIALIZED VIEW [ IF EXISTS ] %s\n"
672 : " SET SCHEMA %s\n"
673 : "ALTER MATERIALIZED VIEW ALL IN TABLESPACE %s [ OWNED BY %s [, ... ] ]\n"
674 : " SET TABLESPACE %s [ NOWAIT ]\n"
675 : "\n"
676 : "%s\n"
677 : "\n"
678 : " ALTER [ COLUMN ] %s SET STATISTICS %s\n"
679 : " ALTER [ COLUMN ] %s SET ( %s = %s [, ... ] )\n"
680 : " ALTER [ COLUMN ] %s RESET ( %s [, ... ] )\n"
681 : " ALTER [ COLUMN ] %s SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\n"
682 : " ALTER [ COLUMN ] %s SET COMPRESSION %s\n"
683 : " CLUSTER ON %s\n"
684 : " SET WITHOUT CLUSTER\n"
685 : " SET ACCESS METHOD %s\n"
686 : " SET TABLESPACE %s\n"
687 : " SET ( %s [= %s] [, ... ] )\n"
688 : " RESET ( %s [, ... ] )\n"
689 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }",
690 : _("name"),
691 : _("action"),
692 : _("name"),
693 : _("extension_name"),
694 : _("name"),
695 : _("column_name"),
696 : _("new_column_name"),
697 : _("name"),
698 : _("new_name"),
699 : _("name"),
700 : _("new_schema"),
701 : _("name"),
702 : _("role_name"),
703 : _("new_tablespace"),
704 : _("where action is one of:"),
705 : _("column_name"),
706 : _("integer"),
707 : _("column_name"),
708 : _("attribute_option"),
709 : _("value"),
710 : _("column_name"),
711 : _("attribute_option"),
712 : _("column_name"),
713 : _("column_name"),
714 : _("compression_method"),
715 : _("index_name"),
716 : _("new_access_method"),
717 : _("new_tablespace"),
718 : _("storage_parameter"),
719 : _("value"),
720 : _("storage_parameter"),
721 : _("new_owner"));
722 0 : }
723 :
724 : static void
725 0 : sql_help_ALTER_OPERATOR(PQExpBuffer buf)
726 : {
727 0 : appendPQExpBuffer(buf,
728 : "ALTER OPERATOR %s ( { %s | NONE } , %s )\n"
729 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
730 : "\n"
731 : "ALTER OPERATOR %s ( { %s | NONE } , %s )\n"
732 : " SET SCHEMA %s\n"
733 : "\n"
734 : "ALTER OPERATOR %s ( { %s | NONE } , %s )\n"
735 : " SET ( { RESTRICT = { %s | NONE }\n"
736 : " | JOIN = { %s | NONE }\n"
737 : " | COMMUTATOR = %s\n"
738 : " | NEGATOR = %s\n"
739 : " | HASHES\n"
740 : " | MERGES\n"
741 : " } [, ... ] )",
742 : _("name"),
743 : _("left_type"),
744 : _("right_type"),
745 : _("new_owner"),
746 : _("name"),
747 : _("left_type"),
748 : _("right_type"),
749 : _("new_schema"),
750 : _("name"),
751 : _("left_type"),
752 : _("right_type"),
753 : _("res_proc"),
754 : _("join_proc"),
755 : _("com_op"),
756 : _("neg_op"));
757 0 : }
758 :
759 : static void
760 0 : sql_help_ALTER_OPERATOR_CLASS(PQExpBuffer buf)
761 : {
762 0 : appendPQExpBuffer(buf,
763 : "ALTER OPERATOR CLASS %s USING %s\n"
764 : " RENAME TO %s\n"
765 : "\n"
766 : "ALTER OPERATOR CLASS %s USING %s\n"
767 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
768 : "\n"
769 : "ALTER OPERATOR CLASS %s USING %s\n"
770 : " SET SCHEMA %s",
771 : _("name"),
772 : _("index_method"),
773 : _("new_name"),
774 : _("name"),
775 : _("index_method"),
776 : _("new_owner"),
777 : _("name"),
778 : _("index_method"),
779 : _("new_schema"));
780 0 : }
781 :
782 : static void
783 0 : sql_help_ALTER_OPERATOR_FAMILY(PQExpBuffer buf)
784 : {
785 0 : appendPQExpBuffer(buf,
786 : "ALTER OPERATOR FAMILY %s USING %s ADD\n"
787 : " { OPERATOR %s %s ( %s, %s )\n"
788 : " [ FOR SEARCH | FOR ORDER BY %s ]\n"
789 : " | FUNCTION %s [ ( %s [ , %s ] ) ]\n"
790 : " %s [ ( %s [, ...] ) ]\n"
791 : " } [, ... ]\n"
792 : "\n"
793 : "ALTER OPERATOR FAMILY %s USING %s DROP\n"
794 : " { OPERATOR %s ( %s [ , %s ] )\n"
795 : " | FUNCTION %s ( %s [ , %s ] )\n"
796 : " } [, ... ]\n"
797 : "\n"
798 : "ALTER OPERATOR FAMILY %s USING %s\n"
799 : " RENAME TO %s\n"
800 : "\n"
801 : "ALTER OPERATOR FAMILY %s USING %s\n"
802 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
803 : "\n"
804 : "ALTER OPERATOR FAMILY %s USING %s\n"
805 : " SET SCHEMA %s",
806 : _("name"),
807 : _("index_method"),
808 : _("strategy_number"),
809 : _("operator_name"),
810 : _("op_type"),
811 : _("op_type"),
812 : _("sort_family_name"),
813 : _("support_number"),
814 : _("op_type"),
815 : _("op_type"),
816 : _("function_name"),
817 : _("argument_type"),
818 : _("name"),
819 : _("index_method"),
820 : _("strategy_number"),
821 : _("op_type"),
822 : _("op_type"),
823 : _("support_number"),
824 : _("op_type"),
825 : _("op_type"),
826 : _("name"),
827 : _("index_method"),
828 : _("new_name"),
829 : _("name"),
830 : _("index_method"),
831 : _("new_owner"),
832 : _("name"),
833 : _("index_method"),
834 : _("new_schema"));
835 0 : }
836 :
837 : static void
838 0 : sql_help_ALTER_POLICY(PQExpBuffer buf)
839 : {
840 0 : appendPQExpBuffer(buf,
841 : "ALTER POLICY %s ON %s RENAME TO %s\n"
842 : "\n"
843 : "ALTER POLICY %s ON %s\n"
844 : " [ TO { %s | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] ]\n"
845 : " [ USING ( %s ) ]\n"
846 : " [ WITH CHECK ( %s ) ]",
847 : _("name"),
848 : _("table_name"),
849 : _("new_name"),
850 : _("name"),
851 : _("table_name"),
852 : _("role_name"),
853 : _("using_expression"),
854 : _("check_expression"));
855 0 : }
856 :
857 : static void
858 0 : sql_help_ALTER_PROCEDURE(PQExpBuffer buf)
859 : {
860 0 : appendPQExpBuffer(buf,
861 : "ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
862 : " %s [ ... ] [ RESTRICT ]\n"
863 : "ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
864 : " RENAME TO %s\n"
865 : "ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
866 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
867 : "ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
868 : " SET SCHEMA %s\n"
869 : "ALTER PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
870 : " [ NO ] DEPENDS ON EXTENSION %s\n"
871 : "\n"
872 : "%s\n"
873 : "\n"
874 : " [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n"
875 : " SET %s { TO | = } { %s | DEFAULT }\n"
876 : " SET %s FROM CURRENT\n"
877 : " RESET %s\n"
878 : " RESET ALL",
879 : _("name"),
880 : _("argmode"),
881 : _("argname"),
882 : _("argtype"),
883 : _("action"),
884 : _("name"),
885 : _("argmode"),
886 : _("argname"),
887 : _("argtype"),
888 : _("new_name"),
889 : _("name"),
890 : _("argmode"),
891 : _("argname"),
892 : _("argtype"),
893 : _("new_owner"),
894 : _("name"),
895 : _("argmode"),
896 : _("argname"),
897 : _("argtype"),
898 : _("new_schema"),
899 : _("name"),
900 : _("argmode"),
901 : _("argname"),
902 : _("argtype"),
903 : _("extension_name"),
904 : _("where action is one of:"),
905 : _("configuration_parameter"),
906 : _("value"),
907 : _("configuration_parameter"),
908 : _("configuration_parameter"));
909 0 : }
910 :
911 : static void
912 0 : sql_help_ALTER_PUBLICATION(PQExpBuffer buf)
913 : {
914 0 : appendPQExpBuffer(buf,
915 : "ALTER PUBLICATION %s ADD %s [, ...]\n"
916 : "ALTER PUBLICATION %s SET %s [, ...]\n"
917 : "ALTER PUBLICATION %s DROP %s [, ...]\n"
918 : "ALTER PUBLICATION %s SET ( %s [= %s] [, ... ] )\n"
919 : "ALTER PUBLICATION %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
920 : "ALTER PUBLICATION %s RENAME TO %s\n"
921 : "\n"
922 : "%s\n"
923 : "\n"
924 : " TABLE %s [, ... ]\n"
925 : " TABLES IN SCHEMA { %s | CURRENT_SCHEMA } [, ... ]\n"
926 : "\n"
927 : "%s\n"
928 : "\n"
929 : " TABLE [ ONLY ] %s [ * ] [, ... ]\n"
930 : " TABLES IN SCHEMA { %s | CURRENT_SCHEMA } [, ... ]\n"
931 : "\n"
932 : "%s\n"
933 : "\n"
934 : " [ ONLY ] %s [ * ] [ ( %s [, ... ] ) ] [ WHERE ( %s ) ]",
935 : _("name"),
936 : _("publication_object"),
937 : _("name"),
938 : _("publication_object"),
939 : _("name"),
940 : _("publication_drop_object"),
941 : _("name"),
942 : _("publication_parameter"),
943 : _("value"),
944 : _("name"),
945 : _("new_owner"),
946 : _("name"),
947 : _("new_name"),
948 : _("where publication_object is one of:"),
949 : _("table_and_columns"),
950 : _("schema_name"),
951 : _("and publication_drop_object is one of:"),
952 : _("table_name"),
953 : _("schema_name"),
954 : _("and table_and_columns is:"),
955 : _("table_name"),
956 : _("column_name"),
957 : _("expression"));
958 0 : }
959 :
960 : static void
961 0 : sql_help_ALTER_ROLE(PQExpBuffer buf)
962 : {
963 0 : appendPQExpBuffer(buf,
964 : "ALTER ROLE %s [ WITH ] %s [ ... ]\n"
965 : "\n"
966 : "%s\n"
967 : "\n"
968 : " SUPERUSER | NOSUPERUSER\n"
969 : " | CREATEDB | NOCREATEDB\n"
970 : " | CREATEROLE | NOCREATEROLE\n"
971 : " | INHERIT | NOINHERIT\n"
972 : " | LOGIN | NOLOGIN\n"
973 : " | REPLICATION | NOREPLICATION\n"
974 : " | BYPASSRLS | NOBYPASSRLS\n"
975 : " | CONNECTION LIMIT %s\n"
976 : " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n"
977 : " | VALID UNTIL '%s'\n"
978 : "\n"
979 : "ALTER ROLE %s RENAME TO %s\n"
980 : "\n"
981 : "ALTER ROLE { %s | ALL } [ IN DATABASE %s ] SET %s { TO | = } { %s | DEFAULT }\n"
982 : "ALTER ROLE { %s | ALL } [ IN DATABASE %s ] SET %s FROM CURRENT\n"
983 : "ALTER ROLE { %s | ALL } [ IN DATABASE %s ] RESET %s\n"
984 : "ALTER ROLE { %s | ALL } [ IN DATABASE %s ] RESET ALL\n"
985 : "\n"
986 : "%s\n"
987 : "\n"
988 : " %s\n"
989 : " | CURRENT_ROLE\n"
990 : " | CURRENT_USER\n"
991 : " | SESSION_USER",
992 : _("role_specification"),
993 : _("option"),
994 : _("where option can be:"),
995 : _("connlimit"),
996 : _("password"),
997 : _("timestamp"),
998 : _("name"),
999 : _("new_name"),
1000 : _("role_specification"),
1001 : _("database_name"),
1002 : _("configuration_parameter"),
1003 : _("value"),
1004 : _("role_specification"),
1005 : _("database_name"),
1006 : _("configuration_parameter"),
1007 : _("role_specification"),
1008 : _("database_name"),
1009 : _("configuration_parameter"),
1010 : _("role_specification"),
1011 : _("database_name"),
1012 : _("where role_specification can be:"),
1013 : _("role_name"));
1014 0 : }
1015 :
1016 : static void
1017 0 : sql_help_ALTER_ROUTINE(PQExpBuffer buf)
1018 : {
1019 0 : appendPQExpBuffer(buf,
1020 : "ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
1021 : " %s [ ... ] [ RESTRICT ]\n"
1022 : "ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
1023 : " RENAME TO %s\n"
1024 : "ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
1025 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1026 : "ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
1027 : " SET SCHEMA %s\n"
1028 : "ALTER ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n"
1029 : " [ NO ] DEPENDS ON EXTENSION %s\n"
1030 : "\n"
1031 : "%s\n"
1032 : "\n"
1033 : " IMMUTABLE | STABLE | VOLATILE\n"
1034 : " [ NOT ] LEAKPROOF\n"
1035 : " [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n"
1036 : " PARALLEL { UNSAFE | RESTRICTED | SAFE }\n"
1037 : " COST %s\n"
1038 : " ROWS %s\n"
1039 : " SET %s { TO | = } { %s | DEFAULT }\n"
1040 : " SET %s FROM CURRENT\n"
1041 : " RESET %s\n"
1042 : " RESET ALL",
1043 : _("name"),
1044 : _("argmode"),
1045 : _("argname"),
1046 : _("argtype"),
1047 : _("action"),
1048 : _("name"),
1049 : _("argmode"),
1050 : _("argname"),
1051 : _("argtype"),
1052 : _("new_name"),
1053 : _("name"),
1054 : _("argmode"),
1055 : _("argname"),
1056 : _("argtype"),
1057 : _("new_owner"),
1058 : _("name"),
1059 : _("argmode"),
1060 : _("argname"),
1061 : _("argtype"),
1062 : _("new_schema"),
1063 : _("name"),
1064 : _("argmode"),
1065 : _("argname"),
1066 : _("argtype"),
1067 : _("extension_name"),
1068 : _("where action is one of:"),
1069 : _("execution_cost"),
1070 : _("result_rows"),
1071 : _("configuration_parameter"),
1072 : _("value"),
1073 : _("configuration_parameter"),
1074 : _("configuration_parameter"));
1075 0 : }
1076 :
1077 : static void
1078 0 : sql_help_ALTER_RULE(PQExpBuffer buf)
1079 : {
1080 0 : appendPQExpBuffer(buf,
1081 : "ALTER RULE %s ON %s RENAME TO %s",
1082 : _("name"),
1083 : _("table_name"),
1084 : _("new_name"));
1085 0 : }
1086 :
1087 : static void
1088 0 : sql_help_ALTER_SCHEMA(PQExpBuffer buf)
1089 : {
1090 0 : appendPQExpBuffer(buf,
1091 : "ALTER SCHEMA %s RENAME TO %s\n"
1092 : "ALTER SCHEMA %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }",
1093 : _("name"),
1094 : _("new_name"),
1095 : _("name"),
1096 : _("new_owner"));
1097 0 : }
1098 :
1099 : static void
1100 0 : sql_help_ALTER_SEQUENCE(PQExpBuffer buf)
1101 : {
1102 0 : appendPQExpBuffer(buf,
1103 : "ALTER SEQUENCE [ IF EXISTS ] %s\n"
1104 : " [ AS %s ]\n"
1105 : " [ INCREMENT [ BY ] %s ]\n"
1106 : " [ MINVALUE %s | NO MINVALUE ] [ MAXVALUE %s | NO MAXVALUE ]\n"
1107 : " [ [ NO ] CYCLE ]\n"
1108 : " [ START [ WITH ] %s ]\n"
1109 : " [ RESTART [ [ WITH ] %s ] ]\n"
1110 : " [ CACHE %s ]\n"
1111 : " [ OWNED BY { %s.%s | NONE } ]\n"
1112 : "ALTER SEQUENCE [ IF EXISTS ] %s SET { LOGGED | UNLOGGED }\n"
1113 : "ALTER SEQUENCE [ IF EXISTS ] %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1114 : "ALTER SEQUENCE [ IF EXISTS ] %s RENAME TO %s\n"
1115 : "ALTER SEQUENCE [ IF EXISTS ] %s SET SCHEMA %s",
1116 : _("name"),
1117 : _("data_type"),
1118 : _("increment"),
1119 : _("minvalue"),
1120 : _("maxvalue"),
1121 : _("start"),
1122 : _("restart"),
1123 : _("cache"),
1124 : _("table_name"),
1125 : _("column_name"),
1126 : _("name"),
1127 : _("name"),
1128 : _("new_owner"),
1129 : _("name"),
1130 : _("new_name"),
1131 : _("name"),
1132 : _("new_schema"));
1133 0 : }
1134 :
1135 : static void
1136 0 : sql_help_ALTER_SERVER(PQExpBuffer buf)
1137 : {
1138 0 : appendPQExpBuffer(buf,
1139 : "ALTER SERVER %s [ VERSION '%s' ]\n"
1140 : " [ OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ] ) ]\n"
1141 : "ALTER SERVER %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1142 : "ALTER SERVER %s RENAME TO %s",
1143 : _("name"),
1144 : _("new_version"),
1145 : _("option"),
1146 : _("value"),
1147 : _("name"),
1148 : _("new_owner"),
1149 : _("name"),
1150 : _("new_name"));
1151 0 : }
1152 :
1153 : static void
1154 0 : sql_help_ALTER_STATISTICS(PQExpBuffer buf)
1155 : {
1156 0 : appendPQExpBuffer(buf,
1157 : "ALTER STATISTICS %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1158 : "ALTER STATISTICS %s RENAME TO %s\n"
1159 : "ALTER STATISTICS %s SET SCHEMA %s\n"
1160 : "ALTER STATISTICS %s SET STATISTICS { %s | DEFAULT }",
1161 : _("name"),
1162 : _("new_owner"),
1163 : _("name"),
1164 : _("new_name"),
1165 : _("name"),
1166 : _("new_schema"),
1167 : _("name"),
1168 : _("new_target"));
1169 0 : }
1170 :
1171 : static void
1172 0 : sql_help_ALTER_SUBSCRIPTION(PQExpBuffer buf)
1173 : {
1174 0 : appendPQExpBuffer(buf,
1175 : "ALTER SUBSCRIPTION %s CONNECTION '%s'\n"
1176 : "ALTER SUBSCRIPTION %s SET PUBLICATION %s [, ...] [ WITH ( %s [= %s] [, ... ] ) ]\n"
1177 : "ALTER SUBSCRIPTION %s ADD PUBLICATION %s [, ...] [ WITH ( %s [= %s] [, ... ] ) ]\n"
1178 : "ALTER SUBSCRIPTION %s DROP PUBLICATION %s [, ...] [ WITH ( %s [= %s] [, ... ] ) ]\n"
1179 : "ALTER SUBSCRIPTION %s REFRESH PUBLICATION [ WITH ( %s [= %s] [, ... ] ) ]\n"
1180 : "ALTER SUBSCRIPTION %s REFRESH SEQUENCES\n"
1181 : "ALTER SUBSCRIPTION %s ENABLE\n"
1182 : "ALTER SUBSCRIPTION %s DISABLE\n"
1183 : "ALTER SUBSCRIPTION %s SET ( %s [= %s] [, ... ] )\n"
1184 : "ALTER SUBSCRIPTION %s SKIP ( %s = %s )\n"
1185 : "ALTER SUBSCRIPTION %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1186 : "ALTER SUBSCRIPTION %s RENAME TO %s",
1187 : _("name"),
1188 : _("conninfo"),
1189 : _("name"),
1190 : _("publication_name"),
1191 : _("publication_option"),
1192 : _("value"),
1193 : _("name"),
1194 : _("publication_name"),
1195 : _("publication_option"),
1196 : _("value"),
1197 : _("name"),
1198 : _("publication_name"),
1199 : _("publication_option"),
1200 : _("value"),
1201 : _("name"),
1202 : _("refresh_option"),
1203 : _("value"),
1204 : _("name"),
1205 : _("name"),
1206 : _("name"),
1207 : _("name"),
1208 : _("subscription_parameter"),
1209 : _("value"),
1210 : _("name"),
1211 : _("skip_option"),
1212 : _("value"),
1213 : _("name"),
1214 : _("new_owner"),
1215 : _("name"),
1216 : _("new_name"));
1217 0 : }
1218 :
1219 : static void
1220 0 : sql_help_ALTER_SYSTEM(PQExpBuffer buf)
1221 : {
1222 0 : appendPQExpBuffer(buf,
1223 : "ALTER SYSTEM SET %s { TO | = } { %s [, ...] | DEFAULT }\n"
1224 : "\n"
1225 : "ALTER SYSTEM RESET %s\n"
1226 : "ALTER SYSTEM RESET ALL",
1227 : _("configuration_parameter"),
1228 : _("value"),
1229 : _("configuration_parameter"));
1230 0 : }
1231 :
1232 : static void
1233 0 : sql_help_ALTER_TABLE(PQExpBuffer buf)
1234 : {
1235 0 : appendPQExpBuffer(buf,
1236 : "ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ]\n"
1237 : " %s [, ... ]\n"
1238 : "ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ]\n"
1239 : " RENAME [ COLUMN ] %s TO %s\n"
1240 : "ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ]\n"
1241 : " RENAME CONSTRAINT %s TO %s\n"
1242 : "ALTER TABLE [ IF EXISTS ] %s\n"
1243 : " RENAME TO %s\n"
1244 : "ALTER TABLE [ IF EXISTS ] %s\n"
1245 : " SET SCHEMA %s\n"
1246 : "ALTER TABLE ALL IN TABLESPACE %s [ OWNED BY %s [, ... ] ]\n"
1247 : " SET TABLESPACE %s [ NOWAIT ]\n"
1248 : "ALTER TABLE [ IF EXISTS ] %s\n"
1249 : " ATTACH PARTITION %s { FOR VALUES %s | DEFAULT }\n"
1250 : "ALTER TABLE [ IF EXISTS ] %s\n"
1251 : " DETACH PARTITION %s [ CONCURRENTLY | FINALIZE ]\n"
1252 : "ALTER TABLE [ IF EXISTS ] %s\n"
1253 : " MERGE PARTITIONS (%s, %s [, ...]) INTO %s\n"
1254 : "ALTER TABLE [ IF EXISTS ] %s\n"
1255 : " SPLIT PARTITION %s INTO\n"
1256 : " (PARTITION %s { FOR VALUES %s | DEFAULT },\n"
1257 : " PARTITION %s { FOR VALUES %s | DEFAULT } [, ...])\n"
1258 : "\n"
1259 : "%s\n"
1260 : "\n"
1261 : " ADD [ COLUMN ] [ IF NOT EXISTS ] %s %s [ COLLATE %s ] [ %s [ ... ] ]\n"
1262 : " DROP [ COLUMN ] [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n"
1263 : " ALTER [ COLUMN ] %s [ SET DATA ] TYPE %s [ COLLATE %s ] [ USING %s ]\n"
1264 : " ALTER [ COLUMN ] %s SET DEFAULT %s\n"
1265 : " ALTER [ COLUMN ] %s DROP DEFAULT\n"
1266 : " ALTER [ COLUMN ] %s { SET | DROP } NOT NULL\n"
1267 : " ALTER [ COLUMN ] %s SET EXPRESSION AS ( %s )\n"
1268 : " ALTER [ COLUMN ] %s DROP EXPRESSION [ IF EXISTS ]\n"
1269 : " ALTER [ COLUMN ] %s ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( %s ) ]\n"
1270 : " ALTER [ COLUMN ] %s { SET GENERATED { ALWAYS | BY DEFAULT } | SET %s | RESTART [ [ WITH ] %s ] } [...]\n"
1271 : " ALTER [ COLUMN ] %s DROP IDENTITY [ IF EXISTS ]\n"
1272 : " ALTER [ COLUMN ] %s SET STATISTICS { %s | DEFAULT }\n"
1273 : " ALTER [ COLUMN ] %s SET ( %s = %s [, ... ] )\n"
1274 : " ALTER [ COLUMN ] %s RESET ( %s [, ... ] )\n"
1275 : " ALTER [ COLUMN ] %s SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\n"
1276 : " ALTER [ COLUMN ] %s SET COMPRESSION %s\n"
1277 : " ADD %s [ NOT VALID ]\n"
1278 : " ADD %s\n"
1279 : " ALTER CONSTRAINT %s [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [ ENFORCED | NOT ENFORCED ]\n"
1280 : " ALTER CONSTRAINT %s [ INHERIT | NO INHERIT ]\n"
1281 : " VALIDATE CONSTRAINT %s\n"
1282 : " DROP CONSTRAINT [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n"
1283 : " DISABLE TRIGGER [ %s | ALL | USER ]\n"
1284 : " ENABLE TRIGGER [ %s | ALL | USER ]\n"
1285 : " ENABLE REPLICA TRIGGER %s\n"
1286 : " ENABLE ALWAYS TRIGGER %s\n"
1287 : " DISABLE RULE %s\n"
1288 : " ENABLE RULE %s\n"
1289 : " ENABLE REPLICA RULE %s\n"
1290 : " ENABLE ALWAYS RULE %s\n"
1291 : " DISABLE ROW LEVEL SECURITY\n"
1292 : " ENABLE ROW LEVEL SECURITY\n"
1293 : " FORCE ROW LEVEL SECURITY\n"
1294 : " NO FORCE ROW LEVEL SECURITY\n"
1295 : " CLUSTER ON %s\n"
1296 : " SET WITHOUT CLUSTER\n"
1297 : " SET WITHOUT OIDS\n"
1298 : " SET ACCESS METHOD { %s | DEFAULT }\n"
1299 : " SET TABLESPACE %s\n"
1300 : " SET { LOGGED | UNLOGGED }\n"
1301 : " SET ( %s [= %s] [, ... ] )\n"
1302 : " RESET ( %s [, ... ] )\n"
1303 : " INHERIT %s\n"
1304 : " NO INHERIT %s\n"
1305 : " OF %s\n"
1306 : " NOT OF\n"
1307 : " OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1308 : " REPLICA IDENTITY { DEFAULT | USING INDEX %s | FULL | NOTHING }\n"
1309 : "\n"
1310 : "%s\n"
1311 : "\n"
1312 : "IN ( %s [, ...] ) |\n"
1313 : "FROM ( { %s | MINVALUE | MAXVALUE } [, ...] )\n"
1314 : " TO ( { %s | MINVALUE | MAXVALUE } [, ...] ) |\n"
1315 : "WITH ( MODULUS %s, REMAINDER %s )\n"
1316 : "\n"
1317 : "%s\n"
1318 : "\n"
1319 : "[ CONSTRAINT %s ]\n"
1320 : "{ NOT NULL [ NO INHERIT ] |\n"
1321 : " NULL |\n"
1322 : " CHECK ( %s ) [ NO INHERIT ] |\n"
1323 : " DEFAULT %s |\n"
1324 : " GENERATED ALWAYS AS ( %s ) [ STORED | VIRTUAL ] |\n"
1325 : " GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( %s ) ] |\n"
1326 : " UNIQUE [ NULLS [ NOT ] DISTINCT ] %s |\n"
1327 : " PRIMARY KEY %s |\n"
1328 : " REFERENCES %s [ ( %s ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]\n"
1329 : " [ ON DELETE %s ] [ ON UPDATE %s ] }\n"
1330 : "[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [ ENFORCED | NOT ENFORCED ]\n"
1331 : "\n"
1332 : "%s\n"
1333 : "\n"
1334 : "[ CONSTRAINT %s ]\n"
1335 : "{ CHECK ( %s ) [ NO INHERIT ] |\n"
1336 : " NOT NULL %s [ NO INHERIT ] |\n"
1337 : " UNIQUE [ NULLS [ NOT ] DISTINCT ] ( %s [, ... ] [, %s WITHOUT OVERLAPS ] ) %s |\n"
1338 : " PRIMARY KEY ( %s [, ... ] [, %s WITHOUT OVERLAPS ] ) %s |\n"
1339 : " EXCLUDE [ USING %s ] ( %s WITH %s [, ... ] ) %s [ WHERE ( %s ) ] |\n"
1340 : " FOREIGN KEY ( %s [, ... ] [, PERIOD %s ] ) REFERENCES %s [ ( %s [, ... ] [, PERIOD %s ] ) ]\n"
1341 : " [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE %s ] [ ON UPDATE %s ] }\n"
1342 : "[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [ ENFORCED | NOT ENFORCED ]\n"
1343 : "\n"
1344 : "%s\n"
1345 : "\n"
1346 : " [ CONSTRAINT %s ]\n"
1347 : " { UNIQUE | PRIMARY KEY } USING INDEX %s\n"
1348 : " [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n"
1349 : "\n"
1350 : "%s\n"
1351 : "\n"
1352 : "[ INCLUDE ( %s [, ... ] ) ]\n"
1353 : "[ WITH ( %s [= %s] [, ... ] ) ]\n"
1354 : "[ USING INDEX TABLESPACE %s ]\n"
1355 : "\n"
1356 : "%s\n"
1357 : "\n"
1358 : "{ %s | ( %s ) } [ COLLATE %s ] [ %s [ ( %s = %s [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]\n"
1359 : "\n"
1360 : "%s\n"
1361 : "\n"
1362 : "{ NO ACTION | RESTRICT | CASCADE | SET NULL [ ( %s [, ... ] ) ] | SET DEFAULT [ ( %s [, ... ] ) ] }",
1363 : _("name"),
1364 : _("action"),
1365 : _("name"),
1366 : _("column_name"),
1367 : _("new_column_name"),
1368 : _("name"),
1369 : _("constraint_name"),
1370 : _("new_constraint_name"),
1371 : _("name"),
1372 : _("new_name"),
1373 : _("name"),
1374 : _("new_schema"),
1375 : _("name"),
1376 : _("role_name"),
1377 : _("new_tablespace"),
1378 : _("name"),
1379 : _("partition_name"),
1380 : _("partition_bound_spec"),
1381 : _("name"),
1382 : _("partition_name"),
1383 : _("name"),
1384 : _("partition_name1"),
1385 : _("partition_name2"),
1386 : _("partition_name"),
1387 : _("name"),
1388 : _("partition_name"),
1389 : _("partition_name1"),
1390 : _("partition_bound_spec"),
1391 : _("partition_name2"),
1392 : _("partition_bound_spec"),
1393 : _("where action is one of:"),
1394 : _("column_name"),
1395 : _("data_type"),
1396 : _("collation"),
1397 : _("column_constraint"),
1398 : _("column_name"),
1399 : _("column_name"),
1400 : _("data_type"),
1401 : _("collation"),
1402 : _("expression"),
1403 : _("column_name"),
1404 : _("expression"),
1405 : _("column_name"),
1406 : _("column_name"),
1407 : _("column_name"),
1408 : _("expression"),
1409 : _("column_name"),
1410 : _("column_name"),
1411 : _("sequence_options"),
1412 : _("column_name"),
1413 : _("sequence_option"),
1414 : _("restart"),
1415 : _("column_name"),
1416 : _("column_name"),
1417 : _("integer"),
1418 : _("column_name"),
1419 : _("attribute_option"),
1420 : _("value"),
1421 : _("column_name"),
1422 : _("attribute_option"),
1423 : _("column_name"),
1424 : _("column_name"),
1425 : _("compression_method"),
1426 : _("table_constraint"),
1427 : _("table_constraint_using_index"),
1428 : _("constraint_name"),
1429 : _("constraint_name"),
1430 : _("constraint_name"),
1431 : _("constraint_name"),
1432 : _("trigger_name"),
1433 : _("trigger_name"),
1434 : _("trigger_name"),
1435 : _("trigger_name"),
1436 : _("rewrite_rule_name"),
1437 : _("rewrite_rule_name"),
1438 : _("rewrite_rule_name"),
1439 : _("rewrite_rule_name"),
1440 : _("index_name"),
1441 : _("new_access_method"),
1442 : _("new_tablespace"),
1443 : _("storage_parameter"),
1444 : _("value"),
1445 : _("storage_parameter"),
1446 : _("parent_table"),
1447 : _("parent_table"),
1448 : _("type_name"),
1449 : _("new_owner"),
1450 : _("index_name"),
1451 : _("and partition_bound_spec is:"),
1452 : _("partition_bound_expr"),
1453 : _("partition_bound_expr"),
1454 : _("partition_bound_expr"),
1455 : _("numeric_literal"),
1456 : _("numeric_literal"),
1457 : _("and column_constraint is:"),
1458 : _("constraint_name"),
1459 : _("expression"),
1460 : _("default_expr"),
1461 : _("generation_expr"),
1462 : _("sequence_options"),
1463 : _("index_parameters"),
1464 : _("index_parameters"),
1465 : _("reftable"),
1466 : _("refcolumn"),
1467 : _("referential_action"),
1468 : _("referential_action"),
1469 : _("and table_constraint is:"),
1470 : _("constraint_name"),
1471 : _("expression"),
1472 : _("column_name"),
1473 : _("column_name"),
1474 : _("column_name"),
1475 : _("index_parameters"),
1476 : _("column_name"),
1477 : _("column_name"),
1478 : _("index_parameters"),
1479 : _("index_method"),
1480 : _("exclude_element"),
1481 : _("operator"),
1482 : _("index_parameters"),
1483 : _("predicate"),
1484 : _("column_name"),
1485 : _("column_name"),
1486 : _("reftable"),
1487 : _("refcolumn"),
1488 : _("refcolumn"),
1489 : _("referential_action"),
1490 : _("referential_action"),
1491 : _("and table_constraint_using_index is:"),
1492 : _("constraint_name"),
1493 : _("index_name"),
1494 : _("index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:"),
1495 : _("column_name"),
1496 : _("storage_parameter"),
1497 : _("value"),
1498 : _("tablespace_name"),
1499 : _("exclude_element in an EXCLUDE constraint is:"),
1500 : _("column_name"),
1501 : _("expression"),
1502 : _("collation"),
1503 : _("opclass"),
1504 : _("opclass_parameter"),
1505 : _("value"),
1506 : _("referential_action in a FOREIGN KEY/REFERENCES constraint is:"),
1507 : _("column_name"),
1508 : _("column_name"));
1509 0 : }
1510 :
1511 : static void
1512 0 : sql_help_ALTER_TABLESPACE(PQExpBuffer buf)
1513 : {
1514 0 : appendPQExpBuffer(buf,
1515 : "ALTER TABLESPACE %s RENAME TO %s\n"
1516 : "ALTER TABLESPACE %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1517 : "ALTER TABLESPACE %s SET ( %s = %s [, ... ] )\n"
1518 : "ALTER TABLESPACE %s RESET ( %s [, ... ] )",
1519 : _("name"),
1520 : _("new_name"),
1521 : _("name"),
1522 : _("new_owner"),
1523 : _("name"),
1524 : _("tablespace_option"),
1525 : _("value"),
1526 : _("name"),
1527 : _("tablespace_option"));
1528 0 : }
1529 :
1530 : static void
1531 0 : sql_help_ALTER_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf)
1532 : {
1533 0 : appendPQExpBuffer(buf,
1534 : "ALTER TEXT SEARCH CONFIGURATION %s\n"
1535 : " ADD MAPPING FOR %s [, ... ] WITH %s [, ... ]\n"
1536 : "ALTER TEXT SEARCH CONFIGURATION %s\n"
1537 : " ALTER MAPPING FOR %s [, ... ] WITH %s [, ... ]\n"
1538 : "ALTER TEXT SEARCH CONFIGURATION %s\n"
1539 : " ALTER MAPPING REPLACE %s WITH %s\n"
1540 : "ALTER TEXT SEARCH CONFIGURATION %s\n"
1541 : " ALTER MAPPING FOR %s [, ... ] REPLACE %s WITH %s\n"
1542 : "ALTER TEXT SEARCH CONFIGURATION %s\n"
1543 : " DROP MAPPING [ IF EXISTS ] FOR %s [, ... ]\n"
1544 : "ALTER TEXT SEARCH CONFIGURATION %s RENAME TO %s\n"
1545 : "ALTER TEXT SEARCH CONFIGURATION %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1546 : "ALTER TEXT SEARCH CONFIGURATION %s SET SCHEMA %s",
1547 : _("name"),
1548 : _("token_type"),
1549 : _("dictionary_name"),
1550 : _("name"),
1551 : _("token_type"),
1552 : _("dictionary_name"),
1553 : _("name"),
1554 : _("old_dictionary"),
1555 : _("new_dictionary"),
1556 : _("name"),
1557 : _("token_type"),
1558 : _("old_dictionary"),
1559 : _("new_dictionary"),
1560 : _("name"),
1561 : _("token_type"),
1562 : _("name"),
1563 : _("new_name"),
1564 : _("name"),
1565 : _("new_owner"),
1566 : _("name"),
1567 : _("new_schema"));
1568 0 : }
1569 :
1570 : static void
1571 0 : sql_help_ALTER_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf)
1572 : {
1573 0 : appendPQExpBuffer(buf,
1574 : "ALTER TEXT SEARCH DICTIONARY %s (\n"
1575 : " %s [ = %s ] [, ... ]\n"
1576 : ")\n"
1577 : "ALTER TEXT SEARCH DICTIONARY %s RENAME TO %s\n"
1578 : "ALTER TEXT SEARCH DICTIONARY %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1579 : "ALTER TEXT SEARCH DICTIONARY %s SET SCHEMA %s",
1580 : _("name"),
1581 : _("option"),
1582 : _("value"),
1583 : _("name"),
1584 : _("new_name"),
1585 : _("name"),
1586 : _("new_owner"),
1587 : _("name"),
1588 : _("new_schema"));
1589 0 : }
1590 :
1591 : static void
1592 0 : sql_help_ALTER_TEXT_SEARCH_PARSER(PQExpBuffer buf)
1593 : {
1594 0 : appendPQExpBuffer(buf,
1595 : "ALTER TEXT SEARCH PARSER %s RENAME TO %s\n"
1596 : "ALTER TEXT SEARCH PARSER %s SET SCHEMA %s",
1597 : _("name"),
1598 : _("new_name"),
1599 : _("name"),
1600 : _("new_schema"));
1601 0 : }
1602 :
1603 : static void
1604 0 : sql_help_ALTER_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf)
1605 : {
1606 0 : appendPQExpBuffer(buf,
1607 : "ALTER TEXT SEARCH TEMPLATE %s RENAME TO %s\n"
1608 : "ALTER TEXT SEARCH TEMPLATE %s SET SCHEMA %s",
1609 : _("name"),
1610 : _("new_name"),
1611 : _("name"),
1612 : _("new_schema"));
1613 0 : }
1614 :
1615 : static void
1616 0 : sql_help_ALTER_TRIGGER(PQExpBuffer buf)
1617 : {
1618 0 : appendPQExpBuffer(buf,
1619 : "ALTER TRIGGER %s ON %s RENAME TO %s\n"
1620 : "ALTER TRIGGER %s ON %s [ NO ] DEPENDS ON EXTENSION %s",
1621 : _("name"),
1622 : _("table_name"),
1623 : _("new_name"),
1624 : _("name"),
1625 : _("table_name"),
1626 : _("extension_name"));
1627 0 : }
1628 :
1629 : static void
1630 0 : sql_help_ALTER_TYPE(PQExpBuffer buf)
1631 : {
1632 0 : appendPQExpBuffer(buf,
1633 : "ALTER TYPE %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1634 : "ALTER TYPE %s RENAME TO %s\n"
1635 : "ALTER TYPE %s SET SCHEMA %s\n"
1636 : "ALTER TYPE %s RENAME ATTRIBUTE %s TO %s [ CASCADE | RESTRICT ]\n"
1637 : "ALTER TYPE %s %s [, ... ]\n"
1638 : "ALTER TYPE %s ADD VALUE [ IF NOT EXISTS ] %s [ { BEFORE | AFTER } %s ]\n"
1639 : "ALTER TYPE %s RENAME VALUE %s TO %s\n"
1640 : "ALTER TYPE %s SET ( %s = %s [, ... ] )\n"
1641 : "\n"
1642 : "%s\n"
1643 : "\n"
1644 : " ADD ATTRIBUTE %s %s [ COLLATE %s ] [ CASCADE | RESTRICT ]\n"
1645 : " DROP ATTRIBUTE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]\n"
1646 : " ALTER ATTRIBUTE %s [ SET DATA ] TYPE %s [ COLLATE %s ] [ CASCADE | RESTRICT ]",
1647 : _("name"),
1648 : _("new_owner"),
1649 : _("name"),
1650 : _("new_name"),
1651 : _("name"),
1652 : _("new_schema"),
1653 : _("name"),
1654 : _("attribute_name"),
1655 : _("new_attribute_name"),
1656 : _("name"),
1657 : _("action"),
1658 : _("name"),
1659 : _("new_enum_value"),
1660 : _("neighbor_enum_value"),
1661 : _("name"),
1662 : _("existing_enum_value"),
1663 : _("new_enum_value"),
1664 : _("name"),
1665 : _("property"),
1666 : _("value"),
1667 : _("where action is one of:"),
1668 : _("attribute_name"),
1669 : _("data_type"),
1670 : _("collation"),
1671 : _("attribute_name"),
1672 : _("attribute_name"),
1673 : _("data_type"),
1674 : _("collation"));
1675 0 : }
1676 :
1677 : static void
1678 0 : sql_help_ALTER_USER(PQExpBuffer buf)
1679 : {
1680 0 : appendPQExpBuffer(buf,
1681 : "ALTER USER %s [ WITH ] %s [ ... ]\n"
1682 : "\n"
1683 : "%s\n"
1684 : "\n"
1685 : " SUPERUSER | NOSUPERUSER\n"
1686 : " | CREATEDB | NOCREATEDB\n"
1687 : " | CREATEROLE | NOCREATEROLE\n"
1688 : " | INHERIT | NOINHERIT\n"
1689 : " | LOGIN | NOLOGIN\n"
1690 : " | REPLICATION | NOREPLICATION\n"
1691 : " | BYPASSRLS | NOBYPASSRLS\n"
1692 : " | CONNECTION LIMIT %s\n"
1693 : " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n"
1694 : " | VALID UNTIL '%s'\n"
1695 : "\n"
1696 : "ALTER USER %s RENAME TO %s\n"
1697 : "\n"
1698 : "ALTER USER { %s | ALL } [ IN DATABASE %s ] SET %s { TO | = } { %s | DEFAULT }\n"
1699 : "ALTER USER { %s | ALL } [ IN DATABASE %s ] SET %s FROM CURRENT\n"
1700 : "ALTER USER { %s | ALL } [ IN DATABASE %s ] RESET %s\n"
1701 : "ALTER USER { %s | ALL } [ IN DATABASE %s ] RESET ALL\n"
1702 : "\n"
1703 : "%s\n"
1704 : "\n"
1705 : " %s\n"
1706 : " | CURRENT_ROLE\n"
1707 : " | CURRENT_USER\n"
1708 : " | SESSION_USER",
1709 : _("role_specification"),
1710 : _("option"),
1711 : _("where option can be:"),
1712 : _("connlimit"),
1713 : _("password"),
1714 : _("timestamp"),
1715 : _("name"),
1716 : _("new_name"),
1717 : _("role_specification"),
1718 : _("database_name"),
1719 : _("configuration_parameter"),
1720 : _("value"),
1721 : _("role_specification"),
1722 : _("database_name"),
1723 : _("configuration_parameter"),
1724 : _("role_specification"),
1725 : _("database_name"),
1726 : _("configuration_parameter"),
1727 : _("role_specification"),
1728 : _("database_name"),
1729 : _("where role_specification can be:"),
1730 : _("role_name"));
1731 0 : }
1732 :
1733 : static void
1734 0 : sql_help_ALTER_USER_MAPPING(PQExpBuffer buf)
1735 : {
1736 0 : appendPQExpBuffer(buf,
1737 : "ALTER USER MAPPING FOR { %s | USER | CURRENT_ROLE | CURRENT_USER | SESSION_USER | PUBLIC }\n"
1738 : " SERVER %s\n"
1739 : " OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ] )",
1740 : _("user_name"),
1741 : _("server_name"),
1742 : _("option"),
1743 : _("value"));
1744 0 : }
1745 :
1746 : static void
1747 0 : sql_help_ALTER_VIEW(PQExpBuffer buf)
1748 : {
1749 0 : appendPQExpBuffer(buf,
1750 : "ALTER VIEW [ IF EXISTS ] %s ALTER [ COLUMN ] %s SET DEFAULT %s\n"
1751 : "ALTER VIEW [ IF EXISTS ] %s ALTER [ COLUMN ] %s DROP DEFAULT\n"
1752 : "ALTER VIEW [ IF EXISTS ] %s OWNER TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\n"
1753 : "ALTER VIEW [ IF EXISTS ] %s RENAME [ COLUMN ] %s TO %s\n"
1754 : "ALTER VIEW [ IF EXISTS ] %s RENAME TO %s\n"
1755 : "ALTER VIEW [ IF EXISTS ] %s SET SCHEMA %s\n"
1756 : "ALTER VIEW [ IF EXISTS ] %s SET ( %s [= %s] [, ... ] )\n"
1757 : "ALTER VIEW [ IF EXISTS ] %s RESET ( %s [, ... ] )",
1758 : _("name"),
1759 : _("column_name"),
1760 : _("expression"),
1761 : _("name"),
1762 : _("column_name"),
1763 : _("name"),
1764 : _("new_owner"),
1765 : _("name"),
1766 : _("column_name"),
1767 : _("new_column_name"),
1768 : _("name"),
1769 : _("new_name"),
1770 : _("name"),
1771 : _("new_schema"),
1772 : _("name"),
1773 : _("view_option_name"),
1774 : _("view_option_value"),
1775 : _("name"),
1776 : _("view_option_name"));
1777 0 : }
1778 :
1779 : static void
1780 0 : sql_help_ANALYZE(PQExpBuffer buf)
1781 : {
1782 0 : appendPQExpBuffer(buf,
1783 : "ANALYZE [ ( %s [, ...] ) ] [ %s [, ...] ]\n"
1784 : "\n"
1785 : "%s\n"
1786 : "\n"
1787 : " VERBOSE [ %s ]\n"
1788 : " SKIP_LOCKED [ %s ]\n"
1789 : " BUFFER_USAGE_LIMIT %s\n"
1790 : "\n"
1791 : "%s\n"
1792 : "\n"
1793 : " [ ONLY ] %s [ * ] [ ( %s [, ...] ) ]",
1794 : _("option"),
1795 : _("table_and_columns"),
1796 : _("where option can be one of:"),
1797 : _("boolean"),
1798 : _("boolean"),
1799 : _("size"),
1800 : _("and table_and_columns is:"),
1801 : _("table_name"),
1802 : _("column_name"));
1803 0 : }
1804 :
1805 : static void
1806 0 : sql_help_BEGIN(PQExpBuffer buf)
1807 : {
1808 0 : appendPQExpBuffer(buf,
1809 : "BEGIN [ WORK | TRANSACTION ] [ %s [, ...] ]\n"
1810 : "\n"
1811 : "%s\n"
1812 : "\n"
1813 : " ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n"
1814 : " READ WRITE | READ ONLY\n"
1815 : " [ NOT ] DEFERRABLE",
1816 : _("transaction_mode"),
1817 : _("where transaction_mode is one of:"));
1818 0 : }
1819 :
1820 : static void
1821 0 : sql_help_CALL(PQExpBuffer buf)
1822 : {
1823 0 : appendPQExpBuffer(buf,
1824 : "CALL %s ( [ %s ] [, ...] )",
1825 : _("name"),
1826 : _("argument"));
1827 0 : }
1828 :
1829 : static void
1830 0 : sql_help_CHECKPOINT(PQExpBuffer buf)
1831 : {
1832 0 : appendPQExpBuffer(buf,
1833 : "CHECKPOINT [ ( option [, ...] ) ]\n"
1834 : "\n"
1835 : "%s\n"
1836 : "\n"
1837 : " FLUSH_UNLOGGED [ %s ]\n"
1838 : " MODE { FAST | SPREAD }",
1839 : _("where option can be one of:"),
1840 : _("boolean"));
1841 0 : }
1842 :
1843 : static void
1844 0 : sql_help_CLOSE(PQExpBuffer buf)
1845 : {
1846 0 : appendPQExpBuffer(buf,
1847 : "CLOSE { %s | ALL }",
1848 : _("name"));
1849 0 : }
1850 :
1851 : static void
1852 0 : sql_help_CLUSTER(PQExpBuffer buf)
1853 : {
1854 0 : appendPQExpBuffer(buf,
1855 : "CLUSTER [ ( %s [, ...] ) ] [ %s [ USING %s ] ]\n"
1856 : "\n"
1857 : "%s\n"
1858 : "\n"
1859 : " VERBOSE [ %s ]",
1860 : _("option"),
1861 : _("table_name"),
1862 : _("index_name"),
1863 : _("where option can be one of:"),
1864 : _("boolean"));
1865 0 : }
1866 :
1867 : static void
1868 0 : sql_help_COMMENT(PQExpBuffer buf)
1869 : {
1870 0 : appendPQExpBuffer(buf,
1871 : "COMMENT ON\n"
1872 : "{\n"
1873 : " ACCESS METHOD %s |\n"
1874 : " AGGREGATE %s ( %s ) |\n"
1875 : " CAST (%s AS %s) |\n"
1876 : " COLLATION %s |\n"
1877 : " COLUMN %s.%s |\n"
1878 : " CONSTRAINT %s ON %s |\n"
1879 : " CONSTRAINT %s ON DOMAIN %s |\n"
1880 : " CONVERSION %s |\n"
1881 : " DATABASE %s |\n"
1882 : " DOMAIN %s |\n"
1883 : " EXTENSION %s |\n"
1884 : " EVENT TRIGGER %s |\n"
1885 : " FOREIGN DATA WRAPPER %s |\n"
1886 : " FOREIGN TABLE %s |\n"
1887 : " FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
1888 : " INDEX %s |\n"
1889 : " LARGE OBJECT %s |\n"
1890 : " MATERIALIZED VIEW %s |\n"
1891 : " OPERATOR %s (%s, %s) |\n"
1892 : " OPERATOR CLASS %s USING %s |\n"
1893 : " OPERATOR FAMILY %s USING %s |\n"
1894 : " POLICY %s ON %s |\n"
1895 : " [ PROCEDURAL ] LANGUAGE %s |\n"
1896 : " PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
1897 : " PUBLICATION %s |\n"
1898 : " ROLE %s |\n"
1899 : " ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
1900 : " RULE %s ON %s |\n"
1901 : " SCHEMA %s |\n"
1902 : " SEQUENCE %s |\n"
1903 : " SERVER %s |\n"
1904 : " STATISTICS %s |\n"
1905 : " SUBSCRIPTION %s |\n"
1906 : " TABLE %s |\n"
1907 : " TABLESPACE %s |\n"
1908 : " TEXT SEARCH CONFIGURATION %s |\n"
1909 : " TEXT SEARCH DICTIONARY %s |\n"
1910 : " TEXT SEARCH PARSER %s |\n"
1911 : " TEXT SEARCH TEMPLATE %s |\n"
1912 : " TRANSFORM FOR %s LANGUAGE %s |\n"
1913 : " TRIGGER %s ON %s |\n"
1914 : " TYPE %s |\n"
1915 : " VIEW %s\n"
1916 : "} IS { %s | NULL }\n"
1917 : "\n"
1918 : "%s\n"
1919 : "\n"
1920 : "* |\n"
1921 : "[ %s ] [ %s ] %s [ , ... ] |\n"
1922 : "[ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ]",
1923 : _("object_name"),
1924 : _("aggregate_name"),
1925 : _("aggregate_signature"),
1926 : _("source_type"),
1927 : _("target_type"),
1928 : _("object_name"),
1929 : _("relation_name"),
1930 : _("column_name"),
1931 : _("constraint_name"),
1932 : _("table_name"),
1933 : _("constraint_name"),
1934 : _("domain_name"),
1935 : _("object_name"),
1936 : _("object_name"),
1937 : _("object_name"),
1938 : _("object_name"),
1939 : _("object_name"),
1940 : _("object_name"),
1941 : _("object_name"),
1942 : _("function_name"),
1943 : _("argmode"),
1944 : _("argname"),
1945 : _("argtype"),
1946 : _("object_name"),
1947 : _("large_object_oid"),
1948 : _("object_name"),
1949 : _("operator_name"),
1950 : _("left_type"),
1951 : _("right_type"),
1952 : _("object_name"),
1953 : _("index_method"),
1954 : _("object_name"),
1955 : _("index_method"),
1956 : _("policy_name"),
1957 : _("table_name"),
1958 : _("object_name"),
1959 : _("procedure_name"),
1960 : _("argmode"),
1961 : _("argname"),
1962 : _("argtype"),
1963 : _("object_name"),
1964 : _("object_name"),
1965 : _("routine_name"),
1966 : _("argmode"),
1967 : _("argname"),
1968 : _("argtype"),
1969 : _("rule_name"),
1970 : _("table_name"),
1971 : _("object_name"),
1972 : _("object_name"),
1973 : _("object_name"),
1974 : _("object_name"),
1975 : _("object_name"),
1976 : _("object_name"),
1977 : _("object_name"),
1978 : _("object_name"),
1979 : _("object_name"),
1980 : _("object_name"),
1981 : _("object_name"),
1982 : _("type_name"),
1983 : _("lang_name"),
1984 : _("trigger_name"),
1985 : _("table_name"),
1986 : _("object_name"),
1987 : _("object_name"),
1988 : _("string_literal"),
1989 : _("where aggregate_signature is:"),
1990 : _("argmode"),
1991 : _("argname"),
1992 : _("argtype"),
1993 : _("argmode"),
1994 : _("argname"),
1995 : _("argtype"),
1996 : _("argmode"),
1997 : _("argname"),
1998 : _("argtype"));
1999 0 : }
2000 :
2001 : static void
2002 0 : sql_help_COMMIT(PQExpBuffer buf)
2003 : {
2004 0 : appendPQExpBuffer(buf,
2005 : "COMMIT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]");
2006 0 : }
2007 :
2008 : static void
2009 0 : sql_help_COMMIT_PREPARED(PQExpBuffer buf)
2010 : {
2011 0 : appendPQExpBuffer(buf,
2012 : "COMMIT PREPARED %s",
2013 : _("transaction_id"));
2014 0 : }
2015 :
2016 : static void
2017 0 : sql_help_COPY(PQExpBuffer buf)
2018 : {
2019 0 : appendPQExpBuffer(buf,
2020 : "COPY %s [ ( %s [, ...] ) ]\n"
2021 : " FROM { '%s' | PROGRAM '%s' | STDIN }\n"
2022 : " [ [ WITH ] ( %s [, ...] ) ]\n"
2023 : " [ WHERE %s ]\n"
2024 : "\n"
2025 : "COPY { %s [ ( %s [, ...] ) ] | ( %s ) }\n"
2026 : " TO { '%s' | PROGRAM '%s' | STDOUT }\n"
2027 : " [ [ WITH ] ( %s [, ...] ) ]\n"
2028 : "\n"
2029 : "%s\n"
2030 : "\n"
2031 : " FORMAT %s\n"
2032 : " FREEZE [ %s ]\n"
2033 : " DELIMITER '%s'\n"
2034 : " NULL '%s'\n"
2035 : " DEFAULT '%s'\n"
2036 : " HEADER [ %s | %s | MATCH ]\n"
2037 : " QUOTE '%s'\n"
2038 : " ESCAPE '%s'\n"
2039 : " FORCE_QUOTE { ( %s [, ...] ) | * }\n"
2040 : " FORCE_NOT_NULL { ( %s [, ...] ) | * }\n"
2041 : " FORCE_NULL { ( %s [, ...] ) | * }\n"
2042 : " ON_ERROR %s\n"
2043 : " REJECT_LIMIT %s\n"
2044 : " ENCODING '%s'\n"
2045 : " LOG_VERBOSITY %s",
2046 : _("table_name"),
2047 : _("column_name"),
2048 : _("filename"),
2049 : _("command"),
2050 : _("option"),
2051 : _("condition"),
2052 : _("table_name"),
2053 : _("column_name"),
2054 : _("query"),
2055 : _("filename"),
2056 : _("command"),
2057 : _("option"),
2058 : _("where option can be one of:"),
2059 : _("format_name"),
2060 : _("boolean"),
2061 : _("delimiter_character"),
2062 : _("null_string"),
2063 : _("default_string"),
2064 : _("boolean"),
2065 : _("integer"),
2066 : _("quote_character"),
2067 : _("escape_character"),
2068 : _("column_name"),
2069 : _("column_name"),
2070 : _("column_name"),
2071 : _("error_action"),
2072 : _("maxerror"),
2073 : _("encoding_name"),
2074 : _("verbosity"));
2075 0 : }
2076 :
2077 : static void
2078 0 : sql_help_CREATE_ACCESS_METHOD(PQExpBuffer buf)
2079 : {
2080 0 : appendPQExpBuffer(buf,
2081 : "CREATE ACCESS METHOD %s\n"
2082 : " TYPE %s\n"
2083 : " HANDLER %s",
2084 : _("name"),
2085 : _("access_method_type"),
2086 : _("handler_function"));
2087 0 : }
2088 :
2089 : static void
2090 0 : sql_help_CREATE_AGGREGATE(PQExpBuffer buf)
2091 : {
2092 0 : appendPQExpBuffer(buf,
2093 : "CREATE [ OR REPLACE ] AGGREGATE %s ( [ %s ] [ %s ] %s [ , ... ] ) (\n"
2094 : " SFUNC = %s,\n"
2095 : " STYPE = %s\n"
2096 : " [ , SSPACE = %s ]\n"
2097 : " [ , FINALFUNC = %s ]\n"
2098 : " [ , FINALFUNC_EXTRA ]\n"
2099 : " [ , FINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]\n"
2100 : " [ , COMBINEFUNC = %s ]\n"
2101 : " [ , SERIALFUNC = %s ]\n"
2102 : " [ , DESERIALFUNC = %s ]\n"
2103 : " [ , INITCOND = %s ]\n"
2104 : " [ , MSFUNC = %s ]\n"
2105 : " [ , MINVFUNC = %s ]\n"
2106 : " [ , MSTYPE = %s ]\n"
2107 : " [ , MSSPACE = %s ]\n"
2108 : " [ , MFINALFUNC = %s ]\n"
2109 : " [ , MFINALFUNC_EXTRA ]\n"
2110 : " [ , MFINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]\n"
2111 : " [ , MINITCOND = %s ]\n"
2112 : " [ , SORTOP = %s ]\n"
2113 : " [ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ]\n"
2114 : ")\n"
2115 : "\n"
2116 : "CREATE [ OR REPLACE ] AGGREGATE %s ( [ [ %s ] [ %s ] %s [ , ... ] ]\n"
2117 : " ORDER BY [ %s ] [ %s ] %s [ , ... ] ) (\n"
2118 : " SFUNC = %s,\n"
2119 : " STYPE = %s\n"
2120 : " [ , SSPACE = %s ]\n"
2121 : " [ , FINALFUNC = %s ]\n"
2122 : " [ , FINALFUNC_EXTRA ]\n"
2123 : " [ , FINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]\n"
2124 : " [ , INITCOND = %s ]\n"
2125 : " [ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ]\n"
2126 : " [ , HYPOTHETICAL ]\n"
2127 : ")\n"
2128 : "\n"
2129 : "%s\n"
2130 : "\n"
2131 : "CREATE [ OR REPLACE ] AGGREGATE %s (\n"
2132 : " BASETYPE = %s,\n"
2133 : " SFUNC = %s,\n"
2134 : " STYPE = %s\n"
2135 : " [ , SSPACE = %s ]\n"
2136 : " [ , FINALFUNC = %s ]\n"
2137 : " [ , FINALFUNC_EXTRA ]\n"
2138 : " [ , FINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]\n"
2139 : " [ , COMBINEFUNC = %s ]\n"
2140 : " [ , SERIALFUNC = %s ]\n"
2141 : " [ , DESERIALFUNC = %s ]\n"
2142 : " [ , INITCOND = %s ]\n"
2143 : " [ , MSFUNC = %s ]\n"
2144 : " [ , MINVFUNC = %s ]\n"
2145 : " [ , MSTYPE = %s ]\n"
2146 : " [ , MSSPACE = %s ]\n"
2147 : " [ , MFINALFUNC = %s ]\n"
2148 : " [ , MFINALFUNC_EXTRA ]\n"
2149 : " [ , MFINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]\n"
2150 : " [ , MINITCOND = %s ]\n"
2151 : " [ , SORTOP = %s ]\n"
2152 : ")",
2153 : _("name"),
2154 : _("argmode"),
2155 : _("argname"),
2156 : _("arg_data_type"),
2157 : _("sfunc"),
2158 : _("state_data_type"),
2159 : _("state_data_size"),
2160 : _("ffunc"),
2161 : _("combinefunc"),
2162 : _("serialfunc"),
2163 : _("deserialfunc"),
2164 : _("initial_condition"),
2165 : _("msfunc"),
2166 : _("minvfunc"),
2167 : _("mstate_data_type"),
2168 : _("mstate_data_size"),
2169 : _("mffunc"),
2170 : _("minitial_condition"),
2171 : _("sort_operator"),
2172 : _("name"),
2173 : _("argmode"),
2174 : _("argname"),
2175 : _("arg_data_type"),
2176 : _("argmode"),
2177 : _("argname"),
2178 : _("arg_data_type"),
2179 : _("sfunc"),
2180 : _("state_data_type"),
2181 : _("state_data_size"),
2182 : _("ffunc"),
2183 : _("initial_condition"),
2184 : _("or the old syntax"),
2185 : _("name"),
2186 : _("base_type"),
2187 : _("sfunc"),
2188 : _("state_data_type"),
2189 : _("state_data_size"),
2190 : _("ffunc"),
2191 : _("combinefunc"),
2192 : _("serialfunc"),
2193 : _("deserialfunc"),
2194 : _("initial_condition"),
2195 : _("msfunc"),
2196 : _("minvfunc"),
2197 : _("mstate_data_type"),
2198 : _("mstate_data_size"),
2199 : _("mffunc"),
2200 : _("minitial_condition"),
2201 : _("sort_operator"));
2202 0 : }
2203 :
2204 : static void
2205 0 : sql_help_CREATE_CAST(PQExpBuffer buf)
2206 : {
2207 0 : appendPQExpBuffer(buf,
2208 : "CREATE CAST (%s AS %s)\n"
2209 : " WITH FUNCTION %s [ (%s [, ...]) ]\n"
2210 : " [ AS ASSIGNMENT | AS IMPLICIT ]\n"
2211 : "\n"
2212 : "CREATE CAST (%s AS %s)\n"
2213 : " WITHOUT FUNCTION\n"
2214 : " [ AS ASSIGNMENT | AS IMPLICIT ]\n"
2215 : "\n"
2216 : "CREATE CAST (%s AS %s)\n"
2217 : " WITH INOUT\n"
2218 : " [ AS ASSIGNMENT | AS IMPLICIT ]",
2219 : _("source_type"),
2220 : _("target_type"),
2221 : _("function_name"),
2222 : _("argument_type"),
2223 : _("source_type"),
2224 : _("target_type"),
2225 : _("source_type"),
2226 : _("target_type"));
2227 0 : }
2228 :
2229 : static void
2230 0 : sql_help_CREATE_COLLATION(PQExpBuffer buf)
2231 : {
2232 0 : appendPQExpBuffer(buf,
2233 : "CREATE COLLATION [ IF NOT EXISTS ] %s (\n"
2234 : " [ LOCALE = %s, ]\n"
2235 : " [ LC_COLLATE = %s, ]\n"
2236 : " [ LC_CTYPE = %s, ]\n"
2237 : " [ PROVIDER = %s, ]\n"
2238 : " [ DETERMINISTIC = %s, ]\n"
2239 : " [ RULES = %s, ]\n"
2240 : " [ VERSION = %s ]\n"
2241 : ")\n"
2242 : "CREATE COLLATION [ IF NOT EXISTS ] %s FROM %s",
2243 : _("name"),
2244 : _("locale"),
2245 : _("lc_collate"),
2246 : _("lc_ctype"),
2247 : _("provider"),
2248 : _("boolean"),
2249 : _("rules"),
2250 : _("version"),
2251 : _("name"),
2252 : _("existing_collation"));
2253 0 : }
2254 :
2255 : static void
2256 0 : sql_help_CREATE_CONVERSION(PQExpBuffer buf)
2257 : {
2258 0 : appendPQExpBuffer(buf,
2259 : "CREATE [ DEFAULT ] CONVERSION %s\n"
2260 : " FOR %s TO %s FROM %s",
2261 : _("name"),
2262 : _("source_encoding"),
2263 : _("dest_encoding"),
2264 : _("function_name"));
2265 0 : }
2266 :
2267 : static void
2268 0 : sql_help_CREATE_DATABASE(PQExpBuffer buf)
2269 : {
2270 0 : appendPQExpBuffer(buf,
2271 : "CREATE DATABASE %s\n"
2272 : " [ WITH ] [ OWNER [=] %s ]\n"
2273 : " [ TEMPLATE [=] %s ]\n"
2274 : " [ ENCODING [=] %s ]\n"
2275 : " [ STRATEGY [=] %s ]\n"
2276 : " [ LOCALE [=] %s ]\n"
2277 : " [ LC_COLLATE [=] %s ]\n"
2278 : " [ LC_CTYPE [=] %s ]\n"
2279 : " [ BUILTIN_LOCALE [=] %s ]\n"
2280 : " [ ICU_LOCALE [=] %s ]\n"
2281 : " [ ICU_RULES [=] %s ]\n"
2282 : " [ LOCALE_PROVIDER [=] %s ]\n"
2283 : " [ COLLATION_VERSION = %s ]\n"
2284 : " [ TABLESPACE [=] %s ]\n"
2285 : " [ ALLOW_CONNECTIONS [=] %s ]\n"
2286 : " [ CONNECTION LIMIT [=] %s ]\n"
2287 : " [ IS_TEMPLATE [=] %s ]\n"
2288 : " [ OID [=] %s ]",
2289 : _("name"),
2290 : _("user_name"),
2291 : _("template"),
2292 : _("encoding"),
2293 : _("strategy"),
2294 : _("locale"),
2295 : _("lc_collate"),
2296 : _("lc_ctype"),
2297 : _("builtin_locale"),
2298 : _("icu_locale"),
2299 : _("icu_rules"),
2300 : _("locale_provider"),
2301 : _("collation_version"),
2302 : _("tablespace_name"),
2303 : _("allowconn"),
2304 : _("connlimit"),
2305 : _("istemplate"),
2306 : _("oid"));
2307 0 : }
2308 :
2309 : static void
2310 0 : sql_help_CREATE_DOMAIN(PQExpBuffer buf)
2311 : {
2312 0 : appendPQExpBuffer(buf,
2313 : "CREATE DOMAIN %s [ AS ] %s\n"
2314 : " [ COLLATE %s ]\n"
2315 : " [ DEFAULT %s ]\n"
2316 : " [ %s [ ... ] ]\n"
2317 : "\n"
2318 : "%s\n"
2319 : "\n"
2320 : "[ CONSTRAINT %s ]\n"
2321 : "{ NOT NULL | NULL | CHECK (%s) }",
2322 : _("name"),
2323 : _("data_type"),
2324 : _("collation"),
2325 : _("expression"),
2326 : _("domain_constraint"),
2327 : _("where domain_constraint is:"),
2328 : _("constraint_name"),
2329 : _("expression"));
2330 0 : }
2331 :
2332 : static void
2333 0 : sql_help_CREATE_EVENT_TRIGGER(PQExpBuffer buf)
2334 : {
2335 0 : appendPQExpBuffer(buf,
2336 : "CREATE EVENT TRIGGER %s\n"
2337 : " ON %s\n"
2338 : " [ WHEN %s IN (%s [, ... ]) [ AND ... ] ]\n"
2339 : " EXECUTE { FUNCTION | PROCEDURE } %s()",
2340 : _("name"),
2341 : _("event"),
2342 : _("filter_variable"),
2343 : _("filter_value"),
2344 : _("function_name"));
2345 0 : }
2346 :
2347 : static void
2348 0 : sql_help_CREATE_EXTENSION(PQExpBuffer buf)
2349 : {
2350 0 : appendPQExpBuffer(buf,
2351 : "CREATE EXTENSION [ IF NOT EXISTS ] %s\n"
2352 : " [ WITH ] [ SCHEMA %s ]\n"
2353 : " [ VERSION %s ]\n"
2354 : " [ CASCADE ]",
2355 : _("extension_name"),
2356 : _("schema_name"),
2357 : _("version"));
2358 0 : }
2359 :
2360 : static void
2361 0 : sql_help_CREATE_FOREIGN_DATA_WRAPPER(PQExpBuffer buf)
2362 : {
2363 0 : appendPQExpBuffer(buf,
2364 : "CREATE FOREIGN DATA WRAPPER %s\n"
2365 : " [ HANDLER %s | NO HANDLER ]\n"
2366 : " [ VALIDATOR %s | NO VALIDATOR ]\n"
2367 : " [ OPTIONS ( %s '%s' [, ... ] ) ]",
2368 : _("name"),
2369 : _("handler_function"),
2370 : _("validator_function"),
2371 : _("option"),
2372 : _("value"));
2373 0 : }
2374 :
2375 : static void
2376 0 : sql_help_CREATE_FOREIGN_TABLE(PQExpBuffer buf)
2377 : {
2378 0 : appendPQExpBuffer(buf,
2379 : "CREATE FOREIGN TABLE [ IF NOT EXISTS ] %s ( [\n"
2380 : " { %s %s [ OPTIONS ( %s '%s' [, ... ] ) ] [ COLLATE %s ] [ %s [ ... ] ]\n"
2381 : " | %s\n"
2382 : " | LIKE %s [ %s ... ] }\n"
2383 : " [, ... ]\n"
2384 : "] )\n"
2385 : "[ INHERITS ( %s [, ... ] ) ]\n"
2386 : " SERVER %s\n"
2387 : "[ OPTIONS ( %s '%s' [, ... ] ) ]\n"
2388 : "\n"
2389 : "CREATE FOREIGN TABLE [ IF NOT EXISTS ] %s\n"
2390 : " PARTITION OF %s [ (\n"
2391 : " { %s [ WITH OPTIONS ] [ %s [ ... ] ]\n"
2392 : " | %s }\n"
2393 : " [, ... ]\n"
2394 : ") ]\n"
2395 : "{ FOR VALUES %s | DEFAULT }\n"
2396 : " SERVER %s\n"
2397 : "[ OPTIONS ( %s '%s' [, ... ] ) ]\n"
2398 : "\n"
2399 : "%s\n"
2400 : "\n"
2401 : "[ CONSTRAINT %s ]\n"
2402 : "{ NOT NULL [ NO INHERIT ] |\n"
2403 : " NULL |\n"
2404 : " CHECK ( %s ) [ NO INHERIT ] |\n"
2405 : " DEFAULT %s |\n"
2406 : " GENERATED ALWAYS AS ( %s ) [ STORED | VIRTUAL ] }\n"
2407 : "[ ENFORCED | NOT ENFORCED ]\n"
2408 : "\n"
2409 : "%s\n"
2410 : "\n"
2411 : "[ CONSTRAINT %s ]\n"
2412 : "{ NOT NULL %s [ NO INHERIT ] |\n"
2413 : " CHECK ( %s ) [ NO INHERIT ] }\n"
2414 : "[ ENFORCED | NOT ENFORCED ]\n"
2415 : "\n"
2416 : "%s\n"
2417 : "\n"
2418 : "{ INCLUDING | EXCLUDING } { COMMENTS | CONSTRAINTS | DEFAULTS | GENERATED | STATISTICS | ALL }\n"
2419 : "\n"
2420 : "%s\n"
2421 : "\n"
2422 : "IN ( %s [, ...] ) |\n"
2423 : "FROM ( { %s | MINVALUE | MAXVALUE } [, ...] )\n"
2424 : " TO ( { %s | MINVALUE | MAXVALUE } [, ...] ) |\n"
2425 : "WITH ( MODULUS %s, REMAINDER %s )",
2426 : _("table_name"),
2427 : _("column_name"),
2428 : _("data_type"),
2429 : _("option"),
2430 : _("value"),
2431 : _("collation"),
2432 : _("column_constraint"),
2433 : _("table_constraint"),
2434 : _("source_table"),
2435 : _("like_option"),
2436 : _("parent_table"),
2437 : _("server_name"),
2438 : _("option"),
2439 : _("value"),
2440 : _("table_name"),
2441 : _("parent_table"),
2442 : _("column_name"),
2443 : _("column_constraint"),
2444 : _("table_constraint"),
2445 : _("partition_bound_spec"),
2446 : _("server_name"),
2447 : _("option"),
2448 : _("value"),
2449 : _("where column_constraint is:"),
2450 : _("constraint_name"),
2451 : _("expression"),
2452 : _("default_expr"),
2453 : _("generation_expr"),
2454 : _("and table_constraint is:"),
2455 : _("constraint_name"),
2456 : _("column_name"),
2457 : _("expression"),
2458 : _("and like_option is:"),
2459 : _("and partition_bound_spec is:"),
2460 : _("partition_bound_expr"),
2461 : _("partition_bound_expr"),
2462 : _("partition_bound_expr"),
2463 : _("numeric_literal"),
2464 : _("numeric_literal"));
2465 0 : }
2466 :
2467 : static void
2468 0 : sql_help_CREATE_FUNCTION(PQExpBuffer buf)
2469 : {
2470 0 : appendPQExpBuffer(buf,
2471 : "CREATE [ OR REPLACE ] FUNCTION\n"
2472 : " %s ( [ [ %s ] [ %s ] %s [ { DEFAULT | = } %s ] [, ...] ] )\n"
2473 : " [ RETURNS %s\n"
2474 : " | RETURNS TABLE ( %s %s [, ...] ) ]\n"
2475 : " { LANGUAGE %s\n"
2476 : " | TRANSFORM { FOR TYPE %s } [, ... ]\n"
2477 : " | WINDOW\n"
2478 : " | { IMMUTABLE | STABLE | VOLATILE }\n"
2479 : " | [ NOT ] LEAKPROOF\n"
2480 : " | { CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT }\n"
2481 : " | { [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER }\n"
2482 : " | PARALLEL { UNSAFE | RESTRICTED | SAFE }\n"
2483 : " | COST %s\n"
2484 : " | ROWS %s\n"
2485 : " | SUPPORT %s\n"
2486 : " | SET %s { TO %s | = %s | FROM CURRENT }\n"
2487 : " | AS '%s'\n"
2488 : " | AS '%s', '%s'\n"
2489 : " | %s\n"
2490 : " } ...",
2491 : _("name"),
2492 : _("argmode"),
2493 : _("argname"),
2494 : _("argtype"),
2495 : _("default_expr"),
2496 : _("rettype"),
2497 : _("column_name"),
2498 : _("column_type"),
2499 : _("lang_name"),
2500 : _("type_name"),
2501 : _("execution_cost"),
2502 : _("result_rows"),
2503 : _("support_function"),
2504 : _("configuration_parameter"),
2505 : _("value"),
2506 : _("value"),
2507 : _("definition"),
2508 : _("obj_file"),
2509 : _("link_symbol"),
2510 : _("sql_body"));
2511 0 : }
2512 :
2513 : static void
2514 0 : sql_help_CREATE_GROUP(PQExpBuffer buf)
2515 : {
2516 0 : appendPQExpBuffer(buf,
2517 : "CREATE GROUP %s [ [ WITH ] %s [ ... ] ]\n"
2518 : "\n"
2519 : "%s\n"
2520 : "\n"
2521 : " SUPERUSER | NOSUPERUSER\n"
2522 : " | CREATEDB | NOCREATEDB\n"
2523 : " | CREATEROLE | NOCREATEROLE\n"
2524 : " | INHERIT | NOINHERIT\n"
2525 : " | LOGIN | NOLOGIN\n"
2526 : " | REPLICATION | NOREPLICATION\n"
2527 : " | BYPASSRLS | NOBYPASSRLS\n"
2528 : " | CONNECTION LIMIT %s\n"
2529 : " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n"
2530 : " | VALID UNTIL '%s'\n"
2531 : " | IN ROLE %s [, ...]\n"
2532 : " | ROLE %s [, ...]\n"
2533 : " | ADMIN %s [, ...]\n"
2534 : " | SYSID %s",
2535 : _("name"),
2536 : _("option"),
2537 : _("where option can be:"),
2538 : _("connlimit"),
2539 : _("password"),
2540 : _("timestamp"),
2541 : _("role_name"),
2542 : _("role_name"),
2543 : _("role_name"),
2544 : _("uid"));
2545 0 : }
2546 :
2547 : static void
2548 0 : sql_help_CREATE_INDEX(PQExpBuffer buf)
2549 : {
2550 0 : appendPQExpBuffer(buf,
2551 : "CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] %s ] ON [ ONLY ] %s [ USING %s ]\n"
2552 : " ( { %s | ( %s ) } [ COLLATE %s ] [ %s [ ( %s = %s [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )\n"
2553 : " [ INCLUDE ( %s [, ...] ) ]\n"
2554 : " [ NULLS [ NOT ] DISTINCT ]\n"
2555 : " [ WITH ( %s [= %s] [, ... ] ) ]\n"
2556 : " [ TABLESPACE %s ]\n"
2557 : " [ WHERE %s ]",
2558 : _("name"),
2559 : _("table_name"),
2560 : _("method"),
2561 : _("column_name"),
2562 : _("expression"),
2563 : _("collation"),
2564 : _("opclass"),
2565 : _("opclass_parameter"),
2566 : _("value"),
2567 : _("column_name"),
2568 : _("storage_parameter"),
2569 : _("value"),
2570 : _("tablespace_name"),
2571 : _("predicate"));
2572 0 : }
2573 :
2574 : static void
2575 0 : sql_help_CREATE_LANGUAGE(PQExpBuffer buf)
2576 : {
2577 0 : appendPQExpBuffer(buf,
2578 : "CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE %s\n"
2579 : " HANDLER %s [ INLINE %s ] [ VALIDATOR %s ]\n"
2580 : "CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE %s",
2581 : _("name"),
2582 : _("call_handler"),
2583 : _("inline_handler"),
2584 : _("valfunction"),
2585 : _("name"));
2586 0 : }
2587 :
2588 : static void
2589 0 : sql_help_CREATE_MATERIALIZED_VIEW(PQExpBuffer buf)
2590 : {
2591 0 : appendPQExpBuffer(buf,
2592 : "CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] %s\n"
2593 : " [ (%s [, ...] ) ]\n"
2594 : " [ USING %s ]\n"
2595 : " [ WITH ( %s [= %s] [, ... ] ) ]\n"
2596 : " [ TABLESPACE %s ]\n"
2597 : " AS %s\n"
2598 : " [ WITH [ NO ] DATA ]",
2599 : _("table_name"),
2600 : _("column_name"),
2601 : _("method"),
2602 : _("storage_parameter"),
2603 : _("value"),
2604 : _("tablespace_name"),
2605 : _("query"));
2606 0 : }
2607 :
2608 : static void
2609 0 : sql_help_CREATE_OPERATOR(PQExpBuffer buf)
2610 : {
2611 0 : appendPQExpBuffer(buf,
2612 : "CREATE OPERATOR %s (\n"
2613 : " {FUNCTION|PROCEDURE} = %s\n"
2614 : " [, LEFTARG = %s ] , RIGHTARG = %s\n"
2615 : " [, COMMUTATOR = %s ] [, NEGATOR = %s ]\n"
2616 : " [, RESTRICT = %s ] [, JOIN = %s ]\n"
2617 : " [, HASHES ] [, MERGES ]\n"
2618 : ")",
2619 : _("name"),
2620 : _("function_name"),
2621 : _("left_type"),
2622 : _("right_type"),
2623 : _("com_op"),
2624 : _("neg_op"),
2625 : _("res_proc"),
2626 : _("join_proc"));
2627 0 : }
2628 :
2629 : static void
2630 0 : sql_help_CREATE_OPERATOR_CLASS(PQExpBuffer buf)
2631 : {
2632 0 : appendPQExpBuffer(buf,
2633 : "CREATE OPERATOR CLASS %s [ DEFAULT ] FOR TYPE %s\n"
2634 : " USING %s [ FAMILY %s ] AS\n"
2635 : " { OPERATOR %s %s [ ( %s, %s ) ] [ FOR SEARCH | FOR ORDER BY %s ]\n"
2636 : " | FUNCTION %s [ ( %s [ , %s ] ) ] %s ( %s [, ...] )\n"
2637 : " | STORAGE %s\n"
2638 : " } [, ... ]",
2639 : _("name"),
2640 : _("data_type"),
2641 : _("index_method"),
2642 : _("family_name"),
2643 : _("strategy_number"),
2644 : _("operator_name"),
2645 : _("op_type"),
2646 : _("op_type"),
2647 : _("sort_family_name"),
2648 : _("support_number"),
2649 : _("op_type"),
2650 : _("op_type"),
2651 : _("function_name"),
2652 : _("argument_type"),
2653 : _("storage_type"));
2654 0 : }
2655 :
2656 : static void
2657 0 : sql_help_CREATE_OPERATOR_FAMILY(PQExpBuffer buf)
2658 : {
2659 0 : appendPQExpBuffer(buf,
2660 : "CREATE OPERATOR FAMILY %s USING %s",
2661 : _("name"),
2662 : _("index_method"));
2663 0 : }
2664 :
2665 : static void
2666 0 : sql_help_CREATE_POLICY(PQExpBuffer buf)
2667 : {
2668 0 : appendPQExpBuffer(buf,
2669 : "CREATE POLICY %s ON %s\n"
2670 : " [ AS { PERMISSIVE | RESTRICTIVE } ]\n"
2671 : " [ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ]\n"
2672 : " [ TO { %s | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] ]\n"
2673 : " [ USING ( %s ) ]\n"
2674 : " [ WITH CHECK ( %s ) ]",
2675 : _("name"),
2676 : _("table_name"),
2677 : _("role_name"),
2678 : _("using_expression"),
2679 : _("check_expression"));
2680 0 : }
2681 :
2682 : static void
2683 0 : sql_help_CREATE_PROCEDURE(PQExpBuffer buf)
2684 : {
2685 0 : appendPQExpBuffer(buf,
2686 : "CREATE [ OR REPLACE ] PROCEDURE\n"
2687 : " %s ( [ [ %s ] [ %s ] %s [ { DEFAULT | = } %s ] [, ...] ] )\n"
2688 : " { LANGUAGE %s\n"
2689 : " | TRANSFORM { FOR TYPE %s } [, ... ]\n"
2690 : " | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n"
2691 : " | SET %s { TO %s | = %s | FROM CURRENT }\n"
2692 : " | AS '%s'\n"
2693 : " | AS '%s', '%s'\n"
2694 : " | %s\n"
2695 : " } ...",
2696 : _("name"),
2697 : _("argmode"),
2698 : _("argname"),
2699 : _("argtype"),
2700 : _("default_expr"),
2701 : _("lang_name"),
2702 : _("type_name"),
2703 : _("configuration_parameter"),
2704 : _("value"),
2705 : _("value"),
2706 : _("definition"),
2707 : _("obj_file"),
2708 : _("link_symbol"),
2709 : _("sql_body"));
2710 0 : }
2711 :
2712 : static void
2713 0 : sql_help_CREATE_PUBLICATION(PQExpBuffer buf)
2714 : {
2715 0 : appendPQExpBuffer(buf,
2716 : "CREATE PUBLICATION %s\n"
2717 : " [ FOR { %s [, ... ] | %s [, ... ] } ]\n"
2718 : " [ WITH ( %s [= %s] [, ... ] ) ]\n"
2719 : "\n"
2720 : "%s\n"
2721 : "\n"
2722 : " TABLE %s [, ... ]\n"
2723 : " TABLES IN SCHEMA { %s | CURRENT_SCHEMA } [, ... ]\n"
2724 : "\n"
2725 : "%s\n"
2726 : "\n"
2727 : " ALL TABLES\n"
2728 : " ALL SEQUENCES\n"
2729 : "\n"
2730 : "%s\n"
2731 : "\n"
2732 : " [ ONLY ] %s [ * ] [ ( %s [, ... ] ) ] [ WHERE ( %s ) ]",
2733 : _("name"),
2734 : _("publication_object"),
2735 : _("publication_all_object"),
2736 : _("publication_parameter"),
2737 : _("value"),
2738 : _("where publication_object is one of:"),
2739 : _("table_and_columns"),
2740 : _("schema_name"),
2741 : _("and publication_all_object is one of:"),
2742 : _("and table_and_columns is:"),
2743 : _("table_name"),
2744 : _("column_name"),
2745 : _("expression"));
2746 0 : }
2747 :
2748 : static void
2749 0 : sql_help_CREATE_ROLE(PQExpBuffer buf)
2750 : {
2751 0 : appendPQExpBuffer(buf,
2752 : "CREATE ROLE %s [ [ WITH ] %s [ ... ] ]\n"
2753 : "\n"
2754 : "%s\n"
2755 : "\n"
2756 : " SUPERUSER | NOSUPERUSER\n"
2757 : " | CREATEDB | NOCREATEDB\n"
2758 : " | CREATEROLE | NOCREATEROLE\n"
2759 : " | INHERIT | NOINHERIT\n"
2760 : " | LOGIN | NOLOGIN\n"
2761 : " | REPLICATION | NOREPLICATION\n"
2762 : " | BYPASSRLS | NOBYPASSRLS\n"
2763 : " | CONNECTION LIMIT %s\n"
2764 : " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n"
2765 : " | VALID UNTIL '%s'\n"
2766 : " | IN ROLE %s [, ...]\n"
2767 : " | ROLE %s [, ...]\n"
2768 : " | ADMIN %s [, ...]\n"
2769 : " | SYSID %s",
2770 : _("name"),
2771 : _("option"),
2772 : _("where option can be:"),
2773 : _("connlimit"),
2774 : _("password"),
2775 : _("timestamp"),
2776 : _("role_name"),
2777 : _("role_name"),
2778 : _("role_name"),
2779 : _("uid"));
2780 0 : }
2781 :
2782 : static void
2783 0 : sql_help_CREATE_RULE(PQExpBuffer buf)
2784 : {
2785 0 : appendPQExpBuffer(buf,
2786 : "CREATE [ OR REPLACE ] RULE %s AS ON %s\n"
2787 : " TO %s [ WHERE %s ]\n"
2788 : " DO [ ALSO | INSTEAD ] { NOTHING | %s | ( %s ; %s ... ) }\n"
2789 : "\n"
2790 : "%s\n"
2791 : "\n"
2792 : " SELECT | INSERT | UPDATE | DELETE",
2793 : _("name"),
2794 : _("event"),
2795 : _("table_name"),
2796 : _("condition"),
2797 : _("command"),
2798 : _("command"),
2799 : _("command"),
2800 : _("where event can be one of:"));
2801 0 : }
2802 :
2803 : static void
2804 0 : sql_help_CREATE_SCHEMA(PQExpBuffer buf)
2805 : {
2806 0 : appendPQExpBuffer(buf,
2807 : "CREATE SCHEMA %s [ AUTHORIZATION %s ] [ %s [ ... ] ]\n"
2808 : "CREATE SCHEMA AUTHORIZATION %s [ %s [ ... ] ]\n"
2809 : "CREATE SCHEMA IF NOT EXISTS %s [ AUTHORIZATION %s ]\n"
2810 : "CREATE SCHEMA IF NOT EXISTS AUTHORIZATION %s\n"
2811 : "\n"
2812 : "%s\n"
2813 : "\n"
2814 : " %s\n"
2815 : " | CURRENT_ROLE\n"
2816 : " | CURRENT_USER\n"
2817 : " | SESSION_USER",
2818 : _("schema_name"),
2819 : _("role_specification"),
2820 : _("schema_element"),
2821 : _("role_specification"),
2822 : _("schema_element"),
2823 : _("schema_name"),
2824 : _("role_specification"),
2825 : _("role_specification"),
2826 : _("where role_specification can be:"),
2827 : _("user_name"));
2828 0 : }
2829 :
2830 : static void
2831 0 : sql_help_CREATE_SEQUENCE(PQExpBuffer buf)
2832 : {
2833 0 : appendPQExpBuffer(buf,
2834 : "CREATE [ { TEMPORARY | TEMP } | UNLOGGED ] SEQUENCE [ IF NOT EXISTS ] %s\n"
2835 : " [ AS %s ]\n"
2836 : " [ INCREMENT [ BY ] %s ]\n"
2837 : " [ MINVALUE %s | NO MINVALUE ] [ MAXVALUE %s | NO MAXVALUE ]\n"
2838 : " [ [ NO ] CYCLE ]\n"
2839 : " [ START [ WITH ] %s ]\n"
2840 : " [ CACHE %s ]\n"
2841 : " [ OWNED BY { %s.%s | NONE } ]",
2842 : _("name"),
2843 : _("data_type"),
2844 : _("increment"),
2845 : _("minvalue"),
2846 : _("maxvalue"),
2847 : _("start"),
2848 : _("cache"),
2849 : _("table_name"),
2850 : _("column_name"));
2851 0 : }
2852 :
2853 : static void
2854 0 : sql_help_CREATE_SERVER(PQExpBuffer buf)
2855 : {
2856 0 : appendPQExpBuffer(buf,
2857 : "CREATE SERVER [ IF NOT EXISTS ] %s [ TYPE '%s' ] [ VERSION '%s' ]\n"
2858 : " FOREIGN DATA WRAPPER %s\n"
2859 : " [ OPTIONS ( %s '%s' [, ... ] ) ]",
2860 : _("server_name"),
2861 : _("server_type"),
2862 : _("server_version"),
2863 : _("fdw_name"),
2864 : _("option"),
2865 : _("value"));
2866 0 : }
2867 :
2868 : static void
2869 0 : sql_help_CREATE_STATISTICS(PQExpBuffer buf)
2870 : {
2871 0 : appendPQExpBuffer(buf,
2872 : "CREATE STATISTICS [ [ IF NOT EXISTS ] %s ]\n"
2873 : " ON ( %s )\n"
2874 : " FROM %s\n"
2875 : "\n"
2876 : "CREATE STATISTICS [ [ IF NOT EXISTS ] %s ]\n"
2877 : " [ ( %s [, ... ] ) ]\n"
2878 : " ON { %s | ( %s ) }, { %s | ( %s ) } [, ...]\n"
2879 : " FROM %s",
2880 : _("statistics_name"),
2881 : _("expression"),
2882 : _("table_name"),
2883 : _("statistics_name"),
2884 : _("statistics_kind"),
2885 : _("column_name"),
2886 : _("expression"),
2887 : _("column_name"),
2888 : _("expression"),
2889 : _("table_name"));
2890 0 : }
2891 :
2892 : static void
2893 0 : sql_help_CREATE_SUBSCRIPTION(PQExpBuffer buf)
2894 : {
2895 0 : appendPQExpBuffer(buf,
2896 : "CREATE SUBSCRIPTION %s\n"
2897 : " CONNECTION '%s'\n"
2898 : " PUBLICATION %s [, ...]\n"
2899 : " [ WITH ( %s [= %s] [, ... ] ) ]",
2900 : _("subscription_name"),
2901 : _("conninfo"),
2902 : _("publication_name"),
2903 : _("subscription_parameter"),
2904 : _("value"));
2905 0 : }
2906 :
2907 : static void
2908 0 : sql_help_CREATE_TABLE(PQExpBuffer buf)
2909 : {
2910 0 : appendPQExpBuffer(buf,
2911 : "CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s ( [\n"
2912 : " { %s %s [ STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT } ] [ COMPRESSION %s ] [ COLLATE %s ] [ %s [ ... ] ]\n"
2913 : " | %s\n"
2914 : " | LIKE %s [ %s ... ] }\n"
2915 : " [, ... ]\n"
2916 : "] )\n"
2917 : "[ INHERITS ( %s [, ... ] ) ]\n"
2918 : "[ PARTITION BY { RANGE | LIST | HASH } ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [, ... ] ) ]\n"
2919 : "[ USING %s ]\n"
2920 : "[ WITH ( %s [= %s] [, ... ] ) | WITHOUT OIDS ]\n"
2921 : "[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n"
2922 : "[ TABLESPACE %s ]\n"
2923 : "\n"
2924 : "CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s\n"
2925 : " OF %s [ (\n"
2926 : " { %s [ WITH OPTIONS ] [ %s [ ... ] ]\n"
2927 : " | %s }\n"
2928 : " [, ... ]\n"
2929 : ") ]\n"
2930 : "[ PARTITION BY { RANGE | LIST | HASH } ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [, ... ] ) ]\n"
2931 : "[ USING %s ]\n"
2932 : "[ WITH ( %s [= %s] [, ... ] ) | WITHOUT OIDS ]\n"
2933 : "[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n"
2934 : "[ TABLESPACE %s ]\n"
2935 : "\n"
2936 : "CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s\n"
2937 : " PARTITION OF %s [ (\n"
2938 : " { %s [ WITH OPTIONS ] [ %s [ ... ] ]\n"
2939 : " | %s }\n"
2940 : " [, ... ]\n"
2941 : ") ] { FOR VALUES %s | DEFAULT }\n"
2942 : "[ PARTITION BY { RANGE | LIST | HASH } ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [, ... ] ) ]\n"
2943 : "[ USING %s ]\n"
2944 : "[ WITH ( %s [= %s] [, ... ] ) | WITHOUT OIDS ]\n"
2945 : "[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n"
2946 : "[ TABLESPACE %s ]\n"
2947 : "\n"
2948 : "%s\n"
2949 : "\n"
2950 : "[ CONSTRAINT %s ]\n"
2951 : "{ NOT NULL [ NO INHERIT ] |\n"
2952 : " NULL |\n"
2953 : " CHECK ( %s ) [ NO INHERIT ] |\n"
2954 : " DEFAULT %s |\n"
2955 : " GENERATED ALWAYS AS ( %s ) [ STORED | VIRTUAL ] |\n"
2956 : " GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( %s ) ] |\n"
2957 : " UNIQUE [ NULLS [ NOT ] DISTINCT ] %s |\n"
2958 : " PRIMARY KEY %s |\n"
2959 : " REFERENCES %s [ ( %s ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]\n"
2960 : " [ ON DELETE %s ] [ ON UPDATE %s ] }\n"
2961 : "[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [ ENFORCED | NOT ENFORCED ]\n"
2962 : "\n"
2963 : "%s\n"
2964 : "\n"
2965 : "[ CONSTRAINT %s ]\n"
2966 : "{ CHECK ( %s ) [ NO INHERIT ] |\n"
2967 : " NOT NULL %s [ NO INHERIT ] |\n"
2968 : " UNIQUE [ NULLS [ NOT ] DISTINCT ] ( %s [, ... ] [, %s WITHOUT OVERLAPS ] ) %s |\n"
2969 : " PRIMARY KEY ( %s [, ... ] [, %s WITHOUT OVERLAPS ] ) %s |\n"
2970 : " EXCLUDE [ USING %s ] ( %s WITH %s [, ... ] ) %s [ WHERE ( %s ) ] |\n"
2971 : " FOREIGN KEY ( %s [, ... ] [, PERIOD %s ] ) REFERENCES %s [ ( %s [, ... ] [, PERIOD %s ] ) ]\n"
2972 : " [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE %s ] [ ON UPDATE %s ] }\n"
2973 : "[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] [ ENFORCED | NOT ENFORCED ]\n"
2974 : "\n"
2975 : "%s\n"
2976 : "\n"
2977 : "{ INCLUDING | EXCLUDING } { COMMENTS | COMPRESSION | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }\n"
2978 : "\n"
2979 : "%s\n"
2980 : "\n"
2981 : "IN ( %s [, ...] ) |\n"
2982 : "FROM ( { %s | MINVALUE | MAXVALUE } [, ...] )\n"
2983 : " TO ( { %s | MINVALUE | MAXVALUE } [, ...] ) |\n"
2984 : "WITH ( MODULUS %s, REMAINDER %s )\n"
2985 : "\n"
2986 : "%s\n"
2987 : "\n"
2988 : "[ INCLUDE ( %s [, ... ] ) ]\n"
2989 : "[ WITH ( %s [= %s] [, ... ] ) ]\n"
2990 : "[ USING INDEX TABLESPACE %s ]\n"
2991 : "\n"
2992 : "%s\n"
2993 : "\n"
2994 : "{ %s | ( %s ) } [ COLLATE %s ] [ %s [ ( %s = %s [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]\n"
2995 : "\n"
2996 : "%s\n"
2997 : "\n"
2998 : "{ NO ACTION | RESTRICT | CASCADE | SET NULL [ ( %s [, ... ] ) ] | SET DEFAULT [ ( %s [, ... ] ) ] }",
2999 : _("table_name"),
3000 : _("column_name"),
3001 : _("data_type"),
3002 : _("compression_method"),
3003 : _("collation"),
3004 : _("column_constraint"),
3005 : _("table_constraint"),
3006 : _("source_table"),
3007 : _("like_option"),
3008 : _("parent_table"),
3009 : _("column_name"),
3010 : _("expression"),
3011 : _("collation"),
3012 : _("opclass"),
3013 : _("method"),
3014 : _("storage_parameter"),
3015 : _("value"),
3016 : _("tablespace_name"),
3017 : _("table_name"),
3018 : _("type_name"),
3019 : _("column_name"),
3020 : _("column_constraint"),
3021 : _("table_constraint"),
3022 : _("column_name"),
3023 : _("expression"),
3024 : _("collation"),
3025 : _("opclass"),
3026 : _("method"),
3027 : _("storage_parameter"),
3028 : _("value"),
3029 : _("tablespace_name"),
3030 : _("table_name"),
3031 : _("parent_table"),
3032 : _("column_name"),
3033 : _("column_constraint"),
3034 : _("table_constraint"),
3035 : _("partition_bound_spec"),
3036 : _("column_name"),
3037 : _("expression"),
3038 : _("collation"),
3039 : _("opclass"),
3040 : _("method"),
3041 : _("storage_parameter"),
3042 : _("value"),
3043 : _("tablespace_name"),
3044 : _("where column_constraint is:"),
3045 : _("constraint_name"),
3046 : _("expression"),
3047 : _("default_expr"),
3048 : _("generation_expr"),
3049 : _("sequence_options"),
3050 : _("index_parameters"),
3051 : _("index_parameters"),
3052 : _("reftable"),
3053 : _("refcolumn"),
3054 : _("referential_action"),
3055 : _("referential_action"),
3056 : _("and table_constraint is:"),
3057 : _("constraint_name"),
3058 : _("expression"),
3059 : _("column_name"),
3060 : _("column_name"),
3061 : _("column_name"),
3062 : _("index_parameters"),
3063 : _("column_name"),
3064 : _("column_name"),
3065 : _("index_parameters"),
3066 : _("index_method"),
3067 : _("exclude_element"),
3068 : _("operator"),
3069 : _("index_parameters"),
3070 : _("predicate"),
3071 : _("column_name"),
3072 : _("column_name"),
3073 : _("reftable"),
3074 : _("refcolumn"),
3075 : _("refcolumn"),
3076 : _("referential_action"),
3077 : _("referential_action"),
3078 : _("and like_option is:"),
3079 : _("and partition_bound_spec is:"),
3080 : _("partition_bound_expr"),
3081 : _("partition_bound_expr"),
3082 : _("partition_bound_expr"),
3083 : _("numeric_literal"),
3084 : _("numeric_literal"),
3085 : _("index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:"),
3086 : _("column_name"),
3087 : _("storage_parameter"),
3088 : _("value"),
3089 : _("tablespace_name"),
3090 : _("exclude_element in an EXCLUDE constraint is:"),
3091 : _("column_name"),
3092 : _("expression"),
3093 : _("collation"),
3094 : _("opclass"),
3095 : _("opclass_parameter"),
3096 : _("value"),
3097 : _("referential_action in a FOREIGN KEY/REFERENCES constraint is:"),
3098 : _("column_name"),
3099 : _("column_name"));
3100 0 : }
3101 :
3102 : static void
3103 0 : sql_help_CREATE_TABLE_AS(PQExpBuffer buf)
3104 : {
3105 0 : appendPQExpBuffer(buf,
3106 : "CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s\n"
3107 : " [ (%s [, ...] ) ]\n"
3108 : " [ USING %s ]\n"
3109 : " [ WITH ( %s [= %s] [, ... ] ) | WITHOUT OIDS ]\n"
3110 : " [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n"
3111 : " [ TABLESPACE %s ]\n"
3112 : " AS %s\n"
3113 : " [ WITH [ NO ] DATA ]",
3114 : _("table_name"),
3115 : _("column_name"),
3116 : _("method"),
3117 : _("storage_parameter"),
3118 : _("value"),
3119 : _("tablespace_name"),
3120 : _("query"));
3121 0 : }
3122 :
3123 : static void
3124 0 : sql_help_CREATE_TABLESPACE(PQExpBuffer buf)
3125 : {
3126 0 : appendPQExpBuffer(buf,
3127 : "CREATE TABLESPACE %s\n"
3128 : " [ OWNER { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ]\n"
3129 : " LOCATION '%s'\n"
3130 : " [ WITH ( %s = %s [, ... ] ) ]",
3131 : _("tablespace_name"),
3132 : _("new_owner"),
3133 : _("directory"),
3134 : _("tablespace_option"),
3135 : _("value"));
3136 0 : }
3137 :
3138 : static void
3139 0 : sql_help_CREATE_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf)
3140 : {
3141 0 : appendPQExpBuffer(buf,
3142 : "CREATE TEXT SEARCH CONFIGURATION %s (\n"
3143 : " PARSER = %s |\n"
3144 : " COPY = %s\n"
3145 : ")",
3146 : _("name"),
3147 : _("parser_name"),
3148 : _("source_config"));
3149 0 : }
3150 :
3151 : static void
3152 0 : sql_help_CREATE_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf)
3153 : {
3154 0 : appendPQExpBuffer(buf,
3155 : "CREATE TEXT SEARCH DICTIONARY %s (\n"
3156 : " TEMPLATE = %s\n"
3157 : " [, %s = %s [, ... ]]\n"
3158 : ")",
3159 : _("name"),
3160 : _("template"),
3161 : _("option"),
3162 : _("value"));
3163 0 : }
3164 :
3165 : static void
3166 0 : sql_help_CREATE_TEXT_SEARCH_PARSER(PQExpBuffer buf)
3167 : {
3168 0 : appendPQExpBuffer(buf,
3169 : "CREATE TEXT SEARCH PARSER %s (\n"
3170 : " START = %s ,\n"
3171 : " GETTOKEN = %s ,\n"
3172 : " END = %s ,\n"
3173 : " LEXTYPES = %s\n"
3174 : " [, HEADLINE = %s ]\n"
3175 : ")",
3176 : _("name"),
3177 : _("start_function"),
3178 : _("gettoken_function"),
3179 : _("end_function"),
3180 : _("lextypes_function"),
3181 : _("headline_function"));
3182 0 : }
3183 :
3184 : static void
3185 0 : sql_help_CREATE_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf)
3186 : {
3187 0 : appendPQExpBuffer(buf,
3188 : "CREATE TEXT SEARCH TEMPLATE %s (\n"
3189 : " [ INIT = %s , ]\n"
3190 : " LEXIZE = %s\n"
3191 : ")",
3192 : _("name"),
3193 : _("init_function"),
3194 : _("lexize_function"));
3195 0 : }
3196 :
3197 : static void
3198 0 : sql_help_CREATE_TRANSFORM(PQExpBuffer buf)
3199 : {
3200 0 : appendPQExpBuffer(buf,
3201 : "CREATE [ OR REPLACE ] TRANSFORM FOR %s LANGUAGE %s (\n"
3202 : " FROM SQL WITH FUNCTION %s [ (%s [, ...]) ],\n"
3203 : " TO SQL WITH FUNCTION %s [ (%s [, ...]) ]\n"
3204 : ");",
3205 : _("type_name"),
3206 : _("lang_name"),
3207 : _("from_sql_function_name"),
3208 : _("argument_type"),
3209 : _("to_sql_function_name"),
3210 : _("argument_type"));
3211 0 : }
3212 :
3213 : static void
3214 0 : sql_help_CREATE_TRIGGER(PQExpBuffer buf)
3215 : {
3216 0 : appendPQExpBuffer(buf,
3217 : "CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER %s { BEFORE | AFTER | INSTEAD OF } { %s [ OR ... ] }\n"
3218 : " ON %s\n"
3219 : " [ FROM %s ]\n"
3220 : " [ NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ] ] [ ENFORCED ]\n"
3221 : " [ REFERENCING { { OLD | NEW } TABLE [ AS ] %s } [ ... ] ]\n"
3222 : " [ FOR [ EACH ] { ROW | STATEMENT } ]\n"
3223 : " [ WHEN ( %s ) ]\n"
3224 : " EXECUTE { FUNCTION | PROCEDURE } %s ( %s )\n"
3225 : "\n"
3226 : "%s\n"
3227 : "\n"
3228 : " INSERT\n"
3229 : " UPDATE [ OF %s [, ... ] ]\n"
3230 : " DELETE\n"
3231 : " TRUNCATE",
3232 : _("name"),
3233 : _("event"),
3234 : _("table_name"),
3235 : _("referenced_table_name"),
3236 : _("transition_relation_name"),
3237 : _("condition"),
3238 : _("function_name"),
3239 : _("arguments"),
3240 : _("where event can be one of:"),
3241 : _("column_name"));
3242 0 : }
3243 :
3244 : static void
3245 0 : sql_help_CREATE_TYPE(PQExpBuffer buf)
3246 : {
3247 0 : appendPQExpBuffer(buf,
3248 : "CREATE TYPE %s AS\n"
3249 : " ( [ %s %s [ COLLATE %s ] [, ... ] ] )\n"
3250 : "\n"
3251 : "CREATE TYPE %s AS ENUM\n"
3252 : " ( [ '%s' [, ... ] ] )\n"
3253 : "\n"
3254 : "CREATE TYPE %s AS RANGE (\n"
3255 : " SUBTYPE = %s\n"
3256 : " [ , SUBTYPE_OPCLASS = %s ]\n"
3257 : " [ , COLLATION = %s ]\n"
3258 : " [ , CANONICAL = %s ]\n"
3259 : " [ , SUBTYPE_DIFF = %s ]\n"
3260 : " [ , MULTIRANGE_TYPE_NAME = %s ]\n"
3261 : ")\n"
3262 : "\n"
3263 : "CREATE TYPE %s (\n"
3264 : " INPUT = %s,\n"
3265 : " OUTPUT = %s\n"
3266 : " [ , RECEIVE = %s ]\n"
3267 : " [ , SEND = %s ]\n"
3268 : " [ , TYPMOD_IN = %s ]\n"
3269 : " [ , TYPMOD_OUT = %s ]\n"
3270 : " [ , ANALYZE = %s ]\n"
3271 : " [ , SUBSCRIPT = %s ]\n"
3272 : " [ , INTERNALLENGTH = { %s | VARIABLE } ]\n"
3273 : " [ , PASSEDBYVALUE ]\n"
3274 : " [ , ALIGNMENT = %s ]\n"
3275 : " [ , STORAGE = %s ]\n"
3276 : " [ , LIKE = %s ]\n"
3277 : " [ , CATEGORY = %s ]\n"
3278 : " [ , PREFERRED = %s ]\n"
3279 : " [ , DEFAULT = %s ]\n"
3280 : " [ , ELEMENT = %s ]\n"
3281 : " [ , DELIMITER = %s ]\n"
3282 : " [ , COLLATABLE = %s ]\n"
3283 : ")\n"
3284 : "\n"
3285 : "CREATE TYPE %s",
3286 : _("name"),
3287 : _("attribute_name"),
3288 : _("data_type"),
3289 : _("collation"),
3290 : _("name"),
3291 : _("label"),
3292 : _("name"),
3293 : _("subtype"),
3294 : _("subtype_operator_class"),
3295 : _("collation"),
3296 : _("canonical_function"),
3297 : _("subtype_diff_function"),
3298 : _("multirange_type_name"),
3299 : _("name"),
3300 : _("input_function"),
3301 : _("output_function"),
3302 : _("receive_function"),
3303 : _("send_function"),
3304 : _("type_modifier_input_function"),
3305 : _("type_modifier_output_function"),
3306 : _("analyze_function"),
3307 : _("subscript_function"),
3308 : _("internallength"),
3309 : _("alignment"),
3310 : _("storage"),
3311 : _("like_type"),
3312 : _("category"),
3313 : _("preferred"),
3314 : _("default"),
3315 : _("element"),
3316 : _("delimiter"),
3317 : _("collatable"),
3318 : _("name"));
3319 0 : }
3320 :
3321 : static void
3322 0 : sql_help_CREATE_USER(PQExpBuffer buf)
3323 : {
3324 0 : appendPQExpBuffer(buf,
3325 : "CREATE USER %s [ [ WITH ] %s [ ... ] ]\n"
3326 : "\n"
3327 : "%s\n"
3328 : "\n"
3329 : " SUPERUSER | NOSUPERUSER\n"
3330 : " | CREATEDB | NOCREATEDB\n"
3331 : " | CREATEROLE | NOCREATEROLE\n"
3332 : " | INHERIT | NOINHERIT\n"
3333 : " | LOGIN | NOLOGIN\n"
3334 : " | REPLICATION | NOREPLICATION\n"
3335 : " | BYPASSRLS | NOBYPASSRLS\n"
3336 : " | CONNECTION LIMIT %s\n"
3337 : " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n"
3338 : " | VALID UNTIL '%s'\n"
3339 : " | IN ROLE %s [, ...]\n"
3340 : " | ROLE %s [, ...]\n"
3341 : " | ADMIN %s [, ...]\n"
3342 : " | SYSID %s",
3343 : _("name"),
3344 : _("option"),
3345 : _("where option can be:"),
3346 : _("connlimit"),
3347 : _("password"),
3348 : _("timestamp"),
3349 : _("role_name"),
3350 : _("role_name"),
3351 : _("role_name"),
3352 : _("uid"));
3353 0 : }
3354 :
3355 : static void
3356 0 : sql_help_CREATE_USER_MAPPING(PQExpBuffer buf)
3357 : {
3358 0 : appendPQExpBuffer(buf,
3359 : "CREATE USER MAPPING [ IF NOT EXISTS ] FOR { %s | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC }\n"
3360 : " SERVER %s\n"
3361 : " [ OPTIONS ( %s '%s' [ , ... ] ) ]",
3362 : _("user_name"),
3363 : _("server_name"),
3364 : _("option"),
3365 : _("value"));
3366 0 : }
3367 :
3368 : static void
3369 0 : sql_help_CREATE_VIEW(PQExpBuffer buf)
3370 : {
3371 0 : appendPQExpBuffer(buf,
3372 : "CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW %s [ ( %s [, ...] ) ]\n"
3373 : " [ WITH ( %s [= %s] [, ... ] ) ]\n"
3374 : " AS %s\n"
3375 : " [ WITH [ CASCADED | LOCAL ] CHECK OPTION ]",
3376 : _("name"),
3377 : _("column_name"),
3378 : _("view_option_name"),
3379 : _("view_option_value"),
3380 : _("query"));
3381 0 : }
3382 :
3383 : static void
3384 0 : sql_help_DEALLOCATE(PQExpBuffer buf)
3385 : {
3386 0 : appendPQExpBuffer(buf,
3387 : "DEALLOCATE [ PREPARE ] { %s | ALL }",
3388 : _("name"));
3389 0 : }
3390 :
3391 : static void
3392 0 : sql_help_DECLARE(PQExpBuffer buf)
3393 : {
3394 0 : appendPQExpBuffer(buf,
3395 : "DECLARE %s [ BINARY ] [ ASENSITIVE | INSENSITIVE ] [ [ NO ] SCROLL ]\n"
3396 : " CURSOR [ { WITH | WITHOUT } HOLD ] FOR %s",
3397 : _("name"),
3398 : _("query"));
3399 0 : }
3400 :
3401 : static void
3402 0 : sql_help_DELETE(PQExpBuffer buf)
3403 : {
3404 0 : appendPQExpBuffer(buf,
3405 : "[ WITH [ RECURSIVE ] %s [, ...] ]\n"
3406 : "DELETE FROM [ ONLY ] %s [ * ] [ [ AS ] %s ]\n"
3407 : " [ USING %s [, ...] ]\n"
3408 : " [ WHERE %s | WHERE CURRENT OF %s ]\n"
3409 : " [ RETURNING [ WITH ( { OLD | NEW } AS %s [, ...] ) ]\n"
3410 : " { * | %s [ [ AS ] %s ] } [, ...] ]",
3411 : _("with_query"),
3412 : _("table_name"),
3413 : _("alias"),
3414 : _("from_item"),
3415 : _("condition"),
3416 : _("cursor_name"),
3417 : _("output_alias"),
3418 : _("output_expression"),
3419 : _("output_name"));
3420 0 : }
3421 :
3422 : static void
3423 0 : sql_help_DISCARD(PQExpBuffer buf)
3424 : {
3425 0 : appendPQExpBuffer(buf,
3426 : "DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }");
3427 0 : }
3428 :
3429 : static void
3430 0 : sql_help_DO(PQExpBuffer buf)
3431 : {
3432 0 : appendPQExpBuffer(buf,
3433 : "DO [ LANGUAGE %s ] %s",
3434 : _("lang_name"),
3435 : _("code"));
3436 0 : }
3437 :
3438 : static void
3439 0 : sql_help_DROP_ACCESS_METHOD(PQExpBuffer buf)
3440 : {
3441 0 : appendPQExpBuffer(buf,
3442 : "DROP ACCESS METHOD [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3443 : _("name"));
3444 0 : }
3445 :
3446 : static void
3447 0 : sql_help_DROP_AGGREGATE(PQExpBuffer buf)
3448 : {
3449 0 : appendPQExpBuffer(buf,
3450 : "DROP AGGREGATE [ IF EXISTS ] %s ( %s ) [, ...] [ CASCADE | RESTRICT ]\n"
3451 : "\n"
3452 : "%s\n"
3453 : "\n"
3454 : "* |\n"
3455 : "[ %s ] [ %s ] %s [ , ... ] |\n"
3456 : "[ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ]",
3457 : _("name"),
3458 : _("aggregate_signature"),
3459 : _("where aggregate_signature is:"),
3460 : _("argmode"),
3461 : _("argname"),
3462 : _("argtype"),
3463 : _("argmode"),
3464 : _("argname"),
3465 : _("argtype"),
3466 : _("argmode"),
3467 : _("argname"),
3468 : _("argtype"));
3469 0 : }
3470 :
3471 : static void
3472 0 : sql_help_DROP_CAST(PQExpBuffer buf)
3473 : {
3474 0 : appendPQExpBuffer(buf,
3475 : "DROP CAST [ IF EXISTS ] (%s AS %s) [ CASCADE | RESTRICT ]",
3476 : _("source_type"),
3477 : _("target_type"));
3478 0 : }
3479 :
3480 : static void
3481 0 : sql_help_DROP_COLLATION(PQExpBuffer buf)
3482 : {
3483 0 : appendPQExpBuffer(buf,
3484 : "DROP COLLATION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3485 : _("name"));
3486 0 : }
3487 :
3488 : static void
3489 0 : sql_help_DROP_CONVERSION(PQExpBuffer buf)
3490 : {
3491 0 : appendPQExpBuffer(buf,
3492 : "DROP CONVERSION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3493 : _("name"));
3494 0 : }
3495 :
3496 : static void
3497 0 : sql_help_DROP_DATABASE(PQExpBuffer buf)
3498 : {
3499 0 : appendPQExpBuffer(buf,
3500 : "DROP DATABASE [ IF EXISTS ] %s [ [ WITH ] ( %s [, ...] ) ]\n"
3501 : "\n"
3502 : "%s\n"
3503 : "\n"
3504 : " FORCE",
3505 : _("name"),
3506 : _("option"),
3507 : _("where option can be:"));
3508 0 : }
3509 :
3510 : static void
3511 0 : sql_help_DROP_DOMAIN(PQExpBuffer buf)
3512 : {
3513 0 : appendPQExpBuffer(buf,
3514 : "DROP DOMAIN [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3515 : _("name"));
3516 0 : }
3517 :
3518 : static void
3519 0 : sql_help_DROP_EVENT_TRIGGER(PQExpBuffer buf)
3520 : {
3521 0 : appendPQExpBuffer(buf,
3522 : "DROP EVENT TRIGGER [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3523 : _("name"));
3524 0 : }
3525 :
3526 : static void
3527 0 : sql_help_DROP_EXTENSION(PQExpBuffer buf)
3528 : {
3529 0 : appendPQExpBuffer(buf,
3530 : "DROP EXTENSION [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3531 : _("name"));
3532 0 : }
3533 :
3534 : static void
3535 0 : sql_help_DROP_FOREIGN_DATA_WRAPPER(PQExpBuffer buf)
3536 : {
3537 0 : appendPQExpBuffer(buf,
3538 : "DROP FOREIGN DATA WRAPPER [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3539 : _("name"));
3540 0 : }
3541 :
3542 : static void
3543 0 : sql_help_DROP_FOREIGN_TABLE(PQExpBuffer buf)
3544 : {
3545 0 : appendPQExpBuffer(buf,
3546 : "DROP FOREIGN TABLE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3547 : _("name"));
3548 0 : }
3549 :
3550 : static void
3551 0 : sql_help_DROP_FUNCTION(PQExpBuffer buf)
3552 : {
3553 0 : appendPQExpBuffer(buf,
3554 : "DROP FUNCTION [ IF EXISTS ] %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n"
3555 : " [ CASCADE | RESTRICT ]",
3556 : _("name"),
3557 : _("argmode"),
3558 : _("argname"),
3559 : _("argtype"));
3560 0 : }
3561 :
3562 : static void
3563 0 : sql_help_DROP_GROUP(PQExpBuffer buf)
3564 : {
3565 0 : appendPQExpBuffer(buf,
3566 : "DROP GROUP [ IF EXISTS ] %s [, ...]",
3567 : _("name"));
3568 0 : }
3569 :
3570 : static void
3571 0 : sql_help_DROP_INDEX(PQExpBuffer buf)
3572 : {
3573 0 : appendPQExpBuffer(buf,
3574 : "DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3575 : _("name"));
3576 0 : }
3577 :
3578 : static void
3579 0 : sql_help_DROP_LANGUAGE(PQExpBuffer buf)
3580 : {
3581 0 : appendPQExpBuffer(buf,
3582 : "DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3583 : _("name"));
3584 0 : }
3585 :
3586 : static void
3587 0 : sql_help_DROP_MATERIALIZED_VIEW(PQExpBuffer buf)
3588 : {
3589 0 : appendPQExpBuffer(buf,
3590 : "DROP MATERIALIZED VIEW [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3591 : _("name"));
3592 0 : }
3593 :
3594 : static void
3595 0 : sql_help_DROP_OPERATOR(PQExpBuffer buf)
3596 : {
3597 0 : appendPQExpBuffer(buf,
3598 : "DROP OPERATOR [ IF EXISTS ] %s ( { %s | NONE } , %s ) [, ...] [ CASCADE | RESTRICT ]",
3599 : _("name"),
3600 : _("left_type"),
3601 : _("right_type"));
3602 0 : }
3603 :
3604 : static void
3605 0 : sql_help_DROP_OPERATOR_CLASS(PQExpBuffer buf)
3606 : {
3607 0 : appendPQExpBuffer(buf,
3608 : "DROP OPERATOR CLASS [ IF EXISTS ] %s USING %s [ CASCADE | RESTRICT ]",
3609 : _("name"),
3610 : _("index_method"));
3611 0 : }
3612 :
3613 : static void
3614 0 : sql_help_DROP_OPERATOR_FAMILY(PQExpBuffer buf)
3615 : {
3616 0 : appendPQExpBuffer(buf,
3617 : "DROP OPERATOR FAMILY [ IF EXISTS ] %s USING %s [ CASCADE | RESTRICT ]",
3618 : _("name"),
3619 : _("index_method"));
3620 0 : }
3621 :
3622 : static void
3623 0 : sql_help_DROP_OWNED(PQExpBuffer buf)
3624 : {
3625 0 : appendPQExpBuffer(buf,
3626 : "DROP OWNED BY { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ]",
3627 : _("name"));
3628 0 : }
3629 :
3630 : static void
3631 0 : sql_help_DROP_POLICY(PQExpBuffer buf)
3632 : {
3633 0 : appendPQExpBuffer(buf,
3634 : "DROP POLICY [ IF EXISTS ] %s ON %s [ CASCADE | RESTRICT ]",
3635 : _("name"),
3636 : _("table_name"));
3637 0 : }
3638 :
3639 : static void
3640 0 : sql_help_DROP_PROCEDURE(PQExpBuffer buf)
3641 : {
3642 0 : appendPQExpBuffer(buf,
3643 : "DROP PROCEDURE [ IF EXISTS ] %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n"
3644 : " [ CASCADE | RESTRICT ]",
3645 : _("name"),
3646 : _("argmode"),
3647 : _("argname"),
3648 : _("argtype"));
3649 0 : }
3650 :
3651 : static void
3652 0 : sql_help_DROP_PUBLICATION(PQExpBuffer buf)
3653 : {
3654 0 : appendPQExpBuffer(buf,
3655 : "DROP PUBLICATION [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3656 : _("name"));
3657 0 : }
3658 :
3659 : static void
3660 0 : sql_help_DROP_ROLE(PQExpBuffer buf)
3661 : {
3662 0 : appendPQExpBuffer(buf,
3663 : "DROP ROLE [ IF EXISTS ] %s [, ...]",
3664 : _("name"));
3665 0 : }
3666 :
3667 : static void
3668 0 : sql_help_DROP_ROUTINE(PQExpBuffer buf)
3669 : {
3670 0 : appendPQExpBuffer(buf,
3671 : "DROP ROUTINE [ IF EXISTS ] %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n"
3672 : " [ CASCADE | RESTRICT ]",
3673 : _("name"),
3674 : _("argmode"),
3675 : _("argname"),
3676 : _("argtype"));
3677 0 : }
3678 :
3679 : static void
3680 0 : sql_help_DROP_RULE(PQExpBuffer buf)
3681 : {
3682 0 : appendPQExpBuffer(buf,
3683 : "DROP RULE [ IF EXISTS ] %s ON %s [ CASCADE | RESTRICT ]",
3684 : _("name"),
3685 : _("table_name"));
3686 0 : }
3687 :
3688 : static void
3689 0 : sql_help_DROP_SCHEMA(PQExpBuffer buf)
3690 : {
3691 0 : appendPQExpBuffer(buf,
3692 : "DROP SCHEMA [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3693 : _("name"));
3694 0 : }
3695 :
3696 : static void
3697 0 : sql_help_DROP_SEQUENCE(PQExpBuffer buf)
3698 : {
3699 0 : appendPQExpBuffer(buf,
3700 : "DROP SEQUENCE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3701 : _("name"));
3702 0 : }
3703 :
3704 : static void
3705 0 : sql_help_DROP_SERVER(PQExpBuffer buf)
3706 : {
3707 0 : appendPQExpBuffer(buf,
3708 : "DROP SERVER [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3709 : _("name"));
3710 0 : }
3711 :
3712 : static void
3713 0 : sql_help_DROP_STATISTICS(PQExpBuffer buf)
3714 : {
3715 0 : appendPQExpBuffer(buf,
3716 : "DROP STATISTICS [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3717 : _("name"));
3718 0 : }
3719 :
3720 : static void
3721 0 : sql_help_DROP_SUBSCRIPTION(PQExpBuffer buf)
3722 : {
3723 0 : appendPQExpBuffer(buf,
3724 : "DROP SUBSCRIPTION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3725 : _("name"));
3726 0 : }
3727 :
3728 : static void
3729 0 : sql_help_DROP_TABLE(PQExpBuffer buf)
3730 : {
3731 0 : appendPQExpBuffer(buf,
3732 : "DROP TABLE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3733 : _("name"));
3734 0 : }
3735 :
3736 : static void
3737 0 : sql_help_DROP_TABLESPACE(PQExpBuffer buf)
3738 : {
3739 0 : appendPQExpBuffer(buf,
3740 : "DROP TABLESPACE [ IF EXISTS ] %s",
3741 : _("name"));
3742 0 : }
3743 :
3744 : static void
3745 0 : sql_help_DROP_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf)
3746 : {
3747 0 : appendPQExpBuffer(buf,
3748 : "DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3749 : _("name"));
3750 0 : }
3751 :
3752 : static void
3753 0 : sql_help_DROP_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf)
3754 : {
3755 0 : appendPQExpBuffer(buf,
3756 : "DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3757 : _("name"));
3758 0 : }
3759 :
3760 : static void
3761 0 : sql_help_DROP_TEXT_SEARCH_PARSER(PQExpBuffer buf)
3762 : {
3763 0 : appendPQExpBuffer(buf,
3764 : "DROP TEXT SEARCH PARSER [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3765 : _("name"));
3766 0 : }
3767 :
3768 : static void
3769 0 : sql_help_DROP_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf)
3770 : {
3771 0 : appendPQExpBuffer(buf,
3772 : "DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]",
3773 : _("name"));
3774 0 : }
3775 :
3776 : static void
3777 0 : sql_help_DROP_TRANSFORM(PQExpBuffer buf)
3778 : {
3779 0 : appendPQExpBuffer(buf,
3780 : "DROP TRANSFORM [ IF EXISTS ] FOR %s LANGUAGE %s [ CASCADE | RESTRICT ]",
3781 : _("type_name"),
3782 : _("lang_name"));
3783 0 : }
3784 :
3785 : static void
3786 0 : sql_help_DROP_TRIGGER(PQExpBuffer buf)
3787 : {
3788 0 : appendPQExpBuffer(buf,
3789 : "DROP TRIGGER [ IF EXISTS ] %s ON %s [ CASCADE | RESTRICT ]",
3790 : _("name"),
3791 : _("table_name"));
3792 0 : }
3793 :
3794 : static void
3795 0 : sql_help_DROP_TYPE(PQExpBuffer buf)
3796 : {
3797 0 : appendPQExpBuffer(buf,
3798 : "DROP TYPE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3799 : _("name"));
3800 0 : }
3801 :
3802 : static void
3803 0 : sql_help_DROP_USER(PQExpBuffer buf)
3804 : {
3805 0 : appendPQExpBuffer(buf,
3806 : "DROP USER [ IF EXISTS ] %s [, ...]",
3807 : _("name"));
3808 0 : }
3809 :
3810 : static void
3811 0 : sql_help_DROP_USER_MAPPING(PQExpBuffer buf)
3812 : {
3813 0 : appendPQExpBuffer(buf,
3814 : "DROP USER MAPPING [ IF EXISTS ] FOR { %s | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC } SERVER %s",
3815 : _("user_name"),
3816 : _("server_name"));
3817 0 : }
3818 :
3819 : static void
3820 0 : sql_help_DROP_VIEW(PQExpBuffer buf)
3821 : {
3822 0 : appendPQExpBuffer(buf,
3823 : "DROP VIEW [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]",
3824 : _("name"));
3825 0 : }
3826 :
3827 : static void
3828 0 : sql_help_END(PQExpBuffer buf)
3829 : {
3830 0 : appendPQExpBuffer(buf,
3831 : "END [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]");
3832 0 : }
3833 :
3834 : static void
3835 0 : sql_help_EXECUTE(PQExpBuffer buf)
3836 : {
3837 0 : appendPQExpBuffer(buf,
3838 : "EXECUTE %s [ ( %s [, ...] ) ]",
3839 : _("name"),
3840 : _("parameter"));
3841 0 : }
3842 :
3843 : static void
3844 0 : sql_help_EXPLAIN(PQExpBuffer buf)
3845 : {
3846 0 : appendPQExpBuffer(buf,
3847 : "EXPLAIN [ ( %s [, ...] ) ] %s\n"
3848 : "\n"
3849 : "%s\n"
3850 : "\n"
3851 : " ANALYZE [ %s ]\n"
3852 : " VERBOSE [ %s ]\n"
3853 : " COSTS [ %s ]\n"
3854 : " SETTINGS [ %s ]\n"
3855 : " GENERIC_PLAN [ %s ]\n"
3856 : " BUFFERS [ %s ]\n"
3857 : " SERIALIZE [ { NONE | TEXT | BINARY } ]\n"
3858 : " WAL [ %s ]\n"
3859 : " TIMING [ %s ]\n"
3860 : " SUMMARY [ %s ]\n"
3861 : " MEMORY [ %s ]\n"
3862 : " FORMAT { TEXT | XML | JSON | YAML }",
3863 : _("option"),
3864 : _("statement"),
3865 : _("where option can be one of:"),
3866 : _("boolean"),
3867 : _("boolean"),
3868 : _("boolean"),
3869 : _("boolean"),
3870 : _("boolean"),
3871 : _("boolean"),
3872 : _("boolean"),
3873 : _("boolean"),
3874 : _("boolean"),
3875 : _("boolean"));
3876 0 : }
3877 :
3878 : static void
3879 0 : sql_help_FETCH(PQExpBuffer buf)
3880 : {
3881 0 : appendPQExpBuffer(buf,
3882 : "FETCH [ %s ] [ FROM | IN ] %s\n"
3883 : "\n"
3884 : "%s\n"
3885 : "\n"
3886 : " NEXT\n"
3887 : " PRIOR\n"
3888 : " FIRST\n"
3889 : " LAST\n"
3890 : " ABSOLUTE %s\n"
3891 : " RELATIVE %s\n"
3892 : " %s\n"
3893 : " ALL\n"
3894 : " FORWARD\n"
3895 : " FORWARD %s\n"
3896 : " FORWARD ALL\n"
3897 : " BACKWARD\n"
3898 : " BACKWARD %s\n"
3899 : " BACKWARD ALL",
3900 : _("direction"),
3901 : _("cursor_name"),
3902 : _("where direction can be one of:"),
3903 : _("count"),
3904 : _("count"),
3905 : _("count"),
3906 : _("count"),
3907 : _("count"));
3908 0 : }
3909 :
3910 : static void
3911 0 : sql_help_GRANT(PQExpBuffer buf)
3912 : {
3913 0 : appendPQExpBuffer(buf,
3914 : "GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN }\n"
3915 : " [, ...] | ALL [ PRIVILEGES ] }\n"
3916 : " ON { [ TABLE ] %s [, ...]\n"
3917 : " | ALL TABLES IN SCHEMA %s [, ...] }\n"
3918 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3919 : " [ GRANTED BY %s ]\n"
3920 : "\n"
3921 : "GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( %s [, ...] )\n"
3922 : " [, ...] | ALL [ PRIVILEGES ] ( %s [, ...] ) }\n"
3923 : " ON [ TABLE ] %s [, ...]\n"
3924 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3925 : " [ GRANTED BY %s ]\n"
3926 : "\n"
3927 : "GRANT { { USAGE | SELECT | UPDATE }\n"
3928 : " [, ...] | ALL [ PRIVILEGES ] }\n"
3929 : " ON { SEQUENCE %s [, ...]\n"
3930 : " | ALL SEQUENCES IN SCHEMA %s [, ...] }\n"
3931 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3932 : " [ GRANTED BY %s ]\n"
3933 : "\n"
3934 : "GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }\n"
3935 : " ON DATABASE %s [, ...]\n"
3936 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3937 : " [ GRANTED BY %s ]\n"
3938 : "\n"
3939 : "GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
3940 : " ON DOMAIN %s [, ...]\n"
3941 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3942 : " [ GRANTED BY %s ]\n"
3943 : "\n"
3944 : "GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
3945 : " ON FOREIGN DATA WRAPPER %s [, ...]\n"
3946 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3947 : " [ GRANTED BY %s ]\n"
3948 : "\n"
3949 : "GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
3950 : " ON FOREIGN SERVER %s [, ...]\n"
3951 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3952 : " [ GRANTED BY %s ]\n"
3953 : "\n"
3954 : "GRANT { EXECUTE | ALL [ PRIVILEGES ] }\n"
3955 : " ON { { FUNCTION | PROCEDURE | ROUTINE } %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n"
3956 : " | ALL { FUNCTIONS | PROCEDURES | ROUTINES } IN SCHEMA %s [, ...] }\n"
3957 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3958 : " [ GRANTED BY %s ]\n"
3959 : "\n"
3960 : "GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
3961 : " ON LANGUAGE %s [, ...]\n"
3962 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3963 : " [ GRANTED BY %s ]\n"
3964 : "\n"
3965 : "GRANT { { SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] }\n"
3966 : " ON LARGE OBJECT %s [, ...]\n"
3967 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3968 : " [ GRANTED BY %s ]\n"
3969 : "\n"
3970 : "GRANT { { SET | ALTER SYSTEM } [, ... ] | ALL [ PRIVILEGES ] }\n"
3971 : " ON PARAMETER %s [, ...]\n"
3972 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3973 : " [ GRANTED BY %s ]\n"
3974 : "\n"
3975 : "GRANT { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }\n"
3976 : " ON SCHEMA %s [, ...]\n"
3977 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3978 : " [ GRANTED BY %s ]\n"
3979 : "\n"
3980 : "GRANT { CREATE | ALL [ PRIVILEGES ] }\n"
3981 : " ON TABLESPACE %s [, ...]\n"
3982 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3983 : " [ GRANTED BY %s ]\n"
3984 : "\n"
3985 : "GRANT { USAGE | ALL [ PRIVILEGES ] }\n"
3986 : " ON TYPE %s [, ...]\n"
3987 : " TO %s [, ...] [ WITH GRANT OPTION ]\n"
3988 : " [ GRANTED BY %s ]\n"
3989 : "\n"
3990 : "GRANT %s [, ...] TO %s [, ...]\n"
3991 : " [ WITH { ADMIN | INHERIT | SET } { OPTION | TRUE | FALSE } ]\n"
3992 : " [ GRANTED BY %s ]\n"
3993 : "\n"
3994 : "%s\n"
3995 : "\n"
3996 : " [ GROUP ] %s\n"
3997 : " | PUBLIC\n"
3998 : " | CURRENT_ROLE\n"
3999 : " | CURRENT_USER\n"
4000 : " | SESSION_USER",
4001 : _("table_name"),
4002 : _("schema_name"),
4003 : _("role_specification"),
4004 : _("role_specification"),
4005 : _("column_name"),
4006 : _("column_name"),
4007 : _("table_name"),
4008 : _("role_specification"),
4009 : _("role_specification"),
4010 : _("sequence_name"),
4011 : _("schema_name"),
4012 : _("role_specification"),
4013 : _("role_specification"),
4014 : _("database_name"),
4015 : _("role_specification"),
4016 : _("role_specification"),
4017 : _("domain_name"),
4018 : _("role_specification"),
4019 : _("role_specification"),
4020 : _("fdw_name"),
4021 : _("role_specification"),
4022 : _("role_specification"),
4023 : _("server_name"),
4024 : _("role_specification"),
4025 : _("role_specification"),
4026 : _("routine_name"),
4027 : _("argmode"),
4028 : _("arg_name"),
4029 : _("arg_type"),
4030 : _("schema_name"),
4031 : _("role_specification"),
4032 : _("role_specification"),
4033 : _("lang_name"),
4034 : _("role_specification"),
4035 : _("role_specification"),
4036 : _("loid"),
4037 : _("role_specification"),
4038 : _("role_specification"),
4039 : _("configuration_parameter"),
4040 : _("role_specification"),
4041 : _("role_specification"),
4042 : _("schema_name"),
4043 : _("role_specification"),
4044 : _("role_specification"),
4045 : _("tablespace_name"),
4046 : _("role_specification"),
4047 : _("role_specification"),
4048 : _("type_name"),
4049 : _("role_specification"),
4050 : _("role_specification"),
4051 : _("role_name"),
4052 : _("role_specification"),
4053 : _("role_specification"),
4054 : _("where role_specification can be:"),
4055 : _("role_name"));
4056 0 : }
4057 :
4058 : static void
4059 0 : sql_help_IMPORT_FOREIGN_SCHEMA(PQExpBuffer buf)
4060 : {
4061 0 : appendPQExpBuffer(buf,
4062 : "IMPORT FOREIGN SCHEMA %s\n"
4063 : " [ { LIMIT TO | EXCEPT } ( %s [, ...] ) ]\n"
4064 : " FROM SERVER %s\n"
4065 : " INTO %s\n"
4066 : " [ OPTIONS ( %s '%s' [, ... ] ) ]",
4067 : _("remote_schema"),
4068 : _("table_name"),
4069 : _("server_name"),
4070 : _("local_schema"),
4071 : _("option"),
4072 : _("value"));
4073 0 : }
4074 :
4075 : static void
4076 0 : sql_help_INSERT(PQExpBuffer buf)
4077 : {
4078 0 : appendPQExpBuffer(buf,
4079 : "[ WITH [ RECURSIVE ] %s [, ...] ]\n"
4080 : "INSERT INTO %s [ AS %s ] [ ( %s [, ...] ) ]\n"
4081 : " [ OVERRIDING { SYSTEM | USER } VALUE ]\n"
4082 : " { DEFAULT VALUES | VALUES ( { %s | DEFAULT } [, ...] ) [, ...] | %s }\n"
4083 : " [ ON CONFLICT [ %s ] %s ]\n"
4084 : " [ RETURNING [ WITH ( { OLD | NEW } AS %s [, ...] ) ]\n"
4085 : " { * | %s [ [ AS ] %s ] } [, ...] ]\n"
4086 : "\n"
4087 : "%s\n"
4088 : "\n"
4089 : " ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [, ...] ) [ WHERE %s ]\n"
4090 : " ON CONSTRAINT %s\n"
4091 : "\n"
4092 : "%s\n"
4093 : "\n"
4094 : " DO NOTHING\n"
4095 : " DO SELECT [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } ] [ WHERE %s ]\n"
4096 : " DO UPDATE SET { %s = { %s | DEFAULT } |\n"
4097 : " ( %s [, ...] ) = [ ROW ] ( { %s | DEFAULT } [, ...] ) |\n"
4098 : " ( %s [, ...] ) = ( %s )\n"
4099 : " } [, ...]\n"
4100 : " [ WHERE %s ]",
4101 : _("with_query"),
4102 : _("table_name"),
4103 : _("alias"),
4104 : _("column_name"),
4105 : _("expression"),
4106 : _("query"),
4107 : _("conflict_target"),
4108 : _("conflict_action"),
4109 : _("output_alias"),
4110 : _("output_expression"),
4111 : _("output_name"),
4112 : _("where conflict_target can be one of:"),
4113 : _("index_column_name"),
4114 : _("index_expression"),
4115 : _("collation"),
4116 : _("opclass"),
4117 : _("index_predicate"),
4118 : _("constraint_name"),
4119 : _("and conflict_action is one of:"),
4120 : _("condition"),
4121 : _("column_name"),
4122 : _("expression"),
4123 : _("column_name"),
4124 : _("expression"),
4125 : _("column_name"),
4126 : _("sub-SELECT"),
4127 : _("condition"));
4128 0 : }
4129 :
4130 : static void
4131 0 : sql_help_LISTEN(PQExpBuffer buf)
4132 : {
4133 0 : appendPQExpBuffer(buf,
4134 : "LISTEN %s",
4135 : _("channel"));
4136 0 : }
4137 :
4138 : static void
4139 0 : sql_help_LOAD(PQExpBuffer buf)
4140 : {
4141 0 : appendPQExpBuffer(buf,
4142 : "LOAD '%s'",
4143 : _("filename"));
4144 0 : }
4145 :
4146 : static void
4147 0 : sql_help_LOCK(PQExpBuffer buf)
4148 : {
4149 0 : appendPQExpBuffer(buf,
4150 : "LOCK [ TABLE ] [ ONLY ] %s [ * ] [, ...] [ IN %s MODE ] [ NOWAIT ]\n"
4151 : "\n"
4152 : "%s\n"
4153 : "\n"
4154 : " ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE\n"
4155 : " | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE",
4156 : _("name"),
4157 : _("lockmode"),
4158 : _("where lockmode is one of:"));
4159 0 : }
4160 :
4161 : static void
4162 0 : sql_help_MERGE(PQExpBuffer buf)
4163 : {
4164 0 : appendPQExpBuffer(buf,
4165 : "[ WITH %s [, ...] ]\n"
4166 : "MERGE INTO [ ONLY ] %s [ * ] [ [ AS ] %s ]\n"
4167 : " USING %s ON %s\n"
4168 : " %s [...]\n"
4169 : " [ RETURNING [ WITH ( { OLD | NEW } AS %s [, ...] ) ]\n"
4170 : " { * | %s [ [ AS ] %s ] } [, ...] ]\n"
4171 : "\n"
4172 : "%s\n"
4173 : "\n"
4174 : " { [ ONLY ] %s [ * ] | ( %s ) } [ [ AS ] %s ]\n"
4175 : "\n"
4176 : "%s\n"
4177 : "\n"
4178 : " { WHEN MATCHED [ AND %s ] THEN { %s | %s | DO NOTHING } |\n"
4179 : " WHEN NOT MATCHED BY SOURCE [ AND %s ] THEN { %s | %s | DO NOTHING } |\n"
4180 : " WHEN NOT MATCHED [ BY TARGET ] [ AND %s ] THEN { %s | DO NOTHING } }\n"
4181 : "\n"
4182 : "%s\n"
4183 : "\n"
4184 : " INSERT [( %s [, ...] )]\n"
4185 : " [ OVERRIDING { SYSTEM | USER } VALUE ]\n"
4186 : " { VALUES ( { %s | DEFAULT } [, ...] ) | DEFAULT VALUES }\n"
4187 : "\n"
4188 : "%s\n"
4189 : "\n"
4190 : " UPDATE SET { %s = { %s | DEFAULT } |\n"
4191 : " ( %s [, ...] ) = [ ROW ] ( { %s | DEFAULT } [, ...] ) |\n"
4192 : " ( %s [, ...] ) = ( %s )\n"
4193 : " } [, ...]\n"
4194 : "\n"
4195 : "%s\n"
4196 : "\n"
4197 : " DELETE",
4198 : _("with_query"),
4199 : _("target_table_name"),
4200 : _("target_alias"),
4201 : _("data_source"),
4202 : _("join_condition"),
4203 : _("when_clause"),
4204 : _("output_alias"),
4205 : _("output_expression"),
4206 : _("output_name"),
4207 : _("where data_source is:"),
4208 : _("source_table_name"),
4209 : _("source_query"),
4210 : _("source_alias"),
4211 : _("and when_clause is:"),
4212 : _("condition"),
4213 : _("merge_update"),
4214 : _("merge_delete"),
4215 : _("condition"),
4216 : _("merge_update"),
4217 : _("merge_delete"),
4218 : _("condition"),
4219 : _("merge_insert"),
4220 : _("and merge_insert is:"),
4221 : _("column_name"),
4222 : _("expression"),
4223 : _("and merge_update is:"),
4224 : _("column_name"),
4225 : _("expression"),
4226 : _("column_name"),
4227 : _("expression"),
4228 : _("column_name"),
4229 : _("sub-SELECT"),
4230 : _("and merge_delete is:"));
4231 0 : }
4232 :
4233 : static void
4234 0 : sql_help_MOVE(PQExpBuffer buf)
4235 : {
4236 0 : appendPQExpBuffer(buf,
4237 : "MOVE [ %s ] [ FROM | IN ] %s\n"
4238 : "\n"
4239 : "%s\n"
4240 : "\n"
4241 : " NEXT\n"
4242 : " PRIOR\n"
4243 : " FIRST\n"
4244 : " LAST\n"
4245 : " ABSOLUTE %s\n"
4246 : " RELATIVE %s\n"
4247 : " %s\n"
4248 : " ALL\n"
4249 : " FORWARD\n"
4250 : " FORWARD %s\n"
4251 : " FORWARD ALL\n"
4252 : " BACKWARD\n"
4253 : " BACKWARD %s\n"
4254 : " BACKWARD ALL",
4255 : _("direction"),
4256 : _("cursor_name"),
4257 : _("where direction can be one of:"),
4258 : _("count"),
4259 : _("count"),
4260 : _("count"),
4261 : _("count"),
4262 : _("count"));
4263 0 : }
4264 :
4265 : static void
4266 0 : sql_help_NOTIFY(PQExpBuffer buf)
4267 : {
4268 0 : appendPQExpBuffer(buf,
4269 : "NOTIFY %s [ , %s ]",
4270 : _("channel"),
4271 : _("payload"));
4272 0 : }
4273 :
4274 : static void
4275 0 : sql_help_PREPARE(PQExpBuffer buf)
4276 : {
4277 0 : appendPQExpBuffer(buf,
4278 : "PREPARE %s [ ( %s [, ...] ) ] AS %s",
4279 : _("name"),
4280 : _("data_type"),
4281 : _("statement"));
4282 0 : }
4283 :
4284 : static void
4285 0 : sql_help_PREPARE_TRANSACTION(PQExpBuffer buf)
4286 : {
4287 0 : appendPQExpBuffer(buf,
4288 : "PREPARE TRANSACTION %s",
4289 : _("transaction_id"));
4290 0 : }
4291 :
4292 : static void
4293 0 : sql_help_REASSIGN_OWNED(PQExpBuffer buf)
4294 : {
4295 0 : appendPQExpBuffer(buf,
4296 : "REASSIGN OWNED BY { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...]\n"
4297 : " TO { %s | CURRENT_ROLE | CURRENT_USER | SESSION_USER }",
4298 : _("old_role"),
4299 : _("new_role"));
4300 0 : }
4301 :
4302 : static void
4303 0 : sql_help_REFRESH_MATERIALIZED_VIEW(PQExpBuffer buf)
4304 : {
4305 0 : appendPQExpBuffer(buf,
4306 : "REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] %s\n"
4307 : " [ WITH [ NO ] DATA ]",
4308 : _("name"));
4309 0 : }
4310 :
4311 : static void
4312 0 : sql_help_REINDEX(PQExpBuffer buf)
4313 : {
4314 0 : appendPQExpBuffer(buf,
4315 : "REINDEX [ ( %s [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] %s\n"
4316 : "REINDEX [ ( %s [, ...] ) ] { DATABASE | SYSTEM } [ CONCURRENTLY ] [ %s ]\n"
4317 : "\n"
4318 : "%s\n"
4319 : "\n"
4320 : " CONCURRENTLY [ %s ]\n"
4321 : " TABLESPACE %s\n"
4322 : " VERBOSE [ %s ]",
4323 : _("option"),
4324 : _("name"),
4325 : _("option"),
4326 : _("name"),
4327 : _("where option can be one of:"),
4328 : _("boolean"),
4329 : _("new_tablespace"),
4330 : _("boolean"));
4331 0 : }
4332 :
4333 : static void
4334 0 : sql_help_RELEASE_SAVEPOINT(PQExpBuffer buf)
4335 : {
4336 0 : appendPQExpBuffer(buf,
4337 : "RELEASE [ SAVEPOINT ] %s",
4338 : _("savepoint_name"));
4339 0 : }
4340 :
4341 : static void
4342 0 : sql_help_RESET(PQExpBuffer buf)
4343 : {
4344 0 : appendPQExpBuffer(buf,
4345 : "RESET %s\n"
4346 : "RESET ALL",
4347 : _("configuration_parameter"));
4348 0 : }
4349 :
4350 : static void
4351 0 : sql_help_REVOKE(PQExpBuffer buf)
4352 : {
4353 0 : appendPQExpBuffer(buf,
4354 : "REVOKE [ GRANT OPTION FOR ]\n"
4355 : " { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN }\n"
4356 : " [, ...] | ALL [ PRIVILEGES ] }\n"
4357 : " ON { [ TABLE ] %s [, ...]\n"
4358 : " | ALL TABLES IN SCHEMA %s [, ...] }\n"
4359 : " FROM %s [, ...]\n"
4360 : " [ GRANTED BY %s ]\n"
4361 : " [ CASCADE | RESTRICT ]\n"
4362 : "\n"
4363 : "REVOKE [ GRANT OPTION FOR ]\n"
4364 : " { { SELECT | INSERT | UPDATE | REFERENCES } ( %s [, ...] )\n"
4365 : " [, ...] | ALL [ PRIVILEGES ] ( %s [, ...] ) }\n"
4366 : " ON [ TABLE ] %s [, ...]\n"
4367 : " FROM %s [, ...]\n"
4368 : " [ GRANTED BY %s ]\n"
4369 : " [ CASCADE | RESTRICT ]\n"
4370 : "\n"
4371 : "REVOKE [ GRANT OPTION FOR ]\n"
4372 : " { { USAGE | SELECT | UPDATE }\n"
4373 : " [, ...] | ALL [ PRIVILEGES ] }\n"
4374 : " ON { SEQUENCE %s [, ...]\n"
4375 : " | ALL SEQUENCES IN SCHEMA %s [, ...] }\n"
4376 : " FROM %s [, ...]\n"
4377 : " [ GRANTED BY %s ]\n"
4378 : " [ CASCADE | RESTRICT ]\n"
4379 : "\n"
4380 : "REVOKE [ GRANT OPTION FOR ]\n"
4381 : " { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }\n"
4382 : " ON DATABASE %s [, ...]\n"
4383 : " FROM %s [, ...]\n"
4384 : " [ GRANTED BY %s ]\n"
4385 : " [ CASCADE | RESTRICT ]\n"
4386 : "\n"
4387 : "REVOKE [ GRANT OPTION FOR ]\n"
4388 : " { USAGE | ALL [ PRIVILEGES ] }\n"
4389 : " ON DOMAIN %s [, ...]\n"
4390 : " FROM %s [, ...]\n"
4391 : " [ GRANTED BY %s ]\n"
4392 : " [ CASCADE | RESTRICT ]\n"
4393 : "\n"
4394 : "REVOKE [ GRANT OPTION FOR ]\n"
4395 : " { USAGE | ALL [ PRIVILEGES ] }\n"
4396 : " ON FOREIGN DATA WRAPPER %s [, ...]\n"
4397 : " FROM %s [, ...]\n"
4398 : " [ GRANTED BY %s ]\n"
4399 : " [ CASCADE | RESTRICT ]\n"
4400 : "\n"
4401 : "REVOKE [ GRANT OPTION FOR ]\n"
4402 : " { USAGE | ALL [ PRIVILEGES ] }\n"
4403 : " ON FOREIGN SERVER %s [, ...]\n"
4404 : " FROM %s [, ...]\n"
4405 : " [ GRANTED BY %s ]\n"
4406 : " [ CASCADE | RESTRICT ]\n"
4407 : "\n"
4408 : "REVOKE [ GRANT OPTION FOR ]\n"
4409 : " { EXECUTE | ALL [ PRIVILEGES ] }\n"
4410 : " ON { { FUNCTION | PROCEDURE | ROUTINE } %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n"
4411 : " | ALL { FUNCTIONS | PROCEDURES | ROUTINES } IN SCHEMA %s [, ...] }\n"
4412 : " FROM %s [, ...]\n"
4413 : " [ GRANTED BY %s ]\n"
4414 : " [ CASCADE | RESTRICT ]\n"
4415 : "\n"
4416 : "REVOKE [ GRANT OPTION FOR ]\n"
4417 : " { USAGE | ALL [ PRIVILEGES ] }\n"
4418 : " ON LANGUAGE %s [, ...]\n"
4419 : " FROM %s [, ...]\n"
4420 : " [ GRANTED BY %s ]\n"
4421 : " [ CASCADE | RESTRICT ]\n"
4422 : "\n"
4423 : "REVOKE [ GRANT OPTION FOR ]\n"
4424 : " { { SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] }\n"
4425 : " ON LARGE OBJECT %s [, ...]\n"
4426 : " FROM %s [, ...]\n"
4427 : " [ GRANTED BY %s ]\n"
4428 : " [ CASCADE | RESTRICT ]\n"
4429 : "\n"
4430 : "REVOKE [ GRANT OPTION FOR ]\n"
4431 : " { { SET | ALTER SYSTEM } [, ...] | ALL [ PRIVILEGES ] }\n"
4432 : " ON PARAMETER %s [, ...]\n"
4433 : " FROM %s [, ...]\n"
4434 : " [ GRANTED BY %s ]\n"
4435 : " [ CASCADE | RESTRICT ]\n"
4436 : "\n"
4437 : "REVOKE [ GRANT OPTION FOR ]\n"
4438 : " { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }\n"
4439 : " ON SCHEMA %s [, ...]\n"
4440 : " FROM %s [, ...]\n"
4441 : " [ GRANTED BY %s ]\n"
4442 : " [ CASCADE | RESTRICT ]\n"
4443 : "\n"
4444 : "REVOKE [ GRANT OPTION FOR ]\n"
4445 : " { CREATE | ALL [ PRIVILEGES ] }\n"
4446 : " ON TABLESPACE %s [, ...]\n"
4447 : " FROM %s [, ...]\n"
4448 : " [ GRANTED BY %s ]\n"
4449 : " [ CASCADE | RESTRICT ]\n"
4450 : "\n"
4451 : "REVOKE [ GRANT OPTION FOR ]\n"
4452 : " { USAGE | ALL [ PRIVILEGES ] }\n"
4453 : " ON TYPE %s [, ...]\n"
4454 : " FROM %s [, ...]\n"
4455 : " [ GRANTED BY %s ]\n"
4456 : " [ CASCADE | RESTRICT ]\n"
4457 : "\n"
4458 : "REVOKE [ { ADMIN | INHERIT | SET } OPTION FOR ]\n"
4459 : " %s [, ...] FROM %s [, ...]\n"
4460 : " [ GRANTED BY %s ]\n"
4461 : " [ CASCADE | RESTRICT ]\n"
4462 : "\n"
4463 : "%s\n"
4464 : "\n"
4465 : " [ GROUP ] %s\n"
4466 : " | PUBLIC\n"
4467 : " | CURRENT_ROLE\n"
4468 : " | CURRENT_USER\n"
4469 : " | SESSION_USER",
4470 : _("table_name"),
4471 : _("schema_name"),
4472 : _("role_specification"),
4473 : _("role_specification"),
4474 : _("column_name"),
4475 : _("column_name"),
4476 : _("table_name"),
4477 : _("role_specification"),
4478 : _("role_specification"),
4479 : _("sequence_name"),
4480 : _("schema_name"),
4481 : _("role_specification"),
4482 : _("role_specification"),
4483 : _("database_name"),
4484 : _("role_specification"),
4485 : _("role_specification"),
4486 : _("domain_name"),
4487 : _("role_specification"),
4488 : _("role_specification"),
4489 : _("fdw_name"),
4490 : _("role_specification"),
4491 : _("role_specification"),
4492 : _("server_name"),
4493 : _("role_specification"),
4494 : _("role_specification"),
4495 : _("function_name"),
4496 : _("argmode"),
4497 : _("arg_name"),
4498 : _("arg_type"),
4499 : _("schema_name"),
4500 : _("role_specification"),
4501 : _("role_specification"),
4502 : _("lang_name"),
4503 : _("role_specification"),
4504 : _("role_specification"),
4505 : _("loid"),
4506 : _("role_specification"),
4507 : _("role_specification"),
4508 : _("configuration_parameter"),
4509 : _("role_specification"),
4510 : _("role_specification"),
4511 : _("schema_name"),
4512 : _("role_specification"),
4513 : _("role_specification"),
4514 : _("tablespace_name"),
4515 : _("role_specification"),
4516 : _("role_specification"),
4517 : _("type_name"),
4518 : _("role_specification"),
4519 : _("role_specification"),
4520 : _("role_name"),
4521 : _("role_specification"),
4522 : _("role_specification"),
4523 : _("where role_specification can be:"),
4524 : _("role_name"));
4525 0 : }
4526 :
4527 : static void
4528 0 : sql_help_ROLLBACK(PQExpBuffer buf)
4529 : {
4530 0 : appendPQExpBuffer(buf,
4531 : "ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]");
4532 0 : }
4533 :
4534 : static void
4535 0 : sql_help_ROLLBACK_PREPARED(PQExpBuffer buf)
4536 : {
4537 0 : appendPQExpBuffer(buf,
4538 : "ROLLBACK PREPARED %s",
4539 : _("transaction_id"));
4540 0 : }
4541 :
4542 : static void
4543 0 : sql_help_ROLLBACK_TO_SAVEPOINT(PQExpBuffer buf)
4544 : {
4545 0 : appendPQExpBuffer(buf,
4546 : "ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] %s",
4547 : _("savepoint_name"));
4548 0 : }
4549 :
4550 : static void
4551 0 : sql_help_SAVEPOINT(PQExpBuffer buf)
4552 : {
4553 0 : appendPQExpBuffer(buf,
4554 : "SAVEPOINT %s",
4555 : _("savepoint_name"));
4556 0 : }
4557 :
4558 : static void
4559 0 : sql_help_SECURITY_LABEL(PQExpBuffer buf)
4560 : {
4561 0 : appendPQExpBuffer(buf,
4562 : "SECURITY LABEL [ FOR %s ] ON\n"
4563 : "{\n"
4564 : " TABLE %s |\n"
4565 : " COLUMN %s.%s |\n"
4566 : " AGGREGATE %s ( %s ) |\n"
4567 : " DATABASE %s |\n"
4568 : " DOMAIN %s |\n"
4569 : " EVENT TRIGGER %s |\n"
4570 : " FOREIGN TABLE %s |\n"
4571 : " FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
4572 : " LARGE OBJECT %s |\n"
4573 : " MATERIALIZED VIEW %s |\n"
4574 : " [ PROCEDURAL ] LANGUAGE %s |\n"
4575 : " PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
4576 : " PUBLICATION %s |\n"
4577 : " ROLE %s |\n"
4578 : " ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n"
4579 : " SCHEMA %s |\n"
4580 : " SEQUENCE %s |\n"
4581 : " SUBSCRIPTION %s |\n"
4582 : " TABLESPACE %s |\n"
4583 : " TYPE %s |\n"
4584 : " VIEW %s\n"
4585 : "} IS { %s | NULL }\n"
4586 : "\n"
4587 : "%s\n"
4588 : "\n"
4589 : "* |\n"
4590 : "[ %s ] [ %s ] %s [ , ... ] |\n"
4591 : "[ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ]",
4592 : _("provider"),
4593 : _("object_name"),
4594 : _("table_name"),
4595 : _("column_name"),
4596 : _("aggregate_name"),
4597 : _("aggregate_signature"),
4598 : _("object_name"),
4599 : _("object_name"),
4600 : _("object_name"),
4601 : _("object_name"),
4602 : _("function_name"),
4603 : _("argmode"),
4604 : _("argname"),
4605 : _("argtype"),
4606 : _("large_object_oid"),
4607 : _("object_name"),
4608 : _("object_name"),
4609 : _("procedure_name"),
4610 : _("argmode"),
4611 : _("argname"),
4612 : _("argtype"),
4613 : _("object_name"),
4614 : _("object_name"),
4615 : _("routine_name"),
4616 : _("argmode"),
4617 : _("argname"),
4618 : _("argtype"),
4619 : _("object_name"),
4620 : _("object_name"),
4621 : _("object_name"),
4622 : _("object_name"),
4623 : _("object_name"),
4624 : _("object_name"),
4625 : _("string_literal"),
4626 : _("where aggregate_signature is:"),
4627 : _("argmode"),
4628 : _("argname"),
4629 : _("argtype"),
4630 : _("argmode"),
4631 : _("argname"),
4632 : _("argtype"),
4633 : _("argmode"),
4634 : _("argname"),
4635 : _("argtype"));
4636 0 : }
4637 :
4638 : static void
4639 1 : sql_help_SELECT(PQExpBuffer buf)
4640 : {
4641 1 : appendPQExpBuffer(buf,
4642 : "[ WITH [ RECURSIVE ] %s [, ...] ]\n"
4643 : "SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n"
4644 : " [ { * | %s [ [ AS ] %s ] } [, ...] ]\n"
4645 : " [ FROM %s [, ...] ]\n"
4646 : " [ WHERE %s ]\n"
4647 : " [ GROUP BY { ALL | [ ALL | DISTINCT ] %s [, ...] } ]\n"
4648 : " [ HAVING %s ]\n"
4649 : " [ WINDOW %s AS ( %s ) [, ...] ]\n"
4650 : " [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n"
4651 : " [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n"
4652 : " [ LIMIT { %s | ALL } ]\n"
4653 : " [ OFFSET %s [ ROW | ROWS ] ]\n"
4654 : " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } { ONLY | WITH TIES } ]\n"
4655 : " [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF %s [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ]\n"
4656 : "\n"
4657 : "%s\n"
4658 : "\n"
4659 : " [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4660 : " [ TABLESAMPLE %s ( %s [, ...] ) [ REPEATABLE ( %s ) ] ]\n"
4661 : " [ LATERAL ] ( %s ) [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4662 : " %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4663 : " [ LATERAL ] %s ( [ %s [, ...] ] )\n"
4664 : " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4665 : " [ LATERAL ] %s ( [ %s [, ...] ] ) [ AS ] %s ( %s [, ...] )\n"
4666 : " [ LATERAL ] %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n"
4667 : " [ LATERAL ] ROWS FROM( %s ( [ %s [, ...] ] ) [ AS ( %s [, ...] ) ] [, ...] )\n"
4668 : " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4669 : " %s %s %s { ON %s | USING ( %s [, ...] ) [ AS %s ] }\n"
4670 : " %s NATURAL %s %s\n"
4671 : " %s CROSS JOIN %s\n"
4672 : "\n"
4673 : "%s\n"
4674 : "\n"
4675 : " ( )\n"
4676 : " %s\n"
4677 : " ( %s [, ...] )\n"
4678 : " ROLLUP ( { %s | ( %s [, ...] ) } [, ...] )\n"
4679 : " CUBE ( { %s | ( %s [, ...] ) } [, ...] )\n"
4680 : " GROUPING SETS ( %s [, ...] )\n"
4681 : "\n"
4682 : "%s\n"
4683 : "\n"
4684 : " %s [ ( %s [, ...] ) ] AS [ [ NOT ] MATERIALIZED ] ( %s | %s | %s | %s | %s | %s )\n"
4685 : " [ SEARCH { BREADTH | DEPTH } FIRST BY %s [, ...] SET %s ]\n"
4686 : " [ CYCLE %s [, ...] SET %s [ TO %s DEFAULT %s ] USING %s ]\n"
4687 : "\n"
4688 : "TABLE [ ONLY ] %s [ * ]",
4689 : _("with_query"),
4690 : _("expression"),
4691 : _("expression"),
4692 : _("output_name"),
4693 : _("from_item"),
4694 : _("condition"),
4695 : _("grouping_element"),
4696 : _("condition"),
4697 : _("window_name"),
4698 : _("window_definition"),
4699 : _("select"),
4700 : _("expression"),
4701 : _("operator"),
4702 : _("count"),
4703 : _("start"),
4704 : _("count"),
4705 : _("from_reference"),
4706 : _("where from_item can be one of:"),
4707 : _("table_name"),
4708 : _("alias"),
4709 : _("column_alias"),
4710 : _("sampling_method"),
4711 : _("argument"),
4712 : _("seed"),
4713 : _("select"),
4714 : _("alias"),
4715 : _("column_alias"),
4716 : _("with_query_name"),
4717 : _("alias"),
4718 : _("column_alias"),
4719 : _("function_name"),
4720 : _("argument"),
4721 : _("alias"),
4722 : _("column_alias"),
4723 : _("function_name"),
4724 : _("argument"),
4725 : _("alias"),
4726 : _("column_definition"),
4727 : _("function_name"),
4728 : _("argument"),
4729 : _("column_definition"),
4730 : _("function_name"),
4731 : _("argument"),
4732 : _("column_definition"),
4733 : _("alias"),
4734 : _("column_alias"),
4735 : _("from_item"),
4736 : _("join_type"),
4737 : _("from_item"),
4738 : _("join_condition"),
4739 : _("join_column"),
4740 : _("join_using_alias"),
4741 : _("from_item"),
4742 : _("join_type"),
4743 : _("from_item"),
4744 : _("from_item"),
4745 : _("from_item"),
4746 : _("and grouping_element can be one of:"),
4747 : _("expression"),
4748 : _("expression"),
4749 : _("expression"),
4750 : _("expression"),
4751 : _("expression"),
4752 : _("expression"),
4753 : _("grouping_element"),
4754 : _("and with_query is:"),
4755 : _("with_query_name"),
4756 : _("column_name"),
4757 : _("select"),
4758 : _("values"),
4759 : _("insert"),
4760 : _("update"),
4761 : _("delete"),
4762 : _("merge"),
4763 : _("column_name"),
4764 : _("search_seq_col_name"),
4765 : _("column_name"),
4766 : _("cycle_mark_col_name"),
4767 : _("cycle_mark_value"),
4768 : _("cycle_mark_default"),
4769 : _("cycle_path_col_name"),
4770 : _("table_name"));
4771 1 : }
4772 :
4773 : static void
4774 0 : sql_help_SELECT_INTO(PQExpBuffer buf)
4775 : {
4776 0 : appendPQExpBuffer(buf,
4777 : "[ WITH [ RECURSIVE ] %s [, ...] ]\n"
4778 : "SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n"
4779 : " [ { * | %s [ [ AS ] %s ] } [, ...] ]\n"
4780 : " INTO [ TEMPORARY | TEMP | UNLOGGED ] [ TABLE ] %s\n"
4781 : " [ FROM %s [, ...] ]\n"
4782 : " [ WHERE %s ]\n"
4783 : " [ GROUP BY { ALL | [ ALL | DISTINCT ] %s [, ...] } ]\n"
4784 : " [ HAVING %s ]\n"
4785 : " [ WINDOW %s AS ( %s ) [, ...] ]\n"
4786 : " [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n"
4787 : " [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n"
4788 : " [ LIMIT { %s | ALL } ]\n"
4789 : " [ OFFSET %s [ ROW | ROWS ] ]\n"
4790 : " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } { ONLY | WITH TIES } ]\n"
4791 : " [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF %s [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ]",
4792 : _("with_query"),
4793 : _("expression"),
4794 : _("expression"),
4795 : _("output_name"),
4796 : _("new_table"),
4797 : _("from_item"),
4798 : _("condition"),
4799 : _("grouping_element"),
4800 : _("condition"),
4801 : _("window_name"),
4802 : _("window_definition"),
4803 : _("select"),
4804 : _("expression"),
4805 : _("operator"),
4806 : _("count"),
4807 : _("start"),
4808 : _("count"),
4809 : _("from_reference"));
4810 0 : }
4811 :
4812 : static void
4813 0 : sql_help_SET(PQExpBuffer buf)
4814 : {
4815 0 : appendPQExpBuffer(buf,
4816 : "SET [ SESSION | LOCAL ] %s { TO | = } { %s [, ...] | DEFAULT }\n"
4817 : "SET [ SESSION | LOCAL ] TIME ZONE { %s | LOCAL | DEFAULT }",
4818 : _("configuration_parameter"),
4819 : _("value"),
4820 : _("value"));
4821 0 : }
4822 :
4823 : static void
4824 0 : sql_help_SET_CONSTRAINTS(PQExpBuffer buf)
4825 : {
4826 0 : appendPQExpBuffer(buf,
4827 : "SET CONSTRAINTS { ALL | %s [, ...] } { DEFERRED | IMMEDIATE }",
4828 : _("name"));
4829 0 : }
4830 :
4831 : static void
4832 0 : sql_help_SET_ROLE(PQExpBuffer buf)
4833 : {
4834 0 : appendPQExpBuffer(buf,
4835 : "SET [ SESSION | LOCAL ] ROLE %s\n"
4836 : "SET [ SESSION | LOCAL ] ROLE NONE\n"
4837 : "RESET ROLE",
4838 : _("role_name"));
4839 0 : }
4840 :
4841 : static void
4842 0 : sql_help_SET_SESSION_AUTHORIZATION(PQExpBuffer buf)
4843 : {
4844 0 : appendPQExpBuffer(buf,
4845 : "SET [ SESSION | LOCAL ] SESSION AUTHORIZATION %s\n"
4846 : "SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT\n"
4847 : "RESET SESSION AUTHORIZATION",
4848 : _("user_name"));
4849 0 : }
4850 :
4851 : static void
4852 0 : sql_help_SET_TRANSACTION(PQExpBuffer buf)
4853 : {
4854 0 : appendPQExpBuffer(buf,
4855 : "SET TRANSACTION %s [, ...]\n"
4856 : "SET TRANSACTION SNAPSHOT %s\n"
4857 : "SET SESSION CHARACTERISTICS AS TRANSACTION %s [, ...]\n"
4858 : "\n"
4859 : "%s\n"
4860 : "\n"
4861 : " ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n"
4862 : " READ WRITE | READ ONLY\n"
4863 : " [ NOT ] DEFERRABLE",
4864 : _("transaction_mode"),
4865 : _("snapshot_id"),
4866 : _("transaction_mode"),
4867 : _("where transaction_mode is one of:"));
4868 0 : }
4869 :
4870 : static void
4871 0 : sql_help_SHOW(PQExpBuffer buf)
4872 : {
4873 0 : appendPQExpBuffer(buf,
4874 : "SHOW %s\n"
4875 : "SHOW ALL",
4876 : _("name"));
4877 0 : }
4878 :
4879 : static void
4880 0 : sql_help_START_TRANSACTION(PQExpBuffer buf)
4881 : {
4882 0 : appendPQExpBuffer(buf,
4883 : "START TRANSACTION [ %s [, ...] ]\n"
4884 : "\n"
4885 : "%s\n"
4886 : "\n"
4887 : " ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n"
4888 : " READ WRITE | READ ONLY\n"
4889 : " [ NOT ] DEFERRABLE",
4890 : _("transaction_mode"),
4891 : _("where transaction_mode is one of:"));
4892 0 : }
4893 :
4894 : static void
4895 0 : sql_help_TABLE(PQExpBuffer buf)
4896 : {
4897 0 : appendPQExpBuffer(buf,
4898 : "[ WITH [ RECURSIVE ] %s [, ...] ]\n"
4899 : "SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n"
4900 : " [ { * | %s [ [ AS ] %s ] } [, ...] ]\n"
4901 : " [ FROM %s [, ...] ]\n"
4902 : " [ WHERE %s ]\n"
4903 : " [ GROUP BY { ALL | [ ALL | DISTINCT ] %s [, ...] } ]\n"
4904 : " [ HAVING %s ]\n"
4905 : " [ WINDOW %s AS ( %s ) [, ...] ]\n"
4906 : " [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n"
4907 : " [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n"
4908 : " [ LIMIT { %s | ALL } ]\n"
4909 : " [ OFFSET %s [ ROW | ROWS ] ]\n"
4910 : " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } { ONLY | WITH TIES } ]\n"
4911 : " [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF %s [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ]\n"
4912 : "\n"
4913 : "%s\n"
4914 : "\n"
4915 : " [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4916 : " [ TABLESAMPLE %s ( %s [, ...] ) [ REPEATABLE ( %s ) ] ]\n"
4917 : " [ LATERAL ] ( %s ) [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4918 : " %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4919 : " [ LATERAL ] %s ( [ %s [, ...] ] )\n"
4920 : " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4921 : " [ LATERAL ] %s ( [ %s [, ...] ] ) [ AS ] %s ( %s [, ...] )\n"
4922 : " [ LATERAL ] %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n"
4923 : " [ LATERAL ] ROWS FROM( %s ( [ %s [, ...] ] ) [ AS ( %s [, ...] ) ] [, ...] )\n"
4924 : " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
4925 : " %s %s %s { ON %s | USING ( %s [, ...] ) [ AS %s ] }\n"
4926 : " %s NATURAL %s %s\n"
4927 : " %s CROSS JOIN %s\n"
4928 : "\n"
4929 : "%s\n"
4930 : "\n"
4931 : " ( )\n"
4932 : " %s\n"
4933 : " ( %s [, ...] )\n"
4934 : " ROLLUP ( { %s | ( %s [, ...] ) } [, ...] )\n"
4935 : " CUBE ( { %s | ( %s [, ...] ) } [, ...] )\n"
4936 : " GROUPING SETS ( %s [, ...] )\n"
4937 : "\n"
4938 : "%s\n"
4939 : "\n"
4940 : " %s [ ( %s [, ...] ) ] AS [ [ NOT ] MATERIALIZED ] ( %s | %s | %s | %s | %s | %s )\n"
4941 : " [ SEARCH { BREADTH | DEPTH } FIRST BY %s [, ...] SET %s ]\n"
4942 : " [ CYCLE %s [, ...] SET %s [ TO %s DEFAULT %s ] USING %s ]\n"
4943 : "\n"
4944 : "TABLE [ ONLY ] %s [ * ]",
4945 : _("with_query"),
4946 : _("expression"),
4947 : _("expression"),
4948 : _("output_name"),
4949 : _("from_item"),
4950 : _("condition"),
4951 : _("grouping_element"),
4952 : _("condition"),
4953 : _("window_name"),
4954 : _("window_definition"),
4955 : _("select"),
4956 : _("expression"),
4957 : _("operator"),
4958 : _("count"),
4959 : _("start"),
4960 : _("count"),
4961 : _("from_reference"),
4962 : _("where from_item can be one of:"),
4963 : _("table_name"),
4964 : _("alias"),
4965 : _("column_alias"),
4966 : _("sampling_method"),
4967 : _("argument"),
4968 : _("seed"),
4969 : _("select"),
4970 : _("alias"),
4971 : _("column_alias"),
4972 : _("with_query_name"),
4973 : _("alias"),
4974 : _("column_alias"),
4975 : _("function_name"),
4976 : _("argument"),
4977 : _("alias"),
4978 : _("column_alias"),
4979 : _("function_name"),
4980 : _("argument"),
4981 : _("alias"),
4982 : _("column_definition"),
4983 : _("function_name"),
4984 : _("argument"),
4985 : _("column_definition"),
4986 : _("function_name"),
4987 : _("argument"),
4988 : _("column_definition"),
4989 : _("alias"),
4990 : _("column_alias"),
4991 : _("from_item"),
4992 : _("join_type"),
4993 : _("from_item"),
4994 : _("join_condition"),
4995 : _("join_column"),
4996 : _("join_using_alias"),
4997 : _("from_item"),
4998 : _("join_type"),
4999 : _("from_item"),
5000 : _("from_item"),
5001 : _("from_item"),
5002 : _("and grouping_element can be one of:"),
5003 : _("expression"),
5004 : _("expression"),
5005 : _("expression"),
5006 : _("expression"),
5007 : _("expression"),
5008 : _("expression"),
5009 : _("grouping_element"),
5010 : _("and with_query is:"),
5011 : _("with_query_name"),
5012 : _("column_name"),
5013 : _("select"),
5014 : _("values"),
5015 : _("insert"),
5016 : _("update"),
5017 : _("delete"),
5018 : _("merge"),
5019 : _("column_name"),
5020 : _("search_seq_col_name"),
5021 : _("column_name"),
5022 : _("cycle_mark_col_name"),
5023 : _("cycle_mark_value"),
5024 : _("cycle_mark_default"),
5025 : _("cycle_path_col_name"),
5026 : _("table_name"));
5027 0 : }
5028 :
5029 : static void
5030 0 : sql_help_TRUNCATE(PQExpBuffer buf)
5031 : {
5032 0 : appendPQExpBuffer(buf,
5033 : "TRUNCATE [ TABLE ] [ ONLY ] %s [ * ] [, ... ]\n"
5034 : " [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]",
5035 : _("name"));
5036 0 : }
5037 :
5038 : static void
5039 0 : sql_help_UNLISTEN(PQExpBuffer buf)
5040 : {
5041 0 : appendPQExpBuffer(buf,
5042 : "UNLISTEN { %s | * }",
5043 : _("channel"));
5044 0 : }
5045 :
5046 : static void
5047 0 : sql_help_UPDATE(PQExpBuffer buf)
5048 : {
5049 0 : appendPQExpBuffer(buf,
5050 : "[ WITH [ RECURSIVE ] %s [, ...] ]\n"
5051 : "UPDATE [ ONLY ] %s [ * ] [ [ AS ] %s ]\n"
5052 : " SET { %s = { %s | DEFAULT } |\n"
5053 : " ( %s [, ...] ) = [ ROW ] ( { %s | DEFAULT } [, ...] ) |\n"
5054 : " ( %s [, ...] ) = ( %s )\n"
5055 : " } [, ...]\n"
5056 : " [ FROM %s [, ...] ]\n"
5057 : " [ WHERE %s | WHERE CURRENT OF %s ]\n"
5058 : " [ RETURNING [ WITH ( { OLD | NEW } AS %s [, ...] ) ]\n"
5059 : " { * | %s [ [ AS ] %s ] } [, ...] ]",
5060 : _("with_query"),
5061 : _("table_name"),
5062 : _("alias"),
5063 : _("column_name"),
5064 : _("expression"),
5065 : _("column_name"),
5066 : _("expression"),
5067 : _("column_name"),
5068 : _("sub-SELECT"),
5069 : _("from_item"),
5070 : _("condition"),
5071 : _("cursor_name"),
5072 : _("output_alias"),
5073 : _("output_expression"),
5074 : _("output_name"));
5075 0 : }
5076 :
5077 : static void
5078 0 : sql_help_VACUUM(PQExpBuffer buf)
5079 : {
5080 0 : appendPQExpBuffer(buf,
5081 : "VACUUM [ ( %s [, ...] ) ] [ %s [, ...] ]\n"
5082 : "\n"
5083 : "%s\n"
5084 : "\n"
5085 : " FULL [ %s ]\n"
5086 : " FREEZE [ %s ]\n"
5087 : " VERBOSE [ %s ]\n"
5088 : " ANALYZE [ %s ]\n"
5089 : " DISABLE_PAGE_SKIPPING [ %s ]\n"
5090 : " SKIP_LOCKED [ %s ]\n"
5091 : " INDEX_CLEANUP { AUTO | ON | OFF }\n"
5092 : " PROCESS_MAIN [ %s ]\n"
5093 : " PROCESS_TOAST [ %s ]\n"
5094 : " TRUNCATE [ %s ]\n"
5095 : " PARALLEL %s\n"
5096 : " SKIP_DATABASE_STATS [ %s ]\n"
5097 : " ONLY_DATABASE_STATS [ %s ]\n"
5098 : " BUFFER_USAGE_LIMIT %s\n"
5099 : "\n"
5100 : "%s\n"
5101 : "\n"
5102 : " [ ONLY ] %s [ * ] [ ( %s [, ...] ) ]",
5103 : _("option"),
5104 : _("table_and_columns"),
5105 : _("where option can be one of:"),
5106 : _("boolean"),
5107 : _("boolean"),
5108 : _("boolean"),
5109 : _("boolean"),
5110 : _("boolean"),
5111 : _("boolean"),
5112 : _("boolean"),
5113 : _("boolean"),
5114 : _("boolean"),
5115 : _("integer"),
5116 : _("boolean"),
5117 : _("boolean"),
5118 : _("size"),
5119 : _("and table_and_columns is:"),
5120 : _("table_name"),
5121 : _("column_name"));
5122 0 : }
5123 :
5124 : static void
5125 0 : sql_help_VALUES(PQExpBuffer buf)
5126 : {
5127 0 : appendPQExpBuffer(buf,
5128 : "VALUES ( %s [, ...] ) [, ...]\n"
5129 : " [ ORDER BY %s [ ASC | DESC | USING %s ] [, ...] ]\n"
5130 : " [ LIMIT { %s | ALL } ]\n"
5131 : " [ OFFSET %s [ ROW | ROWS ] ]\n"
5132 : " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]",
5133 : _("expression"),
5134 : _("sort_expression"),
5135 : _("operator"),
5136 : _("count"),
5137 : _("start"),
5138 : _("count"));
5139 0 : }
5140 :
5141 : static void
5142 0 : sql_help_WAIT_FOR(PQExpBuffer buf)
5143 : {
5144 0 : appendPQExpBuffer(buf,
5145 : "WAIT FOR LSN '%s'\n"
5146 : " [ WITH ( %s [, ...] ) ]\n"
5147 : "\n"
5148 : "%s\n"
5149 : "\n"
5150 : " MODE '%s'\n"
5151 : " TIMEOUT '%s'\n"
5152 : " NO_THROW\n"
5153 : "\n"
5154 : "%s\n"
5155 : "\n"
5156 : " standby_replay | standby_write | standby_flush | primary_flush",
5157 : _("lsn"),
5158 : _("option"),
5159 : _("where option can be:"),
5160 : _("mode"),
5161 : _("timeout"),
5162 : _("and mode can be:"));
5163 0 : }
5164 :
5165 : static void
5166 0 : sql_help_WITH(PQExpBuffer buf)
5167 : {
5168 0 : appendPQExpBuffer(buf,
5169 : "[ WITH [ RECURSIVE ] %s [, ...] ]\n"
5170 : "SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n"
5171 : " [ { * | %s [ [ AS ] %s ] } [, ...] ]\n"
5172 : " [ FROM %s [, ...] ]\n"
5173 : " [ WHERE %s ]\n"
5174 : " [ GROUP BY { ALL | [ ALL | DISTINCT ] %s [, ...] } ]\n"
5175 : " [ HAVING %s ]\n"
5176 : " [ WINDOW %s AS ( %s ) [, ...] ]\n"
5177 : " [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n"
5178 : " [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n"
5179 : " [ LIMIT { %s | ALL } ]\n"
5180 : " [ OFFSET %s [ ROW | ROWS ] ]\n"
5181 : " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } { ONLY | WITH TIES } ]\n"
5182 : " [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF %s [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ]\n"
5183 : "\n"
5184 : "%s\n"
5185 : "\n"
5186 : " [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
5187 : " [ TABLESAMPLE %s ( %s [, ...] ) [ REPEATABLE ( %s ) ] ]\n"
5188 : " [ LATERAL ] ( %s ) [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
5189 : " %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
5190 : " [ LATERAL ] %s ( [ %s [, ...] ] )\n"
5191 : " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
5192 : " [ LATERAL ] %s ( [ %s [, ...] ] ) [ AS ] %s ( %s [, ...] )\n"
5193 : " [ LATERAL ] %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n"
5194 : " [ LATERAL ] ROWS FROM( %s ( [ %s [, ...] ] ) [ AS ( %s [, ...] ) ] [, ...] )\n"
5195 : " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n"
5196 : " %s %s %s { ON %s | USING ( %s [, ...] ) [ AS %s ] }\n"
5197 : " %s NATURAL %s %s\n"
5198 : " %s CROSS JOIN %s\n"
5199 : "\n"
5200 : "%s\n"
5201 : "\n"
5202 : " ( )\n"
5203 : " %s\n"
5204 : " ( %s [, ...] )\n"
5205 : " ROLLUP ( { %s | ( %s [, ...] ) } [, ...] )\n"
5206 : " CUBE ( { %s | ( %s [, ...] ) } [, ...] )\n"
5207 : " GROUPING SETS ( %s [, ...] )\n"
5208 : "\n"
5209 : "%s\n"
5210 : "\n"
5211 : " %s [ ( %s [, ...] ) ] AS [ [ NOT ] MATERIALIZED ] ( %s | %s | %s | %s | %s | %s )\n"
5212 : " [ SEARCH { BREADTH | DEPTH } FIRST BY %s [, ...] SET %s ]\n"
5213 : " [ CYCLE %s [, ...] SET %s [ TO %s DEFAULT %s ] USING %s ]\n"
5214 : "\n"
5215 : "TABLE [ ONLY ] %s [ * ]",
5216 : _("with_query"),
5217 : _("expression"),
5218 : _("expression"),
5219 : _("output_name"),
5220 : _("from_item"),
5221 : _("condition"),
5222 : _("grouping_element"),
5223 : _("condition"),
5224 : _("window_name"),
5225 : _("window_definition"),
5226 : _("select"),
5227 : _("expression"),
5228 : _("operator"),
5229 : _("count"),
5230 : _("start"),
5231 : _("count"),
5232 : _("from_reference"),
5233 : _("where from_item can be one of:"),
5234 : _("table_name"),
5235 : _("alias"),
5236 : _("column_alias"),
5237 : _("sampling_method"),
5238 : _("argument"),
5239 : _("seed"),
5240 : _("select"),
5241 : _("alias"),
5242 : _("column_alias"),
5243 : _("with_query_name"),
5244 : _("alias"),
5245 : _("column_alias"),
5246 : _("function_name"),
5247 : _("argument"),
5248 : _("alias"),
5249 : _("column_alias"),
5250 : _("function_name"),
5251 : _("argument"),
5252 : _("alias"),
5253 : _("column_definition"),
5254 : _("function_name"),
5255 : _("argument"),
5256 : _("column_definition"),
5257 : _("function_name"),
5258 : _("argument"),
5259 : _("column_definition"),
5260 : _("alias"),
5261 : _("column_alias"),
5262 : _("from_item"),
5263 : _("join_type"),
5264 : _("from_item"),
5265 : _("join_condition"),
5266 : _("join_column"),
5267 : _("join_using_alias"),
5268 : _("from_item"),
5269 : _("join_type"),
5270 : _("from_item"),
5271 : _("from_item"),
5272 : _("from_item"),
5273 : _("and grouping_element can be one of:"),
5274 : _("expression"),
5275 : _("expression"),
5276 : _("expression"),
5277 : _("expression"),
5278 : _("expression"),
5279 : _("expression"),
5280 : _("grouping_element"),
5281 : _("and with_query is:"),
5282 : _("with_query_name"),
5283 : _("column_name"),
5284 : _("select"),
5285 : _("values"),
5286 : _("insert"),
5287 : _("update"),
5288 : _("delete"),
5289 : _("merge"),
5290 : _("column_name"),
5291 : _("search_seq_col_name"),
5292 : _("column_name"),
5293 : _("cycle_mark_col_name"),
5294 : _("cycle_mark_value"),
5295 : _("cycle_mark_default"),
5296 : _("cycle_path_col_name"),
5297 : _("table_name"));
5298 0 : }
5299 :
5300 :
5301 : const struct _helpStruct QL_HELP[] = {
5302 : {"ABORT",
5303 : N_("abort the current transaction"),
5304 : "sql-abort",
5305 : sql_help_ABORT,
5306 : 0},
5307 :
5308 : {"ALTER AGGREGATE",
5309 : N_("change the definition of an aggregate function"),
5310 : "sql-alteraggregate",
5311 : sql_help_ALTER_AGGREGATE,
5312 : 9},
5313 :
5314 : {"ALTER COLLATION",
5315 : N_("change the definition of a collation"),
5316 : "sql-altercollation",
5317 : sql_help_ALTER_COLLATION,
5318 : 4},
5319 :
5320 : {"ALTER CONVERSION",
5321 : N_("change the definition of a conversion"),
5322 : "sql-alterconversion",
5323 : sql_help_ALTER_CONVERSION,
5324 : 2},
5325 :
5326 : {"ALTER DATABASE",
5327 : N_("change a database"),
5328 : "sql-alterdatabase",
5329 : sql_help_ALTER_DATABASE,
5330 : 19},
5331 :
5332 : {"ALTER DEFAULT PRIVILEGES",
5333 : N_("define default access privileges"),
5334 : "sql-alterdefaultprivileges",
5335 : sql_help_ALTER_DEFAULT_PRIVILEGES,
5336 : 73},
5337 :
5338 : {"ALTER DOMAIN",
5339 : N_("change the definition of a domain"),
5340 : "sql-alterdomain",
5341 : sql_help_ALTER_DOMAIN,
5342 : 22},
5343 :
5344 : {"ALTER EVENT TRIGGER",
5345 : N_("change the definition of an event trigger"),
5346 : "sql-altereventtrigger",
5347 : sql_help_ALTER_EVENT_TRIGGER,
5348 : 3},
5349 :
5350 : {"ALTER EXTENSION",
5351 : N_("change the definition of an extension"),
5352 : "sql-alterextension",
5353 : sql_help_ALTER_EXTENSION,
5354 : 40},
5355 :
5356 : {"ALTER FOREIGN DATA WRAPPER",
5357 : N_("change the definition of a foreign-data wrapper"),
5358 : "sql-alterforeigndatawrapper",
5359 : sql_help_ALTER_FOREIGN_DATA_WRAPPER,
5360 : 5},
5361 :
5362 : {"ALTER FOREIGN TABLE",
5363 : N_("change the definition of a foreign table"),
5364 : "sql-alterforeigntable",
5365 : sql_help_ALTER_FOREIGN_TABLE,
5366 : 33},
5367 :
5368 : {"ALTER FUNCTION",
5369 : N_("change the definition of a function"),
5370 : "sql-alterfunction",
5371 : sql_help_ALTER_FUNCTION,
5372 : 24},
5373 :
5374 : {"ALTER GROUP",
5375 : N_("change role name or membership"),
5376 : "sql-altergroup",
5377 : sql_help_ALTER_GROUP,
5378 : 10},
5379 :
5380 : {"ALTER INDEX",
5381 : N_("change the definition of an index"),
5382 : "sql-alterindex",
5383 : sql_help_ALTER_INDEX,
5384 : 9},
5385 :
5386 : {"ALTER LANGUAGE",
5387 : N_("change the definition of a procedural language"),
5388 : "sql-alterlanguage",
5389 : sql_help_ALTER_LANGUAGE,
5390 : 1},
5391 :
5392 : {"ALTER LARGE OBJECT",
5393 : N_("change the definition of a large object"),
5394 : "sql-alterlargeobject",
5395 : sql_help_ALTER_LARGE_OBJECT,
5396 : 0},
5397 :
5398 : {"ALTER MATERIALIZED VIEW",
5399 : N_("change the definition of a materialized view"),
5400 : "sql-altermaterializedview",
5401 : sql_help_ALTER_MATERIALIZED_VIEW,
5402 : 26},
5403 :
5404 : {"ALTER OPERATOR",
5405 : N_("change the definition of an operator"),
5406 : "sql-alteroperator",
5407 : sql_help_ALTER_OPERATOR,
5408 : 13},
5409 :
5410 : {"ALTER OPERATOR CLASS",
5411 : N_("change the definition of an operator class"),
5412 : "sql-alteropclass",
5413 : sql_help_ALTER_OPERATOR_CLASS,
5414 : 7},
5415 :
5416 : {"ALTER OPERATOR FAMILY",
5417 : N_("change the definition of an operator family"),
5418 : "sql-alteropfamily",
5419 : sql_help_ALTER_OPERATOR_FAMILY,
5420 : 19},
5421 :
5422 : {"ALTER POLICY",
5423 : N_("change the definition of a row-level security policy"),
5424 : "sql-alterpolicy",
5425 : sql_help_ALTER_POLICY,
5426 : 5},
5427 :
5428 : {"ALTER PROCEDURE",
5429 : N_("change the definition of a procedure"),
5430 : "sql-alterprocedure",
5431 : sql_help_ALTER_PROCEDURE,
5432 : 17},
5433 :
5434 : {"ALTER PUBLICATION",
5435 : N_("change the definition of a publication"),
5436 : "sql-alterpublication",
5437 : sql_help_ALTER_PUBLICATION,
5438 : 19},
5439 :
5440 : {"ALTER ROLE",
5441 : N_("change a database role"),
5442 : "sql-alterrole",
5443 : sql_help_ALTER_ROLE,
5444 : 27},
5445 :
5446 : {"ALTER ROUTINE",
5447 : N_("change the definition of a routine"),
5448 : "sql-alterroutine",
5449 : sql_help_ALTER_ROUTINE,
5450 : 22},
5451 :
5452 : {"ALTER RULE",
5453 : N_("change the definition of a rule"),
5454 : "sql-alterrule",
5455 : sql_help_ALTER_RULE,
5456 : 0},
5457 :
5458 : {"ALTER SCHEMA",
5459 : N_("change the definition of a schema"),
5460 : "sql-alterschema",
5461 : sql_help_ALTER_SCHEMA,
5462 : 1},
5463 :
5464 : {"ALTER SEQUENCE",
5465 : N_("change the definition of a sequence generator"),
5466 : "sql-altersequence",
5467 : sql_help_ALTER_SEQUENCE,
5468 : 12},
5469 :
5470 : {"ALTER SERVER",
5471 : N_("change the definition of a foreign server"),
5472 : "sql-alterserver",
5473 : sql_help_ALTER_SERVER,
5474 : 3},
5475 :
5476 : {"ALTER STATISTICS",
5477 : N_("change the definition of an extended statistics object"),
5478 : "sql-alterstatistics",
5479 : sql_help_ALTER_STATISTICS,
5480 : 3},
5481 :
5482 : {"ALTER SUBSCRIPTION",
5483 : N_("change the definition of a subscription"),
5484 : "sql-altersubscription",
5485 : sql_help_ALTER_SUBSCRIPTION,
5486 : 11},
5487 :
5488 : {"ALTER SYSTEM",
5489 : N_("change a server configuration parameter"),
5490 : "sql-altersystem",
5491 : sql_help_ALTER_SYSTEM,
5492 : 3},
5493 :
5494 : {"ALTER TABLE",
5495 : N_("change the definition of a table"),
5496 : "sql-altertable",
5497 : sql_help_ALTER_TABLE,
5498 : 126},
5499 :
5500 : {"ALTER TABLESPACE",
5501 : N_("change the definition of a tablespace"),
5502 : "sql-altertablespace",
5503 : sql_help_ALTER_TABLESPACE,
5504 : 3},
5505 :
5506 : {"ALTER TEXT SEARCH CONFIGURATION",
5507 : N_("change the definition of a text search configuration"),
5508 : "sql-altertsconfig",
5509 : sql_help_ALTER_TEXT_SEARCH_CONFIGURATION,
5510 : 12},
5511 :
5512 : {"ALTER TEXT SEARCH DICTIONARY",
5513 : N_("change the definition of a text search dictionary"),
5514 : "sql-altertsdictionary",
5515 : sql_help_ALTER_TEXT_SEARCH_DICTIONARY,
5516 : 5},
5517 :
5518 : {"ALTER TEXT SEARCH PARSER",
5519 : N_("change the definition of a text search parser"),
5520 : "sql-altertsparser",
5521 : sql_help_ALTER_TEXT_SEARCH_PARSER,
5522 : 1},
5523 :
5524 : {"ALTER TEXT SEARCH TEMPLATE",
5525 : N_("change the definition of a text search template"),
5526 : "sql-altertstemplate",
5527 : sql_help_ALTER_TEXT_SEARCH_TEMPLATE,
5528 : 1},
5529 :
5530 : {"ALTER TRIGGER",
5531 : N_("change the definition of a trigger"),
5532 : "sql-altertrigger",
5533 : sql_help_ALTER_TRIGGER,
5534 : 1},
5535 :
5536 : {"ALTER TYPE",
5537 : N_("change the definition of a type"),
5538 : "sql-altertype",
5539 : sql_help_ALTER_TYPE,
5540 : 13},
5541 :
5542 : {"ALTER USER",
5543 : N_("change a database role"),
5544 : "sql-alteruser",
5545 : sql_help_ALTER_USER,
5546 : 27},
5547 :
5548 : {"ALTER USER MAPPING",
5549 : N_("change the definition of a user mapping"),
5550 : "sql-alterusermapping",
5551 : sql_help_ALTER_USER_MAPPING,
5552 : 2},
5553 :
5554 : {"ALTER VIEW",
5555 : N_("change the definition of a view"),
5556 : "sql-alterview",
5557 : sql_help_ALTER_VIEW,
5558 : 7},
5559 :
5560 : {"ANALYZE",
5561 : N_("collect statistics about a database"),
5562 : "sql-analyze",
5563 : sql_help_ANALYZE,
5564 : 10},
5565 :
5566 : {"BEGIN",
5567 : N_("start a transaction block"),
5568 : "sql-begin",
5569 : sql_help_BEGIN,
5570 : 6},
5571 :
5572 : {"CALL",
5573 : N_("invoke a procedure"),
5574 : "sql-call",
5575 : sql_help_CALL,
5576 : 0},
5577 :
5578 : {"CHECKPOINT",
5579 : N_("force a write-ahead log checkpoint"),
5580 : "sql-checkpoint",
5581 : sql_help_CHECKPOINT,
5582 : 5},
5583 :
5584 : {"CLOSE",
5585 : N_("close a cursor"),
5586 : "sql-close",
5587 : sql_help_CLOSE,
5588 : 0},
5589 :
5590 : {"CLUSTER",
5591 : N_("cluster a table according to an index"),
5592 : "sql-cluster",
5593 : sql_help_CLUSTER,
5594 : 4},
5595 :
5596 : {"COMMENT",
5597 : N_("define or change the comment of an object"),
5598 : "sql-comment",
5599 : sql_help_COMMENT,
5600 : 51},
5601 :
5602 : {"COMMIT",
5603 : N_("commit the current transaction"),
5604 : "sql-commit",
5605 : sql_help_COMMIT,
5606 : 0},
5607 :
5608 : {"COMMIT PREPARED",
5609 : N_("commit a transaction that was earlier prepared for two-phase commit"),
5610 : "sql-commit-prepared",
5611 : sql_help_COMMIT_PREPARED,
5612 : 0},
5613 :
5614 : {"COPY",
5615 : N_("copy data between a file and a table"),
5616 : "sql-copy",
5617 : sql_help_COPY,
5618 : 25},
5619 :
5620 : {"CREATE ACCESS METHOD",
5621 : N_("define a new access method"),
5622 : "sql-create-access-method",
5623 : sql_help_CREATE_ACCESS_METHOD,
5624 : 2},
5625 :
5626 : {"CREATE AGGREGATE",
5627 : N_("define a new aggregate function"),
5628 : "sql-createaggregate",
5629 : sql_help_CREATE_AGGREGATE,
5630 : 59},
5631 :
5632 : {"CREATE CAST",
5633 : N_("define a new cast"),
5634 : "sql-createcast",
5635 : sql_help_CREATE_CAST,
5636 : 10},
5637 :
5638 : {"CREATE COLLATION",
5639 : N_("define a new collation"),
5640 : "sql-createcollation",
5641 : sql_help_CREATE_COLLATION,
5642 : 9},
5643 :
5644 : {"CREATE CONVERSION",
5645 : N_("define a new encoding conversion"),
5646 : "sql-createconversion",
5647 : sql_help_CREATE_CONVERSION,
5648 : 1},
5649 :
5650 : {"CREATE DATABASE",
5651 : N_("create a new database"),
5652 : "sql-createdatabase",
5653 : sql_help_CREATE_DATABASE,
5654 : 17},
5655 :
5656 : {"CREATE DOMAIN",
5657 : N_("define a new domain"),
5658 : "sql-createdomain",
5659 : sql_help_CREATE_DOMAIN,
5660 : 8},
5661 :
5662 : {"CREATE EVENT TRIGGER",
5663 : N_("define a new event trigger"),
5664 : "sql-createeventtrigger",
5665 : sql_help_CREATE_EVENT_TRIGGER,
5666 : 3},
5667 :
5668 : {"CREATE EXTENSION",
5669 : N_("install an extension"),
5670 : "sql-createextension",
5671 : sql_help_CREATE_EXTENSION,
5672 : 3},
5673 :
5674 : {"CREATE FOREIGN DATA WRAPPER",
5675 : N_("define a new foreign-data wrapper"),
5676 : "sql-createforeigndatawrapper",
5677 : sql_help_CREATE_FOREIGN_DATA_WRAPPER,
5678 : 3},
5679 :
5680 : {"CREATE FOREIGN TABLE",
5681 : N_("define a new foreign table"),
5682 : "sql-createforeigntable",
5683 : sql_help_CREATE_FOREIGN_TABLE,
5684 : 46},
5685 :
5686 : {"CREATE FUNCTION",
5687 : N_("define a new function"),
5688 : "sql-createfunction",
5689 : sql_help_CREATE_FUNCTION,
5690 : 19},
5691 :
5692 : {"CREATE GROUP",
5693 : N_("define a new database role"),
5694 : "sql-creategroup",
5695 : sql_help_CREATE_GROUP,
5696 : 17},
5697 :
5698 : {"CREATE INDEX",
5699 : N_("define a new index"),
5700 : "sql-createindex",
5701 : sql_help_CREATE_INDEX,
5702 : 6},
5703 :
5704 : {"CREATE LANGUAGE",
5705 : N_("define a new procedural language"),
5706 : "sql-createlanguage",
5707 : sql_help_CREATE_LANGUAGE,
5708 : 2},
5709 :
5710 : {"CREATE MATERIALIZED VIEW",
5711 : N_("define a new materialized view"),
5712 : "sql-creatematerializedview",
5713 : sql_help_CREATE_MATERIALIZED_VIEW,
5714 : 6},
5715 :
5716 : {"CREATE OPERATOR",
5717 : N_("define a new operator"),
5718 : "sql-createoperator",
5719 : sql_help_CREATE_OPERATOR,
5720 : 6},
5721 :
5722 : {"CREATE OPERATOR CLASS",
5723 : N_("define a new operator class"),
5724 : "sql-createopclass",
5725 : sql_help_CREATE_OPERATOR_CLASS,
5726 : 5},
5727 :
5728 : {"CREATE OPERATOR FAMILY",
5729 : N_("define a new operator family"),
5730 : "sql-createopfamily",
5731 : sql_help_CREATE_OPERATOR_FAMILY,
5732 : 0},
5733 :
5734 : {"CREATE POLICY",
5735 : N_("define a new row-level security policy for a table"),
5736 : "sql-createpolicy",
5737 : sql_help_CREATE_POLICY,
5738 : 5},
5739 :
5740 : {"CREATE PROCEDURE",
5741 : N_("define a new procedure"),
5742 : "sql-createprocedure",
5743 : sql_help_CREATE_PROCEDURE,
5744 : 9},
5745 :
5746 : {"CREATE PUBLICATION",
5747 : N_("define a new publication"),
5748 : "sql-createpublication",
5749 : sql_help_CREATE_PUBLICATION,
5750 : 16},
5751 :
5752 : {"CREATE ROLE",
5753 : N_("define a new database role"),
5754 : "sql-createrole",
5755 : sql_help_CREATE_ROLE,
5756 : 17},
5757 :
5758 : {"CREATE RULE",
5759 : N_("define a new rewrite rule"),
5760 : "sql-createrule",
5761 : sql_help_CREATE_RULE,
5762 : 6},
5763 :
5764 : {"CREATE SCHEMA",
5765 : N_("define a new schema"),
5766 : "sql-createschema",
5767 : sql_help_CREATE_SCHEMA,
5768 : 10},
5769 :
5770 : {"CREATE SEQUENCE",
5771 : N_("define a new sequence generator"),
5772 : "sql-createsequence",
5773 : sql_help_CREATE_SEQUENCE,
5774 : 7},
5775 :
5776 : {"CREATE SERVER",
5777 : N_("define a new foreign server"),
5778 : "sql-createserver",
5779 : sql_help_CREATE_SERVER,
5780 : 2},
5781 :
5782 : {"CREATE STATISTICS",
5783 : N_("define extended statistics"),
5784 : "sql-createstatistics",
5785 : sql_help_CREATE_STATISTICS,
5786 : 7},
5787 :
5788 : {"CREATE SUBSCRIPTION",
5789 : N_("define a new subscription"),
5790 : "sql-createsubscription",
5791 : sql_help_CREATE_SUBSCRIPTION,
5792 : 3},
5793 :
5794 : {"CREATE TABLE",
5795 : N_("define a new table"),
5796 : "sql-createtable",
5797 : sql_help_CREATE_TABLE,
5798 : 88},
5799 :
5800 : {"CREATE TABLE AS",
5801 : N_("define a new table from the results of a query"),
5802 : "sql-createtableas",
5803 : sql_help_CREATE_TABLE_AS,
5804 : 7},
5805 :
5806 : {"CREATE TABLESPACE",
5807 : N_("define a new tablespace"),
5808 : "sql-createtablespace",
5809 : sql_help_CREATE_TABLESPACE,
5810 : 3},
5811 :
5812 : {"CREATE TEXT SEARCH CONFIGURATION",
5813 : N_("define a new text search configuration"),
5814 : "sql-createtsconfig",
5815 : sql_help_CREATE_TEXT_SEARCH_CONFIGURATION,
5816 : 3},
5817 :
5818 : {"CREATE TEXT SEARCH DICTIONARY",
5819 : N_("define a new text search dictionary"),
5820 : "sql-createtsdictionary",
5821 : sql_help_CREATE_TEXT_SEARCH_DICTIONARY,
5822 : 3},
5823 :
5824 : {"CREATE TEXT SEARCH PARSER",
5825 : N_("define a new text search parser"),
5826 : "sql-createtsparser",
5827 : sql_help_CREATE_TEXT_SEARCH_PARSER,
5828 : 6},
5829 :
5830 : {"CREATE TEXT SEARCH TEMPLATE",
5831 : N_("define a new text search template"),
5832 : "sql-createtstemplate",
5833 : sql_help_CREATE_TEXT_SEARCH_TEMPLATE,
5834 : 3},
5835 :
5836 : {"CREATE TRANSFORM",
5837 : N_("define a new transform"),
5838 : "sql-createtransform",
5839 : sql_help_CREATE_TRANSFORM,
5840 : 3},
5841 :
5842 : {"CREATE TRIGGER",
5843 : N_("define a new trigger"),
5844 : "sql-createtrigger",
5845 : sql_help_CREATE_TRIGGER,
5846 : 14},
5847 :
5848 : {"CREATE TYPE",
5849 : N_("define a new data type"),
5850 : "sql-createtype",
5851 : sql_help_CREATE_TYPE,
5852 : 37},
5853 :
5854 : {"CREATE USER",
5855 : N_("define a new database role"),
5856 : "sql-createuser",
5857 : sql_help_CREATE_USER,
5858 : 17},
5859 :
5860 : {"CREATE USER MAPPING",
5861 : N_("define a new mapping of a user to a foreign server"),
5862 : "sql-createusermapping",
5863 : sql_help_CREATE_USER_MAPPING,
5864 : 2},
5865 :
5866 : {"CREATE VIEW",
5867 : N_("define a new view"),
5868 : "sql-createview",
5869 : sql_help_CREATE_VIEW,
5870 : 3},
5871 :
5872 : {"DEALLOCATE",
5873 : N_("deallocate a prepared statement"),
5874 : "sql-deallocate",
5875 : sql_help_DEALLOCATE,
5876 : 0},
5877 :
5878 : {"DECLARE",
5879 : N_("define a cursor"),
5880 : "sql-declare",
5881 : sql_help_DECLARE,
5882 : 1},
5883 :
5884 : {"DELETE",
5885 : N_("delete rows of a table"),
5886 : "sql-delete",
5887 : sql_help_DELETE,
5888 : 5},
5889 :
5890 : {"DISCARD",
5891 : N_("discard session state"),
5892 : "sql-discard",
5893 : sql_help_DISCARD,
5894 : 0},
5895 :
5896 : {"DO",
5897 : N_("execute an anonymous code block"),
5898 : "sql-do",
5899 : sql_help_DO,
5900 : 0},
5901 :
5902 : {"DROP ACCESS METHOD",
5903 : N_("remove an access method"),
5904 : "sql-drop-access-method",
5905 : sql_help_DROP_ACCESS_METHOD,
5906 : 0},
5907 :
5908 : {"DROP AGGREGATE",
5909 : N_("remove an aggregate function"),
5910 : "sql-dropaggregate",
5911 : sql_help_DROP_AGGREGATE,
5912 : 6},
5913 :
5914 : {"DROP CAST",
5915 : N_("remove a cast"),
5916 : "sql-dropcast",
5917 : sql_help_DROP_CAST,
5918 : 0},
5919 :
5920 : {"DROP COLLATION",
5921 : N_("remove a collation"),
5922 : "sql-dropcollation",
5923 : sql_help_DROP_COLLATION,
5924 : 0},
5925 :
5926 : {"DROP CONVERSION",
5927 : N_("remove a conversion"),
5928 : "sql-dropconversion",
5929 : sql_help_DROP_CONVERSION,
5930 : 0},
5931 :
5932 : {"DROP DATABASE",
5933 : N_("remove a database"),
5934 : "sql-dropdatabase",
5935 : sql_help_DROP_DATABASE,
5936 : 4},
5937 :
5938 : {"DROP DOMAIN",
5939 : N_("remove a domain"),
5940 : "sql-dropdomain",
5941 : sql_help_DROP_DOMAIN,
5942 : 0},
5943 :
5944 : {"DROP EVENT TRIGGER",
5945 : N_("remove an event trigger"),
5946 : "sql-dropeventtrigger",
5947 : sql_help_DROP_EVENT_TRIGGER,
5948 : 0},
5949 :
5950 : {"DROP EXTENSION",
5951 : N_("remove an extension"),
5952 : "sql-dropextension",
5953 : sql_help_DROP_EXTENSION,
5954 : 0},
5955 :
5956 : {"DROP FOREIGN DATA WRAPPER",
5957 : N_("remove a foreign-data wrapper"),
5958 : "sql-dropforeigndatawrapper",
5959 : sql_help_DROP_FOREIGN_DATA_WRAPPER,
5960 : 0},
5961 :
5962 : {"DROP FOREIGN TABLE",
5963 : N_("remove a foreign table"),
5964 : "sql-dropforeigntable",
5965 : sql_help_DROP_FOREIGN_TABLE,
5966 : 0},
5967 :
5968 : {"DROP FUNCTION",
5969 : N_("remove a function"),
5970 : "sql-dropfunction",
5971 : sql_help_DROP_FUNCTION,
5972 : 1},
5973 :
5974 : {"DROP GROUP",
5975 : N_("remove a database role"),
5976 : "sql-dropgroup",
5977 : sql_help_DROP_GROUP,
5978 : 0},
5979 :
5980 : {"DROP INDEX",
5981 : N_("remove an index"),
5982 : "sql-dropindex",
5983 : sql_help_DROP_INDEX,
5984 : 0},
5985 :
5986 : {"DROP LANGUAGE",
5987 : N_("remove a procedural language"),
5988 : "sql-droplanguage",
5989 : sql_help_DROP_LANGUAGE,
5990 : 0},
5991 :
5992 : {"DROP MATERIALIZED VIEW",
5993 : N_("remove a materialized view"),
5994 : "sql-dropmaterializedview",
5995 : sql_help_DROP_MATERIALIZED_VIEW,
5996 : 0},
5997 :
5998 : {"DROP OPERATOR",
5999 : N_("remove an operator"),
6000 : "sql-dropoperator",
6001 : sql_help_DROP_OPERATOR,
6002 : 0},
6003 :
6004 : {"DROP OPERATOR CLASS",
6005 : N_("remove an operator class"),
6006 : "sql-dropopclass",
6007 : sql_help_DROP_OPERATOR_CLASS,
6008 : 0},
6009 :
6010 : {"DROP OPERATOR FAMILY",
6011 : N_("remove an operator family"),
6012 : "sql-dropopfamily",
6013 : sql_help_DROP_OPERATOR_FAMILY,
6014 : 0},
6015 :
6016 : {"DROP OWNED",
6017 : N_("remove database objects owned by a database role"),
6018 : "sql-drop-owned",
6019 : sql_help_DROP_OWNED,
6020 : 0},
6021 :
6022 : {"DROP POLICY",
6023 : N_("remove a row-level security policy from a table"),
6024 : "sql-droppolicy",
6025 : sql_help_DROP_POLICY,
6026 : 0},
6027 :
6028 : {"DROP PROCEDURE",
6029 : N_("remove a procedure"),
6030 : "sql-dropprocedure",
6031 : sql_help_DROP_PROCEDURE,
6032 : 1},
6033 :
6034 : {"DROP PUBLICATION",
6035 : N_("remove a publication"),
6036 : "sql-droppublication",
6037 : sql_help_DROP_PUBLICATION,
6038 : 0},
6039 :
6040 : {"DROP ROLE",
6041 : N_("remove a database role"),
6042 : "sql-droprole",
6043 : sql_help_DROP_ROLE,
6044 : 0},
6045 :
6046 : {"DROP ROUTINE",
6047 : N_("remove a routine"),
6048 : "sql-droproutine",
6049 : sql_help_DROP_ROUTINE,
6050 : 1},
6051 :
6052 : {"DROP RULE",
6053 : N_("remove a rewrite rule"),
6054 : "sql-droprule",
6055 : sql_help_DROP_RULE,
6056 : 0},
6057 :
6058 : {"DROP SCHEMA",
6059 : N_("remove a schema"),
6060 : "sql-dropschema",
6061 : sql_help_DROP_SCHEMA,
6062 : 0},
6063 :
6064 : {"DROP SEQUENCE",
6065 : N_("remove a sequence"),
6066 : "sql-dropsequence",
6067 : sql_help_DROP_SEQUENCE,
6068 : 0},
6069 :
6070 : {"DROP SERVER",
6071 : N_("remove a foreign server descriptor"),
6072 : "sql-dropserver",
6073 : sql_help_DROP_SERVER,
6074 : 0},
6075 :
6076 : {"DROP STATISTICS",
6077 : N_("remove extended statistics"),
6078 : "sql-dropstatistics",
6079 : sql_help_DROP_STATISTICS,
6080 : 0},
6081 :
6082 : {"DROP SUBSCRIPTION",
6083 : N_("remove a subscription"),
6084 : "sql-dropsubscription",
6085 : sql_help_DROP_SUBSCRIPTION,
6086 : 0},
6087 :
6088 : {"DROP TABLE",
6089 : N_("remove a table"),
6090 : "sql-droptable",
6091 : sql_help_DROP_TABLE,
6092 : 0},
6093 :
6094 : {"DROP TABLESPACE",
6095 : N_("remove a tablespace"),
6096 : "sql-droptablespace",
6097 : sql_help_DROP_TABLESPACE,
6098 : 0},
6099 :
6100 : {"DROP TEXT SEARCH CONFIGURATION",
6101 : N_("remove a text search configuration"),
6102 : "sql-droptsconfig",
6103 : sql_help_DROP_TEXT_SEARCH_CONFIGURATION,
6104 : 0},
6105 :
6106 : {"DROP TEXT SEARCH DICTIONARY",
6107 : N_("remove a text search dictionary"),
6108 : "sql-droptsdictionary",
6109 : sql_help_DROP_TEXT_SEARCH_DICTIONARY,
6110 : 0},
6111 :
6112 : {"DROP TEXT SEARCH PARSER",
6113 : N_("remove a text search parser"),
6114 : "sql-droptsparser",
6115 : sql_help_DROP_TEXT_SEARCH_PARSER,
6116 : 0},
6117 :
6118 : {"DROP TEXT SEARCH TEMPLATE",
6119 : N_("remove a text search template"),
6120 : "sql-droptstemplate",
6121 : sql_help_DROP_TEXT_SEARCH_TEMPLATE,
6122 : 0},
6123 :
6124 : {"DROP TRANSFORM",
6125 : N_("remove a transform"),
6126 : "sql-droptransform",
6127 : sql_help_DROP_TRANSFORM,
6128 : 0},
6129 :
6130 : {"DROP TRIGGER",
6131 : N_("remove a trigger"),
6132 : "sql-droptrigger",
6133 : sql_help_DROP_TRIGGER,
6134 : 0},
6135 :
6136 : {"DROP TYPE",
6137 : N_("remove a data type"),
6138 : "sql-droptype",
6139 : sql_help_DROP_TYPE,
6140 : 0},
6141 :
6142 : {"DROP USER",
6143 : N_("remove a database role"),
6144 : "sql-dropuser",
6145 : sql_help_DROP_USER,
6146 : 0},
6147 :
6148 : {"DROP USER MAPPING",
6149 : N_("remove a user mapping for a foreign server"),
6150 : "sql-dropusermapping",
6151 : sql_help_DROP_USER_MAPPING,
6152 : 0},
6153 :
6154 : {"DROP VIEW",
6155 : N_("remove a view"),
6156 : "sql-dropview",
6157 : sql_help_DROP_VIEW,
6158 : 0},
6159 :
6160 : {"END",
6161 : N_("commit the current transaction"),
6162 : "sql-end",
6163 : sql_help_END,
6164 : 0},
6165 :
6166 : {"EXECUTE",
6167 : N_("execute a prepared statement"),
6168 : "sql-execute",
6169 : sql_help_EXECUTE,
6170 : 0},
6171 :
6172 : {"EXPLAIN",
6173 : N_("show the execution plan of a statement"),
6174 : "sql-explain",
6175 : sql_help_EXPLAIN,
6176 : 15},
6177 :
6178 : {"FETCH",
6179 : N_("retrieve rows from a query using a cursor"),
6180 : "sql-fetch",
6181 : sql_help_FETCH,
6182 : 17},
6183 :
6184 : {"GRANT",
6185 : N_("define access privileges"),
6186 : "sql-grant",
6187 : sql_help_GRANT,
6188 : 86},
6189 :
6190 : {"IMPORT FOREIGN SCHEMA",
6191 : N_("import table definitions from a foreign server"),
6192 : "sql-importforeignschema",
6193 : sql_help_IMPORT_FOREIGN_SCHEMA,
6194 : 4},
6195 :
6196 : {"INSERT",
6197 : N_("create new rows in a table"),
6198 : "sql-insert",
6199 : sql_help_INSERT,
6200 : 21},
6201 :
6202 : {"LISTEN",
6203 : N_("listen for a notification"),
6204 : "sql-listen",
6205 : sql_help_LISTEN,
6206 : 0},
6207 :
6208 : {"LOAD",
6209 : N_("load a shared library file"),
6210 : "sql-load",
6211 : sql_help_LOAD,
6212 : 0},
6213 :
6214 : {"LOCK",
6215 : N_("lock a table"),
6216 : "sql-lock",
6217 : sql_help_LOCK,
6218 : 5},
6219 :
6220 : {"MERGE",
6221 : N_("conditionally insert, update, or delete rows of a table"),
6222 : "sql-merge",
6223 : sql_help_MERGE,
6224 : 32},
6225 :
6226 : {"MOVE",
6227 : N_("position a cursor"),
6228 : "sql-move",
6229 : sql_help_MOVE,
6230 : 17},
6231 :
6232 : {"NOTIFY",
6233 : N_("generate a notification"),
6234 : "sql-notify",
6235 : sql_help_NOTIFY,
6236 : 0},
6237 :
6238 : {"PREPARE",
6239 : N_("prepare a statement for execution"),
6240 : "sql-prepare",
6241 : sql_help_PREPARE,
6242 : 0},
6243 :
6244 : {"PREPARE TRANSACTION",
6245 : N_("prepare the current transaction for two-phase commit"),
6246 : "sql-prepare-transaction",
6247 : sql_help_PREPARE_TRANSACTION,
6248 : 0},
6249 :
6250 : {"REASSIGN OWNED",
6251 : N_("change the ownership of database objects owned by a database role"),
6252 : "sql-reassign-owned",
6253 : sql_help_REASSIGN_OWNED,
6254 : 1},
6255 :
6256 : {"REFRESH MATERIALIZED VIEW",
6257 : N_("replace the contents of a materialized view"),
6258 : "sql-refreshmaterializedview",
6259 : sql_help_REFRESH_MATERIALIZED_VIEW,
6260 : 1},
6261 :
6262 : {"REINDEX",
6263 : N_("rebuild indexes"),
6264 : "sql-reindex",
6265 : sql_help_REINDEX,
6266 : 7},
6267 :
6268 : {"RELEASE SAVEPOINT",
6269 : N_("release a previously defined savepoint"),
6270 : "sql-release-savepoint",
6271 : sql_help_RELEASE_SAVEPOINT,
6272 : 0},
6273 :
6274 : {"RESET",
6275 : N_("restore the value of a run-time parameter to the default value"),
6276 : "sql-reset",
6277 : sql_help_RESET,
6278 : 1},
6279 :
6280 : {"REVOKE",
6281 : N_("remove access privileges"),
6282 : "sql-revoke",
6283 : sql_help_REVOKE,
6284 : 115},
6285 :
6286 : {"ROLLBACK",
6287 : N_("abort the current transaction"),
6288 : "sql-rollback",
6289 : sql_help_ROLLBACK,
6290 : 0},
6291 :
6292 : {"ROLLBACK PREPARED",
6293 : N_("cancel a transaction that was earlier prepared for two-phase commit"),
6294 : "sql-rollback-prepared",
6295 : sql_help_ROLLBACK_PREPARED,
6296 : 0},
6297 :
6298 : {"ROLLBACK TO SAVEPOINT",
6299 : N_("roll back to a savepoint"),
6300 : "sql-rollback-to",
6301 : sql_help_ROLLBACK_TO_SAVEPOINT,
6302 : 0},
6303 :
6304 : {"SAVEPOINT",
6305 : N_("define a new savepoint within the current transaction"),
6306 : "sql-savepoint",
6307 : sql_help_SAVEPOINT,
6308 : 0},
6309 :
6310 : {"SECURITY LABEL",
6311 : N_("define or change a security label applied to an object"),
6312 : "sql-security-label",
6313 : sql_help_SECURITY_LABEL,
6314 : 29},
6315 :
6316 : {"SELECT",
6317 : N_("retrieve rows from a table or view"),
6318 : "sql-select",
6319 : sql_help_SELECT,
6320 : 46},
6321 :
6322 : {"SELECT INTO",
6323 : N_("define a new table from the results of a query"),
6324 : "sql-selectinto",
6325 : sql_help_SELECT_INTO,
6326 : 14},
6327 :
6328 : {"SET",
6329 : N_("change a run-time parameter"),
6330 : "sql-set",
6331 : sql_help_SET,
6332 : 1},
6333 :
6334 : {"SET CONSTRAINTS",
6335 : N_("set constraint check timing for the current transaction"),
6336 : "sql-set-constraints",
6337 : sql_help_SET_CONSTRAINTS,
6338 : 0},
6339 :
6340 : {"SET ROLE",
6341 : N_("set the current user identifier of the current session"),
6342 : "sql-set-role",
6343 : sql_help_SET_ROLE,
6344 : 2},
6345 :
6346 : {"SET SESSION AUTHORIZATION",
6347 : N_("set the session user identifier and the current user identifier of the current session"),
6348 : "sql-set-session-authorization",
6349 : sql_help_SET_SESSION_AUTHORIZATION,
6350 : 2},
6351 :
6352 : {"SET TRANSACTION",
6353 : N_("set the characteristics of the current transaction"),
6354 : "sql-set-transaction",
6355 : sql_help_SET_TRANSACTION,
6356 : 8},
6357 :
6358 : {"SHOW",
6359 : N_("show the value of a run-time parameter"),
6360 : "sql-show",
6361 : sql_help_SHOW,
6362 : 1},
6363 :
6364 : {"START TRANSACTION",
6365 : N_("start a transaction block"),
6366 : "sql-start-transaction",
6367 : sql_help_START_TRANSACTION,
6368 : 6},
6369 :
6370 : {"TABLE",
6371 : N_("retrieve rows from a table or view"),
6372 : "sql-select",
6373 : sql_help_TABLE,
6374 : 46},
6375 :
6376 : {"TRUNCATE",
6377 : N_("empty a table or set of tables"),
6378 : "sql-truncate",
6379 : sql_help_TRUNCATE,
6380 : 1},
6381 :
6382 : {"UNLISTEN",
6383 : N_("stop listening for a notification"),
6384 : "sql-unlisten",
6385 : sql_help_UNLISTEN,
6386 : 0},
6387 :
6388 : {"UPDATE",
6389 : N_("update rows of a table"),
6390 : "sql-update",
6391 : sql_help_UPDATE,
6392 : 9},
6393 :
6394 : {"VACUUM",
6395 : N_("garbage-collect and optionally analyze a database"),
6396 : "sql-vacuum",
6397 : sql_help_VACUUM,
6398 : 21},
6399 :
6400 : {"VALUES",
6401 : N_("compute a set of rows"),
6402 : "sql-values",
6403 : sql_help_VALUES,
6404 : 4},
6405 :
6406 : {"WAIT FOR",
6407 : N_("wait for WAL to reach a target LSN"),
6408 : "sql-wait-for",
6409 : sql_help_WAIT_FOR,
6410 : 11},
6411 :
6412 : {"WITH",
6413 : N_("retrieve rows from a table or view"),
6414 : "sql-select",
6415 : sql_help_WITH,
6416 : 46},
6417 :
6418 :
6419 : {NULL, NULL, NULL} /* End of list marker */
6420 : };
|
