sql_help.c source code [PostgreSQL/src/bin/psql/sql_help.c]

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

Browse the source code of PostgreSQL/src/bin/psql/sql_help.c