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