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