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