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