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