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