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