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