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