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