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 ]"); 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 WITH OIDS\n" 436 " SET WITHOUT OIDS\n" 437 " INHERIT %s\n" 438 " NO INHERIT %s\n" 439 " OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 440 " OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ])", 441 _("name"), 442 _("action"), 443 _("name"), 444 _("column_name"), 445 _("new_column_name"), 446 _("name"), 447 _("new_name"), 448 _("name"), 449 _("new_schema"), 450 _("where action is one of:"), 451 _("column_name"), 452 _("data_type"), 453 _("collation"), 454 _("column_constraint"), 455 _("column_name"), 456 _("column_name"), 457 _("data_type"), 458 _("collation"), 459 _("column_name"), 460 _("expression"), 461 _("column_name"), 462 _("column_name"), 463 _("column_name"), 464 _("integer"), 465 _("column_name"), 466 _("attribute_option"), 467 _("value"), 468 _("column_name"), 469 _("attribute_option"), 470 _("column_name"), 471 _("column_name"), 472 _("option"), 473 _("value"), 474 _("table_constraint"), 475 _("constraint_name"), 476 _("constraint_name"), 477 _("trigger_name"), 478 _("trigger_name"), 479 _("trigger_name"), 480 _("trigger_name"), 481 _("parent_table"), 482 _("parent_table"), 483 _("new_owner"), 484 _("option"), 485 _("value")); 486 } 487 488 static void 489 sql_help_ALTER_FUNCTION(PQExpBuffer buf) 490 { 491 appendPQExpBuffer(buf, 492 "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n" 493 " %s [ ... ] [ RESTRICT ]\n" 494 "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n" 495 " RENAME TO %s\n" 496 "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n" 497 " OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 498 "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n" 499 " SET SCHEMA %s\n" 500 "ALTER FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ]\n" 501 " DEPENDS ON EXTENSION %s\n" 502 "\n" 503 "%s\n" 504 "\n" 505 " CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT\n" 506 " IMMUTABLE | STABLE | VOLATILE\n" 507 " [ NOT ] LEAKPROOF\n" 508 " [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n" 509 " PARALLEL { UNSAFE | RESTRICTED | SAFE }\n" 510 " COST %s\n" 511 " ROWS %s\n" 512 " SET %s { TO | = } { %s | DEFAULT }\n" 513 " SET %s FROM CURRENT\n" 514 " RESET %s\n" 515 " RESET ALL", 516 _("name"), 517 _("argmode"), 518 _("argname"), 519 _("argtype"), 520 _("action"), 521 _("name"), 522 _("argmode"), 523 _("argname"), 524 _("argtype"), 525 _("new_name"), 526 _("name"), 527 _("argmode"), 528 _("argname"), 529 _("argtype"), 530 _("new_owner"), 531 _("name"), 532 _("argmode"), 533 _("argname"), 534 _("argtype"), 535 _("new_schema"), 536 _("name"), 537 _("argmode"), 538 _("argname"), 539 _("argtype"), 540 _("extension_name"), 541 _("where action is one of:"), 542 _("execution_cost"), 543 _("result_rows"), 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\n" 967 " [ NOT ] LEAKPROOF\n" 968 " [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n" 969 " PARALLEL { UNSAFE | RESTRICTED | SAFE }\n" 970 " COST %s\n" 971 " ROWS %s\n" 972 " SET %s { TO | = } { %s | DEFAULT }\n" 973 " SET %s FROM CURRENT\n" 974 " RESET %s\n" 975 " RESET ALL", 976 _("name"), 977 _("argmode"), 978 _("argname"), 979 _("argtype"), 980 _("action"), 981 _("name"), 982 _("argmode"), 983 _("argname"), 984 _("argtype"), 985 _("new_name"), 986 _("name"), 987 _("argmode"), 988 _("argname"), 989 _("argtype"), 990 _("new_owner"), 991 _("name"), 992 _("argmode"), 993 _("argname"), 994 _("argtype"), 995 _("new_schema"), 996 _("name"), 997 _("argmode"), 998 _("argname"), 999 _("argtype"), 1000 _("extension_name"), 1001 _("where action is one of:"), 1002 _("execution_cost"), 1003 _("result_rows"), 1004 _("configuration_parameter"), 1005 _("value"), 1006 _("configuration_parameter"), 1007 _("configuration_parameter")); 1008 } 1009 1010 static void 1011 sql_help_ALTER_RULE(PQExpBuffer buf) 1012 { 1013 appendPQExpBuffer(buf, 1014 "ALTER RULE %s ON %s RENAME TO %s", 1015 _("name"), 1016 _("table_name"), 1017 _("new_name")); 1018 } 1019 1020 static void 1021 sql_help_ALTER_SCHEMA(PQExpBuffer buf) 1022 { 1023 appendPQExpBuffer(buf, 1024 "ALTER SCHEMA %s RENAME TO %s\n" 1025 "ALTER SCHEMA %s OWNER TO { %s | CURRENT_USER | SESSION_USER }", 1026 _("name"), 1027 _("new_name"), 1028 _("name"), 1029 _("new_owner")); 1030 } 1031 1032 static void 1033 sql_help_ALTER_SEQUENCE(PQExpBuffer buf) 1034 { 1035 appendPQExpBuffer(buf, 1036 "ALTER SEQUENCE [ IF EXISTS ] %s\n" 1037 " [ AS %s ]\n" 1038 " [ INCREMENT [ BY ] %s ]\n" 1039 " [ MINVALUE %s | NO MINVALUE ] [ MAXVALUE %s | NO MAXVALUE ]\n" 1040 " [ START [ WITH ] %s ]\n" 1041 " [ RESTART [ [ WITH ] %s ] ]\n" 1042 " [ CACHE %s ] [ [ NO ] CYCLE ]\n" 1043 " [ OWNED BY { %s.%s | NONE } ]\n" 1044 "ALTER SEQUENCE [ IF EXISTS ] %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1045 "ALTER SEQUENCE [ IF EXISTS ] %s RENAME TO %s\n" 1046 "ALTER SEQUENCE [ IF EXISTS ] %s SET SCHEMA %s", 1047 _("name"), 1048 _("data_type"), 1049 _("increment"), 1050 _("minvalue"), 1051 _("maxvalue"), 1052 _("start"), 1053 _("restart"), 1054 _("cache"), 1055 _("table_name"), 1056 _("column_name"), 1057 _("name"), 1058 _("new_owner"), 1059 _("name"), 1060 _("new_name"), 1061 _("name"), 1062 _("new_schema")); 1063 } 1064 1065 static void 1066 sql_help_ALTER_SERVER(PQExpBuffer buf) 1067 { 1068 appendPQExpBuffer(buf, 1069 "ALTER SERVER %s [ VERSION '%s' ]\n" 1070 " [ OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ] ) ]\n" 1071 "ALTER SERVER %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1072 "ALTER SERVER %s RENAME TO %s", 1073 _("name"), 1074 _("new_version"), 1075 _("option"), 1076 _("value"), 1077 _("name"), 1078 _("new_owner"), 1079 _("name"), 1080 _("new_name")); 1081 } 1082 1083 static void 1084 sql_help_ALTER_STATISTICS(PQExpBuffer buf) 1085 { 1086 appendPQExpBuffer(buf, 1087 "ALTER STATISTICS %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1088 "ALTER STATISTICS %s RENAME TO %s\n" 1089 "ALTER STATISTICS %s SET SCHEMA %s", 1090 _("name"), 1091 _("new_owner"), 1092 _("name"), 1093 _("new_name"), 1094 _("name"), 1095 _("new_schema")); 1096 } 1097 1098 static void 1099 sql_help_ALTER_SUBSCRIPTION(PQExpBuffer buf) 1100 { 1101 appendPQExpBuffer(buf, 1102 "ALTER SUBSCRIPTION %s CONNECTION '%s'\n" 1103 "ALTER SUBSCRIPTION %s SET PUBLICATION %s [, ...] [ WITH ( %s [= %s] [, ... ] ) ]\n" 1104 "ALTER SUBSCRIPTION %s REFRESH PUBLICATION [ WITH ( %s [= %s] [, ... ] ) ]\n" 1105 "ALTER SUBSCRIPTION %s ENABLE\n" 1106 "ALTER SUBSCRIPTION %s DISABLE\n" 1107 "ALTER SUBSCRIPTION %s SET ( %s [= %s] [, ... ] )\n" 1108 "ALTER SUBSCRIPTION %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1109 "ALTER SUBSCRIPTION %s RENAME TO %s", 1110 _("name"), 1111 _("conninfo"), 1112 _("name"), 1113 _("publication_name"), 1114 _("set_publication_option"), 1115 _("value"), 1116 _("name"), 1117 _("refresh_option"), 1118 _("value"), 1119 _("name"), 1120 _("name"), 1121 _("name"), 1122 _("subscription_parameter"), 1123 _("value"), 1124 _("name"), 1125 _("new_owner"), 1126 _("name"), 1127 _("new_name")); 1128 } 1129 1130 static void 1131 sql_help_ALTER_SYSTEM(PQExpBuffer buf) 1132 { 1133 appendPQExpBuffer(buf, 1134 "ALTER SYSTEM SET %s { TO | = } { %s | '%s' | DEFAULT }\n" 1135 "\n" 1136 "ALTER SYSTEM RESET %s\n" 1137 "ALTER SYSTEM RESET ALL", 1138 _("configuration_parameter"), 1139 _("value"), 1140 _("value"), 1141 _("configuration_parameter")); 1142 } 1143 1144 static void 1145 sql_help_ALTER_TABLE(PQExpBuffer buf) 1146 { 1147 appendPQExpBuffer(buf, 1148 "ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ]\n" 1149 " %s [, ... ]\n" 1150 "ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ]\n" 1151 " RENAME [ COLUMN ] %s TO %s\n" 1152 "ALTER TABLE [ IF EXISTS ] [ ONLY ] %s [ * ]\n" 1153 " RENAME CONSTRAINT %s TO %s\n" 1154 "ALTER TABLE [ IF EXISTS ] %s\n" 1155 " RENAME TO %s\n" 1156 "ALTER TABLE [ IF EXISTS ] %s\n" 1157 " SET SCHEMA %s\n" 1158 "ALTER TABLE ALL IN TABLESPACE %s [ OWNED BY %s [, ... ] ]\n" 1159 " SET TABLESPACE %s [ NOWAIT ]\n" 1160 "ALTER TABLE [ IF EXISTS ] %s\n" 1161 " ATTACH PARTITION %s { FOR VALUES %s | DEFAULT }\n" 1162 "ALTER TABLE [ IF EXISTS ] %s\n" 1163 " DETACH PARTITION %s\n" 1164 "\n" 1165 "%s\n" 1166 "\n" 1167 " ADD [ COLUMN ] [ IF NOT EXISTS ] %s %s [ COLLATE %s ] [ %s [ ... ] ]\n" 1168 " DROP [ COLUMN ] [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n" 1169 " ALTER [ COLUMN ] %s [ SET DATA ] TYPE %s [ COLLATE %s ] [ USING %s ]\n" 1170 " ALTER [ COLUMN ] %s SET DEFAULT %s\n" 1171 " ALTER [ COLUMN ] %s DROP DEFAULT\n" 1172 " ALTER [ COLUMN ] %s { SET | DROP } NOT NULL\n" 1173 " ALTER [ COLUMN ] %s ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( %s ) ]\n" 1174 " ALTER [ COLUMN ] %s { SET GENERATED { ALWAYS | BY DEFAULT } | SET %s | RESTART [ [ WITH ] %s ] } [...]\n" 1175 " ALTER [ COLUMN ] %s DROP IDENTITY [ IF EXISTS ]\n" 1176 " ALTER [ COLUMN ] %s SET STATISTICS %s\n" 1177 " ALTER [ COLUMN ] %s SET ( %s = %s [, ... ] )\n" 1178 " ALTER [ COLUMN ] %s RESET ( %s [, ... ] )\n" 1179 " ALTER [ COLUMN ] %s SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }\n" 1180 " ADD %s [ NOT VALID ]\n" 1181 " ADD %s\n" 1182 " ALTER CONSTRAINT %s [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n" 1183 " VALIDATE CONSTRAINT %s\n" 1184 " DROP CONSTRAINT [ IF EXISTS ] %s [ RESTRICT | CASCADE ]\n" 1185 " DISABLE TRIGGER [ %s | ALL | USER ]\n" 1186 " ENABLE TRIGGER [ %s | ALL | USER ]\n" 1187 " ENABLE REPLICA TRIGGER %s\n" 1188 " ENABLE ALWAYS TRIGGER %s\n" 1189 " DISABLE RULE %s\n" 1190 " ENABLE RULE %s\n" 1191 " ENABLE REPLICA RULE %s\n" 1192 " ENABLE ALWAYS RULE %s\n" 1193 " DISABLE ROW LEVEL SECURITY\n" 1194 " ENABLE ROW LEVEL SECURITY\n" 1195 " FORCE ROW LEVEL SECURITY\n" 1196 " NO FORCE ROW LEVEL SECURITY\n" 1197 " CLUSTER ON %s\n" 1198 " SET WITHOUT CLUSTER\n" 1199 " SET WITH OIDS\n" 1200 " SET WITHOUT OIDS\n" 1201 " SET TABLESPACE %s\n" 1202 " SET { LOGGED | UNLOGGED }\n" 1203 " SET ( %s [= %s] [, ... ] )\n" 1204 " RESET ( %s [, ... ] )\n" 1205 " INHERIT %s\n" 1206 " NO INHERIT %s\n" 1207 " OF %s\n" 1208 " NOT OF\n" 1209 " OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1210 " REPLICA IDENTITY { DEFAULT | USING INDEX %s | FULL | NOTHING }\n" 1211 "\n" 1212 "%s\n" 1213 "\n" 1214 "IN ( { %s | %s | TRUE | FALSE | NULL } [, ...] ) |\n" 1215 "FROM ( { %s | %s | TRUE | FALSE | MINVALUE | MAXVALUE } [, ...] )\n" 1216 " TO ( { %s | %s | TRUE | FALSE | MINVALUE | MAXVALUE } [, ...] ) |\n" 1217 "WITH ( MODULUS %s, REMAINDER %s )\n" 1218 "\n" 1219 "%s\n" 1220 "\n" 1221 "[ CONSTRAINT %s ]\n" 1222 "{ NOT NULL |\n" 1223 " NULL |\n" 1224 " CHECK ( %s ) [ NO INHERIT ] |\n" 1225 " DEFAULT %s |\n" 1226 " GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( %s ) ] |\n" 1227 " UNIQUE %s |\n" 1228 " PRIMARY KEY %s |\n" 1229 " REFERENCES %s [ ( %s ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]\n" 1230 " [ ON DELETE %s ] [ ON UPDATE %s ] }\n" 1231 "[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n" 1232 "\n" 1233 "%s\n" 1234 "\n" 1235 "[ CONSTRAINT %s ]\n" 1236 "{ CHECK ( %s ) [ NO INHERIT ] |\n" 1237 " UNIQUE ( %s [, ... ] ) %s |\n" 1238 " PRIMARY KEY ( %s [, ... ] ) %s |\n" 1239 " EXCLUDE [ USING %s ] ( %s WITH %s [, ... ] ) %s [ WHERE ( %s ) ] |\n" 1240 " FOREIGN KEY ( %s [, ... ] ) REFERENCES %s [ ( %s [, ... ] ) ]\n" 1241 " [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE %s ] [ ON UPDATE %s ] }\n" 1242 "[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n" 1243 "\n" 1244 "%s\n" 1245 "\n" 1246 " [ CONSTRAINT %s ]\n" 1247 " { UNIQUE | PRIMARY KEY } USING INDEX %s\n" 1248 " [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n" 1249 "\n" 1250 "%s\n" 1251 "\n" 1252 "[ INCLUDE ( %s [, ... ] ) ]\n" 1253 "[ WITH ( %s [= %s] [, ... ] ) ]\n" 1254 "[ USING INDEX TABLESPACE %s ]\n" 1255 "\n" 1256 "%s\n" 1257 "\n" 1258 "{ %s | ( %s ) } [ %s ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]", 1259 _("name"), 1260 _("action"), 1261 _("name"), 1262 _("column_name"), 1263 _("new_column_name"), 1264 _("name"), 1265 _("constraint_name"), 1266 _("new_constraint_name"), 1267 _("name"), 1268 _("new_name"), 1269 _("name"), 1270 _("new_schema"), 1271 _("name"), 1272 _("role_name"), 1273 _("new_tablespace"), 1274 _("name"), 1275 _("partition_name"), 1276 _("partition_bound_spec"), 1277 _("name"), 1278 _("partition_name"), 1279 _("where action is one of:"), 1280 _("column_name"), 1281 _("data_type"), 1282 _("collation"), 1283 _("column_constraint"), 1284 _("column_name"), 1285 _("column_name"), 1286 _("data_type"), 1287 _("collation"), 1288 _("expression"), 1289 _("column_name"), 1290 _("expression"), 1291 _("column_name"), 1292 _("column_name"), 1293 _("column_name"), 1294 _("sequence_options"), 1295 _("column_name"), 1296 _("sequence_option"), 1297 _("restart"), 1298 _("column_name"), 1299 _("column_name"), 1300 _("integer"), 1301 _("column_name"), 1302 _("attribute_option"), 1303 _("value"), 1304 _("column_name"), 1305 _("attribute_option"), 1306 _("column_name"), 1307 _("table_constraint"), 1308 _("table_constraint_using_index"), 1309 _("constraint_name"), 1310 _("constraint_name"), 1311 _("constraint_name"), 1312 _("trigger_name"), 1313 _("trigger_name"), 1314 _("trigger_name"), 1315 _("trigger_name"), 1316 _("rewrite_rule_name"), 1317 _("rewrite_rule_name"), 1318 _("rewrite_rule_name"), 1319 _("rewrite_rule_name"), 1320 _("index_name"), 1321 _("new_tablespace"), 1322 _("storage_parameter"), 1323 _("value"), 1324 _("storage_parameter"), 1325 _("parent_table"), 1326 _("parent_table"), 1327 _("type_name"), 1328 _("new_owner"), 1329 _("index_name"), 1330 _("and partition_bound_spec is:"), 1331 _("numeric_literal"), 1332 _("string_literal"), 1333 _("numeric_literal"), 1334 _("string_literal"), 1335 _("numeric_literal"), 1336 _("string_literal"), 1337 _("numeric_literal"), 1338 _("numeric_literal"), 1339 _("and column_constraint is:"), 1340 _("constraint_name"), 1341 _("expression"), 1342 _("default_expr"), 1343 _("sequence_options"), 1344 _("index_parameters"), 1345 _("index_parameters"), 1346 _("reftable"), 1347 _("refcolumn"), 1348 _("action"), 1349 _("action"), 1350 _("and table_constraint is:"), 1351 _("constraint_name"), 1352 _("expression"), 1353 _("column_name"), 1354 _("index_parameters"), 1355 _("column_name"), 1356 _("index_parameters"), 1357 _("index_method"), 1358 _("exclude_element"), 1359 _("operator"), 1360 _("index_parameters"), 1361 _("predicate"), 1362 _("column_name"), 1363 _("reftable"), 1364 _("refcolumn"), 1365 _("action"), 1366 _("action"), 1367 _("and table_constraint_using_index is:"), 1368 _("constraint_name"), 1369 _("index_name"), 1370 _("index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:"), 1371 _("column_name"), 1372 _("storage_parameter"), 1373 _("value"), 1374 _("tablespace_name"), 1375 _("exclude_element in an EXCLUDE constraint is:"), 1376 _("column_name"), 1377 _("expression"), 1378 _("opclass")); 1379 } 1380 1381 static void 1382 sql_help_ALTER_TABLESPACE(PQExpBuffer buf) 1383 { 1384 appendPQExpBuffer(buf, 1385 "ALTER TABLESPACE %s RENAME TO %s\n" 1386 "ALTER TABLESPACE %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1387 "ALTER TABLESPACE %s SET ( %s = %s [, ... ] )\n" 1388 "ALTER TABLESPACE %s RESET ( %s [, ... ] )", 1389 _("name"), 1390 _("new_name"), 1391 _("name"), 1392 _("new_owner"), 1393 _("name"), 1394 _("tablespace_option"), 1395 _("value"), 1396 _("name"), 1397 _("tablespace_option")); 1398 } 1399 1400 static void 1401 sql_help_ALTER_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf) 1402 { 1403 appendPQExpBuffer(buf, 1404 "ALTER TEXT SEARCH CONFIGURATION %s\n" 1405 " ADD MAPPING FOR %s [, ... ] WITH %s [, ... ]\n" 1406 "ALTER TEXT SEARCH CONFIGURATION %s\n" 1407 " ALTER MAPPING FOR %s [, ... ] WITH %s [, ... ]\n" 1408 "ALTER TEXT SEARCH CONFIGURATION %s\n" 1409 " ALTER MAPPING REPLACE %s WITH %s\n" 1410 "ALTER TEXT SEARCH CONFIGURATION %s\n" 1411 " ALTER MAPPING FOR %s [, ... ] REPLACE %s WITH %s\n" 1412 "ALTER TEXT SEARCH CONFIGURATION %s\n" 1413 " DROP MAPPING [ IF EXISTS ] FOR %s [, ... ]\n" 1414 "ALTER TEXT SEARCH CONFIGURATION %s RENAME TO %s\n" 1415 "ALTER TEXT SEARCH CONFIGURATION %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1416 "ALTER TEXT SEARCH CONFIGURATION %s SET SCHEMA %s", 1417 _("name"), 1418 _("token_type"), 1419 _("dictionary_name"), 1420 _("name"), 1421 _("token_type"), 1422 _("dictionary_name"), 1423 _("name"), 1424 _("old_dictionary"), 1425 _("new_dictionary"), 1426 _("name"), 1427 _("token_type"), 1428 _("old_dictionary"), 1429 _("new_dictionary"), 1430 _("name"), 1431 _("token_type"), 1432 _("name"), 1433 _("new_name"), 1434 _("name"), 1435 _("new_owner"), 1436 _("name"), 1437 _("new_schema")); 1438 } 1439 1440 static void 1441 sql_help_ALTER_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf) 1442 { 1443 appendPQExpBuffer(buf, 1444 "ALTER TEXT SEARCH DICTIONARY %s (\n" 1445 " %s [ = %s ] [, ... ]\n" 1446 ")\n" 1447 "ALTER TEXT SEARCH DICTIONARY %s RENAME TO %s\n" 1448 "ALTER TEXT SEARCH DICTIONARY %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1449 "ALTER TEXT SEARCH DICTIONARY %s SET SCHEMA %s", 1450 _("name"), 1451 _("option"), 1452 _("value"), 1453 _("name"), 1454 _("new_name"), 1455 _("name"), 1456 _("new_owner"), 1457 _("name"), 1458 _("new_schema")); 1459 } 1460 1461 static void 1462 sql_help_ALTER_TEXT_SEARCH_PARSER(PQExpBuffer buf) 1463 { 1464 appendPQExpBuffer(buf, 1465 "ALTER TEXT SEARCH PARSER %s RENAME TO %s\n" 1466 "ALTER TEXT SEARCH PARSER %s SET SCHEMA %s", 1467 _("name"), 1468 _("new_name"), 1469 _("name"), 1470 _("new_schema")); 1471 } 1472 1473 static void 1474 sql_help_ALTER_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf) 1475 { 1476 appendPQExpBuffer(buf, 1477 "ALTER TEXT SEARCH TEMPLATE %s RENAME TO %s\n" 1478 "ALTER TEXT SEARCH TEMPLATE %s SET SCHEMA %s", 1479 _("name"), 1480 _("new_name"), 1481 _("name"), 1482 _("new_schema")); 1483 } 1484 1485 static void 1486 sql_help_ALTER_TRIGGER(PQExpBuffer buf) 1487 { 1488 appendPQExpBuffer(buf, 1489 "ALTER TRIGGER %s ON %s RENAME TO %s\n" 1490 "ALTER TRIGGER %s ON %s DEPENDS ON EXTENSION %s", 1491 _("name"), 1492 _("table_name"), 1493 _("new_name"), 1494 _("name"), 1495 _("table_name"), 1496 _("extension_name")); 1497 } 1498 1499 static void 1500 sql_help_ALTER_TYPE(PQExpBuffer buf) 1501 { 1502 appendPQExpBuffer(buf, 1503 "ALTER TYPE %s %s [, ... ]\n" 1504 "ALTER TYPE %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1505 "ALTER TYPE %s RENAME ATTRIBUTE %s TO %s [ CASCADE | RESTRICT ]\n" 1506 "ALTER TYPE %s RENAME TO %s\n" 1507 "ALTER TYPE %s SET SCHEMA %s\n" 1508 "ALTER TYPE %s ADD VALUE [ IF NOT EXISTS ] %s [ { BEFORE | AFTER } %s ]\n" 1509 "ALTER TYPE %s RENAME VALUE %s TO %s\n" 1510 "\n" 1511 "%s\n" 1512 "\n" 1513 " ADD ATTRIBUTE %s %s [ COLLATE %s ] [ CASCADE | RESTRICT ]\n" 1514 " DROP ATTRIBUTE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]\n" 1515 " ALTER ATTRIBUTE %s [ SET DATA ] TYPE %s [ COLLATE %s ] [ CASCADE | RESTRICT ]", 1516 _("name"), 1517 _("action"), 1518 _("name"), 1519 _("new_owner"), 1520 _("name"), 1521 _("attribute_name"), 1522 _("new_attribute_name"), 1523 _("name"), 1524 _("new_name"), 1525 _("name"), 1526 _("new_schema"), 1527 _("name"), 1528 _("new_enum_value"), 1529 _("neighbor_enum_value"), 1530 _("name"), 1531 _("existing_enum_value"), 1532 _("new_enum_value"), 1533 _("where action is one of:"), 1534 _("attribute_name"), 1535 _("data_type"), 1536 _("collation"), 1537 _("attribute_name"), 1538 _("attribute_name"), 1539 _("data_type"), 1540 _("collation")); 1541 } 1542 1543 static void 1544 sql_help_ALTER_USER(PQExpBuffer buf) 1545 { 1546 appendPQExpBuffer(buf, 1547 "ALTER USER %s [ WITH ] %s [ ... ]\n" 1548 "\n" 1549 "%s\n" 1550 "\n" 1551 " SUPERUSER | NOSUPERUSER\n" 1552 " | CREATEDB | NOCREATEDB\n" 1553 " | CREATEROLE | NOCREATEROLE\n" 1554 " | INHERIT | NOINHERIT\n" 1555 " | LOGIN | NOLOGIN\n" 1556 " | REPLICATION | NOREPLICATION\n" 1557 " | BYPASSRLS | NOBYPASSRLS\n" 1558 " | CONNECTION LIMIT %s\n" 1559 " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n" 1560 " | VALID UNTIL '%s'\n" 1561 "\n" 1562 "ALTER USER %s RENAME TO %s\n" 1563 "\n" 1564 "ALTER USER { %s | ALL } [ IN DATABASE %s ] SET %s { TO | = } { %s | DEFAULT }\n" 1565 "ALTER USER { %s | ALL } [ IN DATABASE %s ] SET %s FROM CURRENT\n" 1566 "ALTER USER { %s | ALL } [ IN DATABASE %s ] RESET %s\n" 1567 "ALTER USER { %s | ALL } [ IN DATABASE %s ] RESET ALL\n" 1568 "\n" 1569 "%s\n" 1570 "\n" 1571 " %s\n" 1572 " | CURRENT_USER\n" 1573 " | SESSION_USER", 1574 _("role_specification"), 1575 _("option"), 1576 _("where option can be:"), 1577 _("connlimit"), 1578 _("password"), 1579 _("timestamp"), 1580 _("name"), 1581 _("new_name"), 1582 _("role_specification"), 1583 _("database_name"), 1584 _("configuration_parameter"), 1585 _("value"), 1586 _("role_specification"), 1587 _("database_name"), 1588 _("configuration_parameter"), 1589 _("role_specification"), 1590 _("database_name"), 1591 _("configuration_parameter"), 1592 _("role_specification"), 1593 _("database_name"), 1594 _("where role_specification can be:"), 1595 _("role_name")); 1596 } 1597 1598 static void 1599 sql_help_ALTER_USER_MAPPING(PQExpBuffer buf) 1600 { 1601 appendPQExpBuffer(buf, 1602 "ALTER USER MAPPING FOR { %s | USER | CURRENT_USER | SESSION_USER | PUBLIC }\n" 1603 " SERVER %s\n" 1604 " OPTIONS ( [ ADD | SET | DROP ] %s ['%s'] [, ... ] )", 1605 _("user_name"), 1606 _("server_name"), 1607 _("option"), 1608 _("value")); 1609 } 1610 1611 static void 1612 sql_help_ALTER_VIEW(PQExpBuffer buf) 1613 { 1614 appendPQExpBuffer(buf, 1615 "ALTER VIEW [ IF EXISTS ] %s ALTER [ COLUMN ] %s SET DEFAULT %s\n" 1616 "ALTER VIEW [ IF EXISTS ] %s ALTER [ COLUMN ] %s DROP DEFAULT\n" 1617 "ALTER VIEW [ IF EXISTS ] %s OWNER TO { %s | CURRENT_USER | SESSION_USER }\n" 1618 "ALTER VIEW [ IF EXISTS ] %s RENAME TO %s\n" 1619 "ALTER VIEW [ IF EXISTS ] %s SET SCHEMA %s\n" 1620 "ALTER VIEW [ IF EXISTS ] %s SET ( %s [= %s] [, ... ] )\n" 1621 "ALTER VIEW [ IF EXISTS ] %s RESET ( %s [, ... ] )", 1622 _("name"), 1623 _("column_name"), 1624 _("expression"), 1625 _("name"), 1626 _("column_name"), 1627 _("name"), 1628 _("new_owner"), 1629 _("name"), 1630 _("new_name"), 1631 _("name"), 1632 _("new_schema"), 1633 _("name"), 1634 _("view_option_name"), 1635 _("view_option_value"), 1636 _("name"), 1637 _("view_option_name")); 1638 } 1639 1640 static void 1641 sql_help_ANALYZE(PQExpBuffer buf) 1642 { 1643 appendPQExpBuffer(buf, 1644 "ANALYZE [ ( %s [, ...] ) ] [ %s [, ...] ]\n" 1645 "ANALYZE [ VERBOSE ] [ %s [, ...] ]\n" 1646 "\n" 1647 "%s\n" 1648 "\n" 1649 " VERBOSE\n" 1650 "\n" 1651 "%s\n" 1652 "\n" 1653 " %s [ ( %s [, ...] ) ]", 1654 _("option"), 1655 _("table_and_columns"), 1656 _("table_and_columns"), 1657 _("where option can be one of:"), 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 ]"); 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 "\n" 1869 "COPY { %s [ ( %s [, ...] ) ] | ( %s ) }\n" 1870 " TO { '%s' | PROGRAM '%s' | STDOUT }\n" 1871 " [ [ WITH ] ( %s [, ...] ) ]\n" 1872 "\n" 1873 "%s\n" 1874 "\n" 1875 " FORMAT %s\n" 1876 " OIDS [ %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 _("table_name"), 1893 _("column_name"), 1894 _("query"), 1895 _("filename"), 1896 _("command"), 1897 _("option"), 1898 _("where option can be one of:"), 1899 _("format_name"), 1900 _("boolean"), 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 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 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 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 " [ VERSION = %s ]\n" 2075 ")\n" 2076 "CREATE COLLATION [ IF NOT EXISTS ] %s FROM %s", 2077 _("name"), 2078 _("locale"), 2079 _("lc_collate"), 2080 _("lc_ctype"), 2081 _("provider"), 2082 _("version"), 2083 _("name"), 2084 _("existing_collation")); 2085 } 2086 2087 static void 2088 sql_help_CREATE_CONVERSION(PQExpBuffer buf) 2089 { 2090 appendPQExpBuffer(buf, 2091 "CREATE [ DEFAULT ] CONVERSION %s\n" 2092 " FOR %s TO %s FROM %s", 2093 _("name"), 2094 _("source_encoding"), 2095 _("dest_encoding"), 2096 _("function_name")); 2097 } 2098 2099 static void 2100 sql_help_CREATE_DATABASE(PQExpBuffer buf) 2101 { 2102 appendPQExpBuffer(buf, 2103 "CREATE DATABASE %s\n" 2104 " [ [ WITH ] [ OWNER [=] %s ]\n" 2105 " [ TEMPLATE [=] %s ]\n" 2106 " [ ENCODING [=] %s ]\n" 2107 " [ LC_COLLATE [=] %s ]\n" 2108 " [ LC_CTYPE [=] %s ]\n" 2109 " [ TABLESPACE [=] %s ]\n" 2110 " [ ALLOW_CONNECTIONS [=] %s ]\n" 2111 " [ CONNECTION LIMIT [=] %s ]\n" 2112 " [ IS_TEMPLATE [=] %s ] ]", 2113 _("name"), 2114 _("user_name"), 2115 _("template"), 2116 _("encoding"), 2117 _("lc_collate"), 2118 _("lc_ctype"), 2119 _("tablespace_name"), 2120 _("allowconn"), 2121 _("connlimit"), 2122 _("istemplate")); 2123 } 2124 2125 static void 2126 sql_help_CREATE_DOMAIN(PQExpBuffer buf) 2127 { 2128 appendPQExpBuffer(buf, 2129 "CREATE DOMAIN %s [ AS ] %s\n" 2130 " [ COLLATE %s ]\n" 2131 " [ DEFAULT %s ]\n" 2132 " [ %s [ ... ] ]\n" 2133 "\n" 2134 "%s\n" 2135 "\n" 2136 "[ CONSTRAINT %s ]\n" 2137 "{ NOT NULL | NULL | CHECK (%s) }", 2138 _("name"), 2139 _("data_type"), 2140 _("collation"), 2141 _("expression"), 2142 _("constraint"), 2143 _("where constraint is:"), 2144 _("constraint_name"), 2145 _("expression")); 2146 } 2147 2148 static void 2149 sql_help_CREATE_EVENT_TRIGGER(PQExpBuffer buf) 2150 { 2151 appendPQExpBuffer(buf, 2152 "CREATE EVENT TRIGGER %s\n" 2153 " ON %s\n" 2154 " [ WHEN %s IN (%s [, ... ]) [ AND ... ] ]\n" 2155 " EXECUTE { FUNCTION | PROCEDURE } %s()", 2156 _("name"), 2157 _("event"), 2158 _("filter_variable"), 2159 _("filter_value"), 2160 _("function_name")); 2161 } 2162 2163 static void 2164 sql_help_CREATE_EXTENSION(PQExpBuffer buf) 2165 { 2166 appendPQExpBuffer(buf, 2167 "CREATE EXTENSION [ IF NOT EXISTS ] %s\n" 2168 " [ WITH ] [ SCHEMA %s ]\n" 2169 " [ VERSION %s ]\n" 2170 " [ FROM %s ]\n" 2171 " [ CASCADE ]", 2172 _("extension_name"), 2173 _("schema_name"), 2174 _("version"), 2175 _("old_version")); 2176 } 2177 2178 static void 2179 sql_help_CREATE_FOREIGN_DATA_WRAPPER(PQExpBuffer buf) 2180 { 2181 appendPQExpBuffer(buf, 2182 "CREATE FOREIGN DATA WRAPPER %s\n" 2183 " [ HANDLER %s | NO HANDLER ]\n" 2184 " [ VALIDATOR %s | NO VALIDATOR ]\n" 2185 " [ OPTIONS ( %s '%s' [, ... ] ) ]", 2186 _("name"), 2187 _("handler_function"), 2188 _("validator_function"), 2189 _("option"), 2190 _("value")); 2191 } 2192 2193 static void 2194 sql_help_CREATE_FOREIGN_TABLE(PQExpBuffer buf) 2195 { 2196 appendPQExpBuffer(buf, 2197 "CREATE FOREIGN TABLE [ IF NOT EXISTS ] %s ( [\n" 2198 " { %s %s [ OPTIONS ( %s '%s' [, ... ] ) ] [ COLLATE %s ] [ %s [ ... ] ]\n" 2199 " | %s }\n" 2200 " [, ... ]\n" 2201 "] )\n" 2202 "[ INHERITS ( %s [, ... ] ) ]\n" 2203 " SERVER %s\n" 2204 "[ OPTIONS ( %s '%s' [, ... ] ) ]\n" 2205 "\n" 2206 "CREATE FOREIGN TABLE [ IF NOT EXISTS ] %s\n" 2207 " PARTITION OF %s [ (\n" 2208 " { %s [ WITH OPTIONS ] [ %s [ ... ] ]\n" 2209 " | %s }\n" 2210 " [, ... ]\n" 2211 ") ] %s\n" 2212 " SERVER %s\n" 2213 "[ OPTIONS ( %s '%s' [, ... ] ) ]\n" 2214 "\n" 2215 "%s\n" 2216 "\n" 2217 "[ CONSTRAINT %s ]\n" 2218 "{ NOT NULL |\n" 2219 " NULL |\n" 2220 " CHECK ( %s ) [ NO INHERIT ] |\n" 2221 " DEFAULT %s }\n" 2222 "\n" 2223 "%s\n" 2224 "\n" 2225 "[ CONSTRAINT %s ]\n" 2226 "CHECK ( %s ) [ NO INHERIT ]", 2227 _("table_name"), 2228 _("column_name"), 2229 _("data_type"), 2230 _("option"), 2231 _("value"), 2232 _("collation"), 2233 _("column_constraint"), 2234 _("table_constraint"), 2235 _("parent_table"), 2236 _("server_name"), 2237 _("option"), 2238 _("value"), 2239 _("table_name"), 2240 _("parent_table"), 2241 _("column_name"), 2242 _("column_constraint"), 2243 _("table_constraint"), 2244 _("partition_bound_spec"), 2245 _("server_name"), 2246 _("option"), 2247 _("value"), 2248 _("where column_constraint is:"), 2249 _("constraint_name"), 2250 _("expression"), 2251 _("default_expr"), 2252 _("and table_constraint is:"), 2253 _("constraint_name"), 2254 _("expression")); 2255 } 2256 2257 static void 2258 sql_help_CREATE_FUNCTION(PQExpBuffer buf) 2259 { 2260 appendPQExpBuffer(buf, 2261 "CREATE [ OR REPLACE ] FUNCTION\n" 2262 " %s ( [ [ %s ] [ %s ] %s [ { DEFAULT | = } %s ] [, ...] ] )\n" 2263 " [ RETURNS %s\n" 2264 " | RETURNS TABLE ( %s %s [, ...] ) ]\n" 2265 " { LANGUAGE %s\n" 2266 " | TRANSFORM { FOR TYPE %s } [, ... ]\n" 2267 " | WINDOW\n" 2268 " | { IMMUTABLE | STABLE | VOLATILE }\n" 2269 " | [ NOT ] LEAKPROOF\n" 2270 " | { CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT }\n" 2271 " | { [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER }\n" 2272 " | PARALLEL { UNSAFE | RESTRICTED | SAFE }\n" 2273 " | COST %s\n" 2274 " | ROWS %s\n" 2275 " | SET %s { TO %s | = %s | FROM CURRENT }\n" 2276 " | AS '%s'\n" 2277 " | AS '%s', '%s'\n" 2278 " } ...", 2279 _("name"), 2280 _("argmode"), 2281 _("argname"), 2282 _("argtype"), 2283 _("default_expr"), 2284 _("rettype"), 2285 _("column_name"), 2286 _("column_type"), 2287 _("lang_name"), 2288 _("type_name"), 2289 _("execution_cost"), 2290 _("result_rows"), 2291 _("configuration_parameter"), 2292 _("value"), 2293 _("value"), 2294 _("definition"), 2295 _("obj_file"), 2296 _("link_symbol")); 2297 } 2298 2299 static void 2300 sql_help_CREATE_GROUP(PQExpBuffer buf) 2301 { 2302 appendPQExpBuffer(buf, 2303 "CREATE GROUP %s [ [ WITH ] %s [ ... ] ]\n" 2304 "\n" 2305 "%s\n" 2306 "\n" 2307 " SUPERUSER | NOSUPERUSER\n" 2308 " | CREATEDB | NOCREATEDB\n" 2309 " | CREATEROLE | NOCREATEROLE\n" 2310 " | INHERIT | NOINHERIT\n" 2311 " | LOGIN | NOLOGIN\n" 2312 " | REPLICATION | NOREPLICATION\n" 2313 " | BYPASSRLS | NOBYPASSRLS\n" 2314 " | CONNECTION LIMIT %s\n" 2315 " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n" 2316 " | VALID UNTIL '%s'\n" 2317 " | IN ROLE %s [, ...]\n" 2318 " | IN GROUP %s [, ...]\n" 2319 " | ROLE %s [, ...]\n" 2320 " | ADMIN %s [, ...]\n" 2321 " | USER %s [, ...]\n" 2322 " | SYSID %s", 2323 _("name"), 2324 _("option"), 2325 _("where option can be:"), 2326 _("connlimit"), 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 " [ WITH ( %s [= %s] [, ... ] ) ]\n" 2382 " [ TABLESPACE %s ]\n" 2383 " AS %s\n" 2384 " [ WITH [ NO ] DATA ]", 2385 _("table_name"), 2386 _("column_name"), 2387 _("storage_parameter"), 2388 _("value"), 2389 _("tablespace_name"), 2390 _("query")); 2391 } 2392 2393 static void 2394 sql_help_CREATE_OPERATOR(PQExpBuffer buf) 2395 { 2396 appendPQExpBuffer(buf, 2397 "CREATE OPERATOR %s (\n" 2398 " {FUNCTION|PROCEDURE} = %s\n" 2399 " [, LEFTARG = %s ] [, RIGHTARG = %s ]\n" 2400 " [, COMMUTATOR = %s ] [, NEGATOR = %s ]\n" 2401 " [, RESTRICT = %s ] [, JOIN = %s ]\n" 2402 " [, HASHES ] [, MERGES ]\n" 2403 ")", 2404 _("name"), 2405 _("function_name"), 2406 _("left_type"), 2407 _("right_type"), 2408 _("com_op"), 2409 _("neg_op"), 2410 _("res_proc"), 2411 _("join_proc")); 2412 } 2413 2414 static void 2415 sql_help_CREATE_OPERATOR_CLASS(PQExpBuffer buf) 2416 { 2417 appendPQExpBuffer(buf, 2418 "CREATE OPERATOR CLASS %s [ DEFAULT ] FOR TYPE %s\n" 2419 " USING %s [ FAMILY %s ] AS\n" 2420 " { OPERATOR %s %s [ ( %s, %s ) ] [ FOR SEARCH | FOR ORDER BY %s ]\n" 2421 " | FUNCTION %s [ ( %s [ , %s ] ) ] %s ( %s [, ...] )\n" 2422 " | STORAGE %s\n" 2423 " } [, ... ]", 2424 _("name"), 2425 _("data_type"), 2426 _("index_method"), 2427 _("family_name"), 2428 _("strategy_number"), 2429 _("operator_name"), 2430 _("op_type"), 2431 _("op_type"), 2432 _("sort_family_name"), 2433 _("support_number"), 2434 _("op_type"), 2435 _("op_type"), 2436 _("function_name"), 2437 _("argument_type"), 2438 _("storage_type")); 2439 } 2440 2441 static void 2442 sql_help_CREATE_OPERATOR_FAMILY(PQExpBuffer buf) 2443 { 2444 appendPQExpBuffer(buf, 2445 "CREATE OPERATOR FAMILY %s USING %s", 2446 _("name"), 2447 _("index_method")); 2448 } 2449 2450 static void 2451 sql_help_CREATE_POLICY(PQExpBuffer buf) 2452 { 2453 appendPQExpBuffer(buf, 2454 "CREATE POLICY %s ON %s\n" 2455 " [ AS { PERMISSIVE | RESTRICTIVE } ]\n" 2456 " [ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ]\n" 2457 " [ TO { %s | PUBLIC | CURRENT_USER | SESSION_USER } [, ...] ]\n" 2458 " [ USING ( %s ) ]\n" 2459 " [ WITH CHECK ( %s ) ]", 2460 _("name"), 2461 _("table_name"), 2462 _("role_name"), 2463 _("using_expression"), 2464 _("check_expression")); 2465 } 2466 2467 static void 2468 sql_help_CREATE_PROCEDURE(PQExpBuffer buf) 2469 { 2470 appendPQExpBuffer(buf, 2471 "CREATE [ OR REPLACE ] PROCEDURE\n" 2472 " %s ( [ [ %s ] [ %s ] %s [ { DEFAULT | = } %s ] [, ...] ] )\n" 2473 " { LANGUAGE %s\n" 2474 " | TRANSFORM { FOR TYPE %s } [, ... ]\n" 2475 " | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER\n" 2476 " | SET %s { TO %s | = %s | FROM CURRENT }\n" 2477 " | AS '%s'\n" 2478 " | AS '%s', '%s'\n" 2479 " } ...", 2480 _("name"), 2481 _("argmode"), 2482 _("argname"), 2483 _("argtype"), 2484 _("default_expr"), 2485 _("lang_name"), 2486 _("type_name"), 2487 _("configuration_parameter"), 2488 _("value"), 2489 _("value"), 2490 _("definition"), 2491 _("obj_file"), 2492 _("link_symbol")); 2493 } 2494 2495 static void 2496 sql_help_CREATE_PUBLICATION(PQExpBuffer buf) 2497 { 2498 appendPQExpBuffer(buf, 2499 "CREATE PUBLICATION %s\n" 2500 " [ FOR TABLE [ ONLY ] %s [ * ] [, ...]\n" 2501 " | FOR ALL TABLES ]\n" 2502 " [ WITH ( %s [= %s] [, ... ] ) ]", 2503 _("name"), 2504 _("table_name"), 2505 _("publication_parameter"), 2506 _("value")); 2507 } 2508 2509 static void 2510 sql_help_CREATE_ROLE(PQExpBuffer buf) 2511 { 2512 appendPQExpBuffer(buf, 2513 "CREATE ROLE %s [ [ WITH ] %s [ ... ] ]\n" 2514 "\n" 2515 "%s\n" 2516 "\n" 2517 " SUPERUSER | NOSUPERUSER\n" 2518 " | CREATEDB | NOCREATEDB\n" 2519 " | CREATEROLE | NOCREATEROLE\n" 2520 " | INHERIT | NOINHERIT\n" 2521 " | LOGIN | NOLOGIN\n" 2522 " | REPLICATION | NOREPLICATION\n" 2523 " | BYPASSRLS | NOBYPASSRLS\n" 2524 " | CONNECTION LIMIT %s\n" 2525 " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n" 2526 " | VALID UNTIL '%s'\n" 2527 " | IN ROLE %s [, ...]\n" 2528 " | IN GROUP %s [, ...]\n" 2529 " | ROLE %s [, ...]\n" 2530 " | ADMIN %s [, ...]\n" 2531 " | USER %s [, ...]\n" 2532 " | SYSID %s", 2533 _("name"), 2534 _("option"), 2535 _("where option can be:"), 2536 _("connlimit"), 2537 _("password"), 2538 _("timestamp"), 2539 _("role_name"), 2540 _("role_name"), 2541 _("role_name"), 2542 _("role_name"), 2543 _("role_name"), 2544 _("uid")); 2545 } 2546 2547 static void 2548 sql_help_CREATE_RULE(PQExpBuffer buf) 2549 { 2550 appendPQExpBuffer(buf, 2551 "CREATE [ OR REPLACE ] RULE %s AS ON %s\n" 2552 " TO %s [ WHERE %s ]\n" 2553 " DO [ ALSO | INSTEAD ] { NOTHING | %s | ( %s ; %s ... ) }\n" 2554 "\n" 2555 "%s\n" 2556 "\n" 2557 " SELECT | INSERT | UPDATE | DELETE", 2558 _("name"), 2559 _("event"), 2560 _("table_name"), 2561 _("condition"), 2562 _("command"), 2563 _("command"), 2564 _("command"), 2565 _("where event can be one of:")); 2566 } 2567 2568 static void 2569 sql_help_CREATE_SCHEMA(PQExpBuffer buf) 2570 { 2571 appendPQExpBuffer(buf, 2572 "CREATE SCHEMA %s [ AUTHORIZATION %s ] [ %s [ ... ] ]\n" 2573 "CREATE SCHEMA AUTHORIZATION %s [ %s [ ... ] ]\n" 2574 "CREATE SCHEMA IF NOT EXISTS %s [ AUTHORIZATION %s ]\n" 2575 "CREATE SCHEMA IF NOT EXISTS AUTHORIZATION %s\n" 2576 "\n" 2577 "%s\n" 2578 "\n" 2579 " %s\n" 2580 " | CURRENT_USER\n" 2581 " | SESSION_USER", 2582 _("schema_name"), 2583 _("role_specification"), 2584 _("schema_element"), 2585 _("role_specification"), 2586 _("schema_element"), 2587 _("schema_name"), 2588 _("role_specification"), 2589 _("role_specification"), 2590 _("where role_specification can be:"), 2591 _("user_name")); 2592 } 2593 2594 static void 2595 sql_help_CREATE_SEQUENCE(PQExpBuffer buf) 2596 { 2597 appendPQExpBuffer(buf, 2598 "CREATE [ TEMPORARY | TEMP ] SEQUENCE [ IF NOT EXISTS ] %s\n" 2599 " [ AS %s ]\n" 2600 " [ INCREMENT [ BY ] %s ]\n" 2601 " [ MINVALUE %s | NO MINVALUE ] [ MAXVALUE %s | NO MAXVALUE ]\n" 2602 " [ START [ WITH ] %s ] [ CACHE %s ] [ [ NO ] CYCLE ]\n" 2603 " [ OWNED BY { %s.%s | NONE } ]", 2604 _("name"), 2605 _("data_type"), 2606 _("increment"), 2607 _("minvalue"), 2608 _("maxvalue"), 2609 _("start"), 2610 _("cache"), 2611 _("table_name"), 2612 _("column_name")); 2613 } 2614 2615 static void 2616 sql_help_CREATE_SERVER(PQExpBuffer buf) 2617 { 2618 appendPQExpBuffer(buf, 2619 "CREATE SERVER [ IF NOT EXISTS ] %s [ TYPE '%s' ] [ VERSION '%s' ]\n" 2620 " FOREIGN DATA WRAPPER %s\n" 2621 " [ OPTIONS ( %s '%s' [, ... ] ) ]", 2622 _("server_name"), 2623 _("server_type"), 2624 _("server_version"), 2625 _("fdw_name"), 2626 _("option"), 2627 _("value")); 2628 } 2629 2630 static void 2631 sql_help_CREATE_STATISTICS(PQExpBuffer buf) 2632 { 2633 appendPQExpBuffer(buf, 2634 "CREATE STATISTICS [ IF NOT EXISTS ] %s\n" 2635 " [ ( %s [, ... ] ) ]\n" 2636 " ON %s, %s [, ...]\n" 2637 " FROM %s", 2638 _("statistics_name"), 2639 _("statistics_kind"), 2640 _("column_name"), 2641 _("column_name"), 2642 _("table_name")); 2643 } 2644 2645 static void 2646 sql_help_CREATE_SUBSCRIPTION(PQExpBuffer buf) 2647 { 2648 appendPQExpBuffer(buf, 2649 "CREATE SUBSCRIPTION %s\n" 2650 " CONNECTION '%s'\n" 2651 " PUBLICATION %s [, ...]\n" 2652 " [ WITH ( %s [= %s] [, ... ] ) ]", 2653 _("subscription_name"), 2654 _("conninfo"), 2655 _("publication_name"), 2656 _("subscription_parameter"), 2657 _("value")); 2658 } 2659 2660 static void 2661 sql_help_CREATE_TABLE(PQExpBuffer buf) 2662 { 2663 appendPQExpBuffer(buf, 2664 "CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s ( [\n" 2665 " { %s %s [ COLLATE %s ] [ %s [ ... ] ]\n" 2666 " | %s\n" 2667 " | LIKE %s [ %s ... ] }\n" 2668 " [, ... ]\n" 2669 "] )\n" 2670 "[ INHERITS ( %s [, ... ] ) ]\n" 2671 "[ PARTITION BY { RANGE | LIST | HASH } ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [, ... ] ) ]\n" 2672 "[ WITH ( %s [= %s] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n" 2673 "[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n" 2674 "[ TABLESPACE %s ]\n" 2675 "\n" 2676 "CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s\n" 2677 " OF %s [ (\n" 2678 " { %s [ WITH OPTIONS ] [ %s [ ... ] ]\n" 2679 " | %s }\n" 2680 " [, ... ]\n" 2681 ") ]\n" 2682 "[ PARTITION BY { RANGE | LIST | HASH } ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [, ... ] ) ]\n" 2683 "[ WITH ( %s [= %s] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n" 2684 "[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n" 2685 "[ TABLESPACE %s ]\n" 2686 "\n" 2687 "CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s\n" 2688 " PARTITION OF %s [ (\n" 2689 " { %s [ WITH OPTIONS ] [ %s [ ... ] ]\n" 2690 " | %s }\n" 2691 " [, ... ]\n" 2692 ") ] { FOR VALUES %s | DEFAULT }\n" 2693 "[ PARTITION BY { RANGE | LIST | HASH } ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [, ... ] ) ]\n" 2694 "[ WITH ( %s [= %s] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n" 2695 "[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n" 2696 "[ TABLESPACE %s ]\n" 2697 "\n" 2698 "%s\n" 2699 "\n" 2700 "[ CONSTRAINT %s ]\n" 2701 "{ NOT NULL |\n" 2702 " NULL |\n" 2703 " CHECK ( %s ) [ NO INHERIT ] |\n" 2704 " DEFAULT %s |\n" 2705 " GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( %s ) ] |\n" 2706 " UNIQUE %s |\n" 2707 " PRIMARY KEY %s |\n" 2708 " REFERENCES %s [ ( %s ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]\n" 2709 " [ ON DELETE %s ] [ ON UPDATE %s ] }\n" 2710 "[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n" 2711 "\n" 2712 "%s\n" 2713 "\n" 2714 "[ CONSTRAINT %s ]\n" 2715 "{ CHECK ( %s ) [ NO INHERIT ] |\n" 2716 " UNIQUE ( %s [, ... ] ) %s |\n" 2717 " PRIMARY KEY ( %s [, ... ] ) %s |\n" 2718 " EXCLUDE [ USING %s ] ( %s WITH %s [, ... ] ) %s [ WHERE ( %s ) ] |\n" 2719 " FOREIGN KEY ( %s [, ... ] ) REFERENCES %s [ ( %s [, ... ] ) ]\n" 2720 " [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE %s ] [ ON UPDATE %s ] }\n" 2721 "[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]\n" 2722 "\n" 2723 "%s\n" 2724 "\n" 2725 "{ INCLUDING | EXCLUDING } { COMMENTS | CONSTRAINTS | DEFAULTS | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }\n" 2726 "\n" 2727 "%s\n" 2728 "\n" 2729 "IN ( { %s | %s | TRUE | FALSE | NULL } [, ...] ) |\n" 2730 "FROM ( { %s | %s | TRUE | FALSE | MINVALUE | MAXVALUE } [, ...] )\n" 2731 " TO ( { %s | %s | TRUE | FALSE | MINVALUE | MAXVALUE } [, ...] ) |\n" 2732 "WITH ( MODULUS %s, REMAINDER %s )\n" 2733 "\n" 2734 "%s\n" 2735 "\n" 2736 "[ INCLUDE ( %s [, ... ] ) ]\n" 2737 "[ WITH ( %s [= %s] [, ... ] ) ]\n" 2738 "[ USING INDEX TABLESPACE %s ]\n" 2739 "\n" 2740 "%s\n" 2741 "\n" 2742 "{ %s | ( %s ) } [ %s ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]", 2743 _("table_name"), 2744 _("column_name"), 2745 _("data_type"), 2746 _("collation"), 2747 _("column_constraint"), 2748 _("table_constraint"), 2749 _("source_table"), 2750 _("like_option"), 2751 _("parent_table"), 2752 _("column_name"), 2753 _("expression"), 2754 _("collation"), 2755 _("opclass"), 2756 _("storage_parameter"), 2757 _("value"), 2758 _("tablespace_name"), 2759 _("table_name"), 2760 _("type_name"), 2761 _("column_name"), 2762 _("column_constraint"), 2763 _("table_constraint"), 2764 _("column_name"), 2765 _("expression"), 2766 _("collation"), 2767 _("opclass"), 2768 _("storage_parameter"), 2769 _("value"), 2770 _("tablespace_name"), 2771 _("table_name"), 2772 _("parent_table"), 2773 _("column_name"), 2774 _("column_constraint"), 2775 _("table_constraint"), 2776 _("partition_bound_spec"), 2777 _("column_name"), 2778 _("expression"), 2779 _("collation"), 2780 _("opclass"), 2781 _("storage_parameter"), 2782 _("value"), 2783 _("tablespace_name"), 2784 _("where column_constraint is:"), 2785 _("constraint_name"), 2786 _("expression"), 2787 _("default_expr"), 2788 _("sequence_options"), 2789 _("index_parameters"), 2790 _("index_parameters"), 2791 _("reftable"), 2792 _("refcolumn"), 2793 _("action"), 2794 _("action"), 2795 _("and table_constraint is:"), 2796 _("constraint_name"), 2797 _("expression"), 2798 _("column_name"), 2799 _("index_parameters"), 2800 _("column_name"), 2801 _("index_parameters"), 2802 _("index_method"), 2803 _("exclude_element"), 2804 _("operator"), 2805 _("index_parameters"), 2806 _("predicate"), 2807 _("column_name"), 2808 _("reftable"), 2809 _("refcolumn"), 2810 _("action"), 2811 _("action"), 2812 _("and like_option is:"), 2813 _("and partition_bound_spec is:"), 2814 _("numeric_literal"), 2815 _("string_literal"), 2816 _("numeric_literal"), 2817 _("string_literal"), 2818 _("numeric_literal"), 2819 _("string_literal"), 2820 _("numeric_literal"), 2821 _("numeric_literal"), 2822 _("index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:"), 2823 _("column_name"), 2824 _("storage_parameter"), 2825 _("value"), 2826 _("tablespace_name"), 2827 _("exclude_element in an EXCLUDE constraint is:"), 2828 _("column_name"), 2829 _("expression"), 2830 _("opclass")); 2831 } 2832 2833 static void 2834 sql_help_CREATE_TABLE_AS(PQExpBuffer buf) 2835 { 2836 appendPQExpBuffer(buf, 2837 "CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] %s\n" 2838 " [ (%s [, ...] ) ]\n" 2839 " [ WITH ( %s [= %s] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]\n" 2840 " [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]\n" 2841 " [ TABLESPACE %s ]\n" 2842 " AS %s\n" 2843 " [ WITH [ NO ] DATA ]", 2844 _("table_name"), 2845 _("column_name"), 2846 _("storage_parameter"), 2847 _("value"), 2848 _("tablespace_name"), 2849 _("query")); 2850 } 2851 2852 static void 2853 sql_help_CREATE_TABLESPACE(PQExpBuffer buf) 2854 { 2855 appendPQExpBuffer(buf, 2856 "CREATE TABLESPACE %s\n" 2857 " [ OWNER { %s | CURRENT_USER | SESSION_USER } ]\n" 2858 " LOCATION '%s'\n" 2859 " [ WITH ( %s = %s [, ... ] ) ]", 2860 _("tablespace_name"), 2861 _("new_owner"), 2862 _("directory"), 2863 _("tablespace_option"), 2864 _("value")); 2865 } 2866 2867 static void 2868 sql_help_CREATE_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf) 2869 { 2870 appendPQExpBuffer(buf, 2871 "CREATE TEXT SEARCH CONFIGURATION %s (\n" 2872 " PARSER = %s |\n" 2873 " COPY = %s\n" 2874 ")", 2875 _("name"), 2876 _("parser_name"), 2877 _("source_config")); 2878 } 2879 2880 static void 2881 sql_help_CREATE_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf) 2882 { 2883 appendPQExpBuffer(buf, 2884 "CREATE TEXT SEARCH DICTIONARY %s (\n" 2885 " TEMPLATE = %s\n" 2886 " [, %s = %s [, ... ]]\n" 2887 ")", 2888 _("name"), 2889 _("template"), 2890 _("option"), 2891 _("value")); 2892 } 2893 2894 static void 2895 sql_help_CREATE_TEXT_SEARCH_PARSER(PQExpBuffer buf) 2896 { 2897 appendPQExpBuffer(buf, 2898 "CREATE TEXT SEARCH PARSER %s (\n" 2899 " START = %s ,\n" 2900 " GETTOKEN = %s ,\n" 2901 " END = %s ,\n" 2902 " LEXTYPES = %s\n" 2903 " [, HEADLINE = %s ]\n" 2904 ")", 2905 _("name"), 2906 _("start_function"), 2907 _("gettoken_function"), 2908 _("end_function"), 2909 _("lextypes_function"), 2910 _("headline_function")); 2911 } 2912 2913 static void 2914 sql_help_CREATE_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf) 2915 { 2916 appendPQExpBuffer(buf, 2917 "CREATE TEXT SEARCH TEMPLATE %s (\n" 2918 " [ INIT = %s , ]\n" 2919 " LEXIZE = %s\n" 2920 ")", 2921 _("name"), 2922 _("init_function"), 2923 _("lexize_function")); 2924 } 2925 2926 static void 2927 sql_help_CREATE_TRANSFORM(PQExpBuffer buf) 2928 { 2929 appendPQExpBuffer(buf, 2930 "CREATE [ OR REPLACE ] TRANSFORM FOR %s LANGUAGE %s (\n" 2931 " FROM SQL WITH FUNCTION %s [ (%s [, ...]) ],\n" 2932 " TO SQL WITH FUNCTION %s [ (%s [, ...]) ]\n" 2933 ");", 2934 _("type_name"), 2935 _("lang_name"), 2936 _("from_sql_function_name"), 2937 _("argument_type"), 2938 _("to_sql_function_name"), 2939 _("argument_type")); 2940 } 2941 2942 static void 2943 sql_help_CREATE_TRIGGER(PQExpBuffer buf) 2944 { 2945 appendPQExpBuffer(buf, 2946 "CREATE [ CONSTRAINT ] TRIGGER %s { BEFORE | AFTER | INSTEAD OF } { %s [ OR ... ] }\n" 2947 " ON %s\n" 2948 " [ FROM %s ]\n" 2949 " [ NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ] ]\n" 2950 " [ REFERENCING { { OLD | NEW } TABLE [ AS ] %s } [ ... ] ]\n" 2951 " [ FOR [ EACH ] { ROW | STATEMENT } ]\n" 2952 " [ WHEN ( %s ) ]\n" 2953 " EXECUTE { FUNCTION | PROCEDURE } %s ( %s )\n" 2954 "\n" 2955 "%s\n" 2956 "\n" 2957 " INSERT\n" 2958 " UPDATE [ OF %s [, ... ] ]\n" 2959 " DELETE\n" 2960 " TRUNCATE", 2961 _("name"), 2962 _("event"), 2963 _("table_name"), 2964 _("referenced_table_name"), 2965 _("transition_relation_name"), 2966 _("condition"), 2967 _("function_name"), 2968 _("arguments"), 2969 _("where event can be one of:"), 2970 _("column_name")); 2971 } 2972 2973 static void 2974 sql_help_CREATE_TYPE(PQExpBuffer buf) 2975 { 2976 appendPQExpBuffer(buf, 2977 "CREATE TYPE %s AS\n" 2978 " ( [ %s %s [ COLLATE %s ] [, ... ] ] )\n" 2979 "\n" 2980 "CREATE TYPE %s AS ENUM\n" 2981 " ( [ '%s' [, ... ] ] )\n" 2982 "\n" 2983 "CREATE TYPE %s AS RANGE (\n" 2984 " SUBTYPE = %s\n" 2985 " [ , SUBTYPE_OPCLASS = %s ]\n" 2986 " [ , COLLATION = %s ]\n" 2987 " [ , CANONICAL = %s ]\n" 2988 " [ , SUBTYPE_DIFF = %s ]\n" 2989 ")\n" 2990 "\n" 2991 "CREATE TYPE %s (\n" 2992 " INPUT = %s,\n" 2993 " OUTPUT = %s\n" 2994 " [ , RECEIVE = %s ]\n" 2995 " [ , SEND = %s ]\n" 2996 " [ , TYPMOD_IN = %s ]\n" 2997 " [ , TYPMOD_OUT = %s ]\n" 2998 " [ , ANALYZE = %s ]\n" 2999 " [ , INTERNALLENGTH = { %s | VARIABLE } ]\n" 3000 " [ , PASSEDBYVALUE ]\n" 3001 " [ , ALIGNMENT = %s ]\n" 3002 " [ , STORAGE = %s ]\n" 3003 " [ , LIKE = %s ]\n" 3004 " [ , CATEGORY = %s ]\n" 3005 " [ , PREFERRED = %s ]\n" 3006 " [ , DEFAULT = %s ]\n" 3007 " [ , ELEMENT = %s ]\n" 3008 " [ , DELIMITER = %s ]\n" 3009 " [ , COLLATABLE = %s ]\n" 3010 ")\n" 3011 "\n" 3012 "CREATE TYPE %s", 3013 _("name"), 3014 _("attribute_name"), 3015 _("data_type"), 3016 _("collation"), 3017 _("name"), 3018 _("label"), 3019 _("name"), 3020 _("subtype"), 3021 _("subtype_operator_class"), 3022 _("collation"), 3023 _("canonical_function"), 3024 _("subtype_diff_function"), 3025 _("name"), 3026 _("input_function"), 3027 _("output_function"), 3028 _("receive_function"), 3029 _("send_function"), 3030 _("type_modifier_input_function"), 3031 _("type_modifier_output_function"), 3032 _("analyze_function"), 3033 _("internallength"), 3034 _("alignment"), 3035 _("storage"), 3036 _("like_type"), 3037 _("category"), 3038 _("preferred"), 3039 _("default"), 3040 _("element"), 3041 _("delimiter"), 3042 _("collatable"), 3043 _("name")); 3044 } 3045 3046 static void 3047 sql_help_CREATE_USER(PQExpBuffer buf) 3048 { 3049 appendPQExpBuffer(buf, 3050 "CREATE USER %s [ [ WITH ] %s [ ... ] ]\n" 3051 "\n" 3052 "%s\n" 3053 "\n" 3054 " SUPERUSER | NOSUPERUSER\n" 3055 " | CREATEDB | NOCREATEDB\n" 3056 " | CREATEROLE | NOCREATEROLE\n" 3057 " | INHERIT | NOINHERIT\n" 3058 " | LOGIN | NOLOGIN\n" 3059 " | REPLICATION | NOREPLICATION\n" 3060 " | BYPASSRLS | NOBYPASSRLS\n" 3061 " | CONNECTION LIMIT %s\n" 3062 " | [ ENCRYPTED ] PASSWORD '%s' | PASSWORD NULL\n" 3063 " | VALID UNTIL '%s'\n" 3064 " | IN ROLE %s [, ...]\n" 3065 " | IN GROUP %s [, ...]\n" 3066 " | ROLE %s [, ...]\n" 3067 " | ADMIN %s [, ...]\n" 3068 " | USER %s [, ...]\n" 3069 " | SYSID %s", 3070 _("name"), 3071 _("option"), 3072 _("where option can be:"), 3073 _("connlimit"), 3074 _("password"), 3075 _("timestamp"), 3076 _("role_name"), 3077 _("role_name"), 3078 _("role_name"), 3079 _("role_name"), 3080 _("role_name"), 3081 _("uid")); 3082 } 3083 3084 static void 3085 sql_help_CREATE_USER_MAPPING(PQExpBuffer buf) 3086 { 3087 appendPQExpBuffer(buf, 3088 "CREATE USER MAPPING [ IF NOT EXISTS ] FOR { %s | USER | CURRENT_USER | PUBLIC }\n" 3089 " SERVER %s\n" 3090 " [ OPTIONS ( %s '%s' [ , ... ] ) ]", 3091 _("user_name"), 3092 _("server_name"), 3093 _("option"), 3094 _("value")); 3095 } 3096 3097 static void 3098 sql_help_CREATE_VIEW(PQExpBuffer buf) 3099 { 3100 appendPQExpBuffer(buf, 3101 "CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW %s [ ( %s [, ...] ) ]\n" 3102 " [ WITH ( %s [= %s] [, ... ] ) ]\n" 3103 " AS %s\n" 3104 " [ WITH [ CASCADED | LOCAL ] CHECK OPTION ]", 3105 _("name"), 3106 _("column_name"), 3107 _("view_option_name"), 3108 _("view_option_value"), 3109 _("query")); 3110 } 3111 3112 static void 3113 sql_help_DEALLOCATE(PQExpBuffer buf) 3114 { 3115 appendPQExpBuffer(buf, 3116 "DEALLOCATE [ PREPARE ] { %s | ALL }", 3117 _("name")); 3118 } 3119 3120 static void 3121 sql_help_DECLARE(PQExpBuffer buf) 3122 { 3123 appendPQExpBuffer(buf, 3124 "DECLARE %s [ BINARY ] [ INSENSITIVE ] [ [ NO ] SCROLL ]\n" 3125 " CURSOR [ { WITH | WITHOUT } HOLD ] FOR %s", 3126 _("name"), 3127 _("query")); 3128 } 3129 3130 static void 3131 sql_help_DELETE(PQExpBuffer buf) 3132 { 3133 appendPQExpBuffer(buf, 3134 "[ WITH [ RECURSIVE ] %s [, ...] ]\n" 3135 "DELETE FROM [ ONLY ] %s [ * ] [ [ AS ] %s ]\n" 3136 " [ USING %s [, ...] ]\n" 3137 " [ WHERE %s | WHERE CURRENT OF %s ]\n" 3138 " [ RETURNING * | %s [ [ AS ] %s ] [, ...] ]", 3139 _("with_query"), 3140 _("table_name"), 3141 _("alias"), 3142 _("from_item"), 3143 _("condition"), 3144 _("cursor_name"), 3145 _("output_expression"), 3146 _("output_name")); 3147 } 3148 3149 static void 3150 sql_help_DISCARD(PQExpBuffer buf) 3151 { 3152 appendPQExpBuffer(buf, 3153 "DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }"); 3154 } 3155 3156 static void 3157 sql_help_DO(PQExpBuffer buf) 3158 { 3159 appendPQExpBuffer(buf, 3160 "DO [ LANGUAGE %s ] %s", 3161 _("lang_name"), 3162 _("code")); 3163 } 3164 3165 static void 3166 sql_help_DROP_ACCESS_METHOD(PQExpBuffer buf) 3167 { 3168 appendPQExpBuffer(buf, 3169 "DROP ACCESS METHOD [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3170 _("name")); 3171 } 3172 3173 static void 3174 sql_help_DROP_AGGREGATE(PQExpBuffer buf) 3175 { 3176 appendPQExpBuffer(buf, 3177 "DROP AGGREGATE [ IF EXISTS ] %s ( %s ) [, ...] [ CASCADE | RESTRICT ]\n" 3178 "\n" 3179 "%s\n" 3180 "\n" 3181 "* |\n" 3182 "[ %s ] [ %s ] %s [ , ... ] |\n" 3183 "[ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ]", 3184 _("name"), 3185 _("aggregate_signature"), 3186 _("where aggregate_signature is:"), 3187 _("argmode"), 3188 _("argname"), 3189 _("argtype"), 3190 _("argmode"), 3191 _("argname"), 3192 _("argtype"), 3193 _("argmode"), 3194 _("argname"), 3195 _("argtype")); 3196 } 3197 3198 static void 3199 sql_help_DROP_CAST(PQExpBuffer buf) 3200 { 3201 appendPQExpBuffer(buf, 3202 "DROP CAST [ IF EXISTS ] (%s AS %s) [ CASCADE | RESTRICT ]", 3203 _("source_type"), 3204 _("target_type")); 3205 } 3206 3207 static void 3208 sql_help_DROP_COLLATION(PQExpBuffer buf) 3209 { 3210 appendPQExpBuffer(buf, 3211 "DROP COLLATION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3212 _("name")); 3213 } 3214 3215 static void 3216 sql_help_DROP_CONVERSION(PQExpBuffer buf) 3217 { 3218 appendPQExpBuffer(buf, 3219 "DROP CONVERSION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3220 _("name")); 3221 } 3222 3223 static void 3224 sql_help_DROP_DATABASE(PQExpBuffer buf) 3225 { 3226 appendPQExpBuffer(buf, 3227 "DROP DATABASE [ IF EXISTS ] %s", 3228 _("name")); 3229 } 3230 3231 static void 3232 sql_help_DROP_DOMAIN(PQExpBuffer buf) 3233 { 3234 appendPQExpBuffer(buf, 3235 "DROP DOMAIN [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3236 _("name")); 3237 } 3238 3239 static void 3240 sql_help_DROP_EVENT_TRIGGER(PQExpBuffer buf) 3241 { 3242 appendPQExpBuffer(buf, 3243 "DROP EVENT TRIGGER [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3244 _("name")); 3245 } 3246 3247 static void 3248 sql_help_DROP_EXTENSION(PQExpBuffer buf) 3249 { 3250 appendPQExpBuffer(buf, 3251 "DROP EXTENSION [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3252 _("name")); 3253 } 3254 3255 static void 3256 sql_help_DROP_FOREIGN_DATA_WRAPPER(PQExpBuffer buf) 3257 { 3258 appendPQExpBuffer(buf, 3259 "DROP FOREIGN DATA WRAPPER [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3260 _("name")); 3261 } 3262 3263 static void 3264 sql_help_DROP_FOREIGN_TABLE(PQExpBuffer buf) 3265 { 3266 appendPQExpBuffer(buf, 3267 "DROP FOREIGN TABLE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3268 _("name")); 3269 } 3270 3271 static void 3272 sql_help_DROP_FUNCTION(PQExpBuffer buf) 3273 { 3274 appendPQExpBuffer(buf, 3275 "DROP FUNCTION [ IF EXISTS ] %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n" 3276 " [ CASCADE | RESTRICT ]", 3277 _("name"), 3278 _("argmode"), 3279 _("argname"), 3280 _("argtype")); 3281 } 3282 3283 static void 3284 sql_help_DROP_GROUP(PQExpBuffer buf) 3285 { 3286 appendPQExpBuffer(buf, 3287 "DROP GROUP [ IF EXISTS ] %s [, ...]", 3288 _("name")); 3289 } 3290 3291 static void 3292 sql_help_DROP_INDEX(PQExpBuffer buf) 3293 { 3294 appendPQExpBuffer(buf, 3295 "DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3296 _("name")); 3297 } 3298 3299 static void 3300 sql_help_DROP_LANGUAGE(PQExpBuffer buf) 3301 { 3302 appendPQExpBuffer(buf, 3303 "DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3304 _("name")); 3305 } 3306 3307 static void 3308 sql_help_DROP_MATERIALIZED_VIEW(PQExpBuffer buf) 3309 { 3310 appendPQExpBuffer(buf, 3311 "DROP MATERIALIZED VIEW [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3312 _("name")); 3313 } 3314 3315 static void 3316 sql_help_DROP_OPERATOR(PQExpBuffer buf) 3317 { 3318 appendPQExpBuffer(buf, 3319 "DROP OPERATOR [ IF EXISTS ] %s ( { %s | NONE } , { %s | NONE } ) [, ...] [ CASCADE | RESTRICT ]", 3320 _("name"), 3321 _("left_type"), 3322 _("right_type")); 3323 } 3324 3325 static void 3326 sql_help_DROP_OPERATOR_CLASS(PQExpBuffer buf) 3327 { 3328 appendPQExpBuffer(buf, 3329 "DROP OPERATOR CLASS [ IF EXISTS ] %s USING %s [ CASCADE | RESTRICT ]", 3330 _("name"), 3331 _("index_method")); 3332 } 3333 3334 static void 3335 sql_help_DROP_OPERATOR_FAMILY(PQExpBuffer buf) 3336 { 3337 appendPQExpBuffer(buf, 3338 "DROP OPERATOR FAMILY [ IF EXISTS ] %s USING %s [ CASCADE | RESTRICT ]", 3339 _("name"), 3340 _("index_method")); 3341 } 3342 3343 static void 3344 sql_help_DROP_OWNED(PQExpBuffer buf) 3345 { 3346 appendPQExpBuffer(buf, 3347 "DROP OWNED BY { %s | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ]", 3348 _("name")); 3349 } 3350 3351 static void 3352 sql_help_DROP_POLICY(PQExpBuffer buf) 3353 { 3354 appendPQExpBuffer(buf, 3355 "DROP POLICY [ IF EXISTS ] %s ON %s [ CASCADE | RESTRICT ]", 3356 _("name"), 3357 _("table_name")); 3358 } 3359 3360 static void 3361 sql_help_DROP_PROCEDURE(PQExpBuffer buf) 3362 { 3363 appendPQExpBuffer(buf, 3364 "DROP PROCEDURE [ IF EXISTS ] %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n" 3365 " [ CASCADE | RESTRICT ]", 3366 _("name"), 3367 _("argmode"), 3368 _("argname"), 3369 _("argtype")); 3370 } 3371 3372 static void 3373 sql_help_DROP_PUBLICATION(PQExpBuffer buf) 3374 { 3375 appendPQExpBuffer(buf, 3376 "DROP PUBLICATION [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3377 _("name")); 3378 } 3379 3380 static void 3381 sql_help_DROP_ROLE(PQExpBuffer buf) 3382 { 3383 appendPQExpBuffer(buf, 3384 "DROP ROLE [ IF EXISTS ] %s [, ...]", 3385 _("name")); 3386 } 3387 3388 static void 3389 sql_help_DROP_ROUTINE(PQExpBuffer buf) 3390 { 3391 appendPQExpBuffer(buf, 3392 "DROP ROUTINE [ IF EXISTS ] %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n" 3393 " [ CASCADE | RESTRICT ]", 3394 _("name"), 3395 _("argmode"), 3396 _("argname"), 3397 _("argtype")); 3398 } 3399 3400 static void 3401 sql_help_DROP_RULE(PQExpBuffer buf) 3402 { 3403 appendPQExpBuffer(buf, 3404 "DROP RULE [ IF EXISTS ] %s ON %s [ CASCADE | RESTRICT ]", 3405 _("name"), 3406 _("table_name")); 3407 } 3408 3409 static void 3410 sql_help_DROP_SCHEMA(PQExpBuffer buf) 3411 { 3412 appendPQExpBuffer(buf, 3413 "DROP SCHEMA [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3414 _("name")); 3415 } 3416 3417 static void 3418 sql_help_DROP_SEQUENCE(PQExpBuffer buf) 3419 { 3420 appendPQExpBuffer(buf, 3421 "DROP SEQUENCE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3422 _("name")); 3423 } 3424 3425 static void 3426 sql_help_DROP_SERVER(PQExpBuffer buf) 3427 { 3428 appendPQExpBuffer(buf, 3429 "DROP SERVER [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3430 _("name")); 3431 } 3432 3433 static void 3434 sql_help_DROP_STATISTICS(PQExpBuffer buf) 3435 { 3436 appendPQExpBuffer(buf, 3437 "DROP STATISTICS [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3438 _("name")); 3439 } 3440 3441 static void 3442 sql_help_DROP_SUBSCRIPTION(PQExpBuffer buf) 3443 { 3444 appendPQExpBuffer(buf, 3445 "DROP SUBSCRIPTION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3446 _("name")); 3447 } 3448 3449 static void 3450 sql_help_DROP_TABLE(PQExpBuffer buf) 3451 { 3452 appendPQExpBuffer(buf, 3453 "DROP TABLE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3454 _("name")); 3455 } 3456 3457 static void 3458 sql_help_DROP_TABLESPACE(PQExpBuffer buf) 3459 { 3460 appendPQExpBuffer(buf, 3461 "DROP TABLESPACE [ IF EXISTS ] %s", 3462 _("name")); 3463 } 3464 3465 static void 3466 sql_help_DROP_TEXT_SEARCH_CONFIGURATION(PQExpBuffer buf) 3467 { 3468 appendPQExpBuffer(buf, 3469 "DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3470 _("name")); 3471 } 3472 3473 static void 3474 sql_help_DROP_TEXT_SEARCH_DICTIONARY(PQExpBuffer buf) 3475 { 3476 appendPQExpBuffer(buf, 3477 "DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3478 _("name")); 3479 } 3480 3481 static void 3482 sql_help_DROP_TEXT_SEARCH_PARSER(PQExpBuffer buf) 3483 { 3484 appendPQExpBuffer(buf, 3485 "DROP TEXT SEARCH PARSER [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3486 _("name")); 3487 } 3488 3489 static void 3490 sql_help_DROP_TEXT_SEARCH_TEMPLATE(PQExpBuffer buf) 3491 { 3492 appendPQExpBuffer(buf, 3493 "DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] %s [ CASCADE | RESTRICT ]", 3494 _("name")); 3495 } 3496 3497 static void 3498 sql_help_DROP_TRANSFORM(PQExpBuffer buf) 3499 { 3500 appendPQExpBuffer(buf, 3501 "DROP TRANSFORM [ IF EXISTS ] FOR %s LANGUAGE %s [ CASCADE | RESTRICT ]", 3502 _("type_name"), 3503 _("lang_name")); 3504 } 3505 3506 static void 3507 sql_help_DROP_TRIGGER(PQExpBuffer buf) 3508 { 3509 appendPQExpBuffer(buf, 3510 "DROP TRIGGER [ IF EXISTS ] %s ON %s [ CASCADE | RESTRICT ]", 3511 _("name"), 3512 _("table_name")); 3513 } 3514 3515 static void 3516 sql_help_DROP_TYPE(PQExpBuffer buf) 3517 { 3518 appendPQExpBuffer(buf, 3519 "DROP TYPE [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3520 _("name")); 3521 } 3522 3523 static void 3524 sql_help_DROP_USER(PQExpBuffer buf) 3525 { 3526 appendPQExpBuffer(buf, 3527 "DROP USER [ IF EXISTS ] %s [, ...]", 3528 _("name")); 3529 } 3530 3531 static void 3532 sql_help_DROP_USER_MAPPING(PQExpBuffer buf) 3533 { 3534 appendPQExpBuffer(buf, 3535 "DROP USER MAPPING [ IF EXISTS ] FOR { %s | USER | CURRENT_USER | PUBLIC } SERVER %s", 3536 _("user_name"), 3537 _("server_name")); 3538 } 3539 3540 static void 3541 sql_help_DROP_VIEW(PQExpBuffer buf) 3542 { 3543 appendPQExpBuffer(buf, 3544 "DROP VIEW [ IF EXISTS ] %s [, ...] [ CASCADE | RESTRICT ]", 3545 _("name")); 3546 } 3547 3548 static void 3549 sql_help_END(PQExpBuffer buf) 3550 { 3551 appendPQExpBuffer(buf, 3552 "END [ WORK | TRANSACTION ]"); 3553 } 3554 3555 static void 3556 sql_help_EXECUTE(PQExpBuffer buf) 3557 { 3558 appendPQExpBuffer(buf, 3559 "EXECUTE %s [ ( %s [, ...] ) ]", 3560 _("name"), 3561 _("parameter")); 3562 } 3563 3564 static void 3565 sql_help_EXPLAIN(PQExpBuffer buf) 3566 { 3567 appendPQExpBuffer(buf, 3568 "EXPLAIN [ ( %s [, ...] ) ] %s\n" 3569 "EXPLAIN [ ANALYZE ] [ VERBOSE ] %s\n" 3570 "\n" 3571 "%s\n" 3572 "\n" 3573 " ANALYZE [ %s ]\n" 3574 " VERBOSE [ %s ]\n" 3575 " COSTS [ %s ]\n" 3576 " BUFFERS [ %s ]\n" 3577 " TIMING [ %s ]\n" 3578 " SUMMARY [ %s ]\n" 3579 " FORMAT { TEXT | XML | JSON | YAML }", 3580 _("option"), 3581 _("statement"), 3582 _("statement"), 3583 _("where option can be one of:"), 3584 _("boolean"), 3585 _("boolean"), 3586 _("boolean"), 3587 _("boolean"), 3588 _("boolean"), 3589 _("boolean")); 3590 } 3591 3592 static void 3593 sql_help_FETCH(PQExpBuffer buf) 3594 { 3595 appendPQExpBuffer(buf, 3596 "FETCH [ %s [ FROM | IN ] ] %s\n" 3597 "\n" 3598 "%s\n" 3599 "\n" 3600 " NEXT\n" 3601 " PRIOR\n" 3602 " FIRST\n" 3603 " LAST\n" 3604 " ABSOLUTE %s\n" 3605 " RELATIVE %s\n" 3606 " %s\n" 3607 " ALL\n" 3608 " FORWARD\n" 3609 " FORWARD %s\n" 3610 " FORWARD ALL\n" 3611 " BACKWARD\n" 3612 " BACKWARD %s\n" 3613 " BACKWARD ALL", 3614 _("direction"), 3615 _("cursor_name"), 3616 _("where direction can be empty or one of:"), 3617 _("count"), 3618 _("count"), 3619 _("count"), 3620 _("count"), 3621 _("count")); 3622 } 3623 3624 static void 3625 sql_help_GRANT(PQExpBuffer buf) 3626 { 3627 appendPQExpBuffer(buf, 3628 "GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }\n" 3629 " [, ...] | ALL [ PRIVILEGES ] }\n" 3630 " ON { [ TABLE ] %s [, ...]\n" 3631 " | ALL TABLES IN SCHEMA %s [, ...] }\n" 3632 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3633 "\n" 3634 "GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( %s [, ...] )\n" 3635 " [, ...] | ALL [ PRIVILEGES ] ( %s [, ...] ) }\n" 3636 " ON [ TABLE ] %s [, ...]\n" 3637 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3638 "\n" 3639 "GRANT { { USAGE | SELECT | UPDATE }\n" 3640 " [, ...] | ALL [ PRIVILEGES ] }\n" 3641 " ON { SEQUENCE %s [, ...]\n" 3642 " | ALL SEQUENCES IN SCHEMA %s [, ...] }\n" 3643 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3644 "\n" 3645 "GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }\n" 3646 " ON DATABASE %s [, ...]\n" 3647 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3648 "\n" 3649 "GRANT { USAGE | ALL [ PRIVILEGES ] }\n" 3650 " ON DOMAIN %s [, ...]\n" 3651 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3652 "\n" 3653 "GRANT { USAGE | ALL [ PRIVILEGES ] }\n" 3654 " ON FOREIGN DATA WRAPPER %s [, ...]\n" 3655 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3656 "\n" 3657 "GRANT { USAGE | ALL [ PRIVILEGES ] }\n" 3658 " ON FOREIGN SERVER %s [, ...]\n" 3659 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3660 "\n" 3661 "GRANT { EXECUTE | ALL [ PRIVILEGES ] }\n" 3662 " ON { { FUNCTION | PROCEDURE | ROUTINE } %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n" 3663 " | ALL { FUNCTIONS | PROCEDURES | ROUTINES } IN SCHEMA %s [, ...] }\n" 3664 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3665 "\n" 3666 "GRANT { USAGE | ALL [ PRIVILEGES ] }\n" 3667 " ON LANGUAGE %s [, ...]\n" 3668 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3669 "\n" 3670 "GRANT { { SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] }\n" 3671 " ON LARGE OBJECT %s [, ...]\n" 3672 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3673 "\n" 3674 "GRANT { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }\n" 3675 " ON SCHEMA %s [, ...]\n" 3676 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3677 "\n" 3678 "GRANT { CREATE | ALL [ PRIVILEGES ] }\n" 3679 " ON TABLESPACE %s [, ...]\n" 3680 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3681 "\n" 3682 "GRANT { USAGE | ALL [ PRIVILEGES ] }\n" 3683 " ON TYPE %s [, ...]\n" 3684 " TO %s [, ...] [ WITH GRANT OPTION ]\n" 3685 "\n" 3686 "GRANT %s [, ...] TO %s [, ...]\n" 3687 " [ WITH ADMIN OPTION ]\n" 3688 " [ GRANTED BY %s ]\n" 3689 "\n" 3690 "%s\n" 3691 "\n" 3692 " [ GROUP ] %s\n" 3693 " | PUBLIC\n" 3694 " | CURRENT_USER\n" 3695 " | SESSION_USER", 3696 _("table_name"), 3697 _("schema_name"), 3698 _("role_specification"), 3699 _("column_name"), 3700 _("column_name"), 3701 _("table_name"), 3702 _("role_specification"), 3703 _("sequence_name"), 3704 _("schema_name"), 3705 _("role_specification"), 3706 _("database_name"), 3707 _("role_specification"), 3708 _("domain_name"), 3709 _("role_specification"), 3710 _("fdw_name"), 3711 _("role_specification"), 3712 _("server_name"), 3713 _("role_specification"), 3714 _("routine_name"), 3715 _("argmode"), 3716 _("arg_name"), 3717 _("arg_type"), 3718 _("schema_name"), 3719 _("role_specification"), 3720 _("lang_name"), 3721 _("role_specification"), 3722 _("loid"), 3723 _("role_specification"), 3724 _("schema_name"), 3725 _("role_specification"), 3726 _("tablespace_name"), 3727 _("role_specification"), 3728 _("type_name"), 3729 _("role_specification"), 3730 _("role_name"), 3731 _("role_specification"), 3732 _("role_specification"), 3733 _("where role_specification can be:"), 3734 _("role_name")); 3735 } 3736 3737 static void 3738 sql_help_IMPORT_FOREIGN_SCHEMA(PQExpBuffer buf) 3739 { 3740 appendPQExpBuffer(buf, 3741 "IMPORT FOREIGN SCHEMA %s\n" 3742 " [ { LIMIT TO | EXCEPT } ( %s [, ...] ) ]\n" 3743 " FROM SERVER %s\n" 3744 " INTO %s\n" 3745 " [ OPTIONS ( %s '%s' [, ... ] ) ]", 3746 _("remote_schema"), 3747 _("table_name"), 3748 _("server_name"), 3749 _("local_schema"), 3750 _("option"), 3751 _("value")); 3752 } 3753 3754 static void 3755 sql_help_INSERT(PQExpBuffer buf) 3756 { 3757 appendPQExpBuffer(buf, 3758 "[ WITH [ RECURSIVE ] %s [, ...] ]\n" 3759 "INSERT INTO %s [ AS %s ] [ ( %s [, ...] ) ]\n" 3760 " [ OVERRIDING { SYSTEM | USER } VALUE ]\n" 3761 " { DEFAULT VALUES | VALUES ( { %s | DEFAULT } [, ...] ) [, ...] | %s }\n" 3762 " [ ON CONFLICT [ %s ] %s ]\n" 3763 " [ RETURNING * | %s [ [ AS ] %s ] [, ...] ]\n" 3764 "\n" 3765 "%s\n" 3766 "\n" 3767 " ( { %s | ( %s ) } [ COLLATE %s ] [ %s ] [, ...] ) [ WHERE %s ]\n" 3768 " ON CONSTRAINT %s\n" 3769 "\n" 3770 "%s\n" 3771 "\n" 3772 " DO NOTHING\n" 3773 " DO UPDATE SET { %s = { %s | DEFAULT } |\n" 3774 " ( %s [, ...] ) = [ ROW ] ( { %s | DEFAULT } [, ...] ) |\n" 3775 " ( %s [, ...] ) = ( %s )\n" 3776 " } [, ...]\n" 3777 " [ WHERE %s ]", 3778 _("with_query"), 3779 _("table_name"), 3780 _("alias"), 3781 _("column_name"), 3782 _("expression"), 3783 _("query"), 3784 _("conflict_target"), 3785 _("conflict_action"), 3786 _("output_expression"), 3787 _("output_name"), 3788 _("where conflict_target can be one of:"), 3789 _("index_column_name"), 3790 _("index_expression"), 3791 _("collation"), 3792 _("opclass"), 3793 _("index_predicate"), 3794 _("constraint_name"), 3795 _("and conflict_action is one of:"), 3796 _("column_name"), 3797 _("expression"), 3798 _("column_name"), 3799 _("expression"), 3800 _("column_name"), 3801 _("sub-SELECT"), 3802 _("condition")); 3803 } 3804 3805 static void 3806 sql_help_LISTEN(PQExpBuffer buf) 3807 { 3808 appendPQExpBuffer(buf, 3809 "LISTEN %s", 3810 _("channel")); 3811 } 3812 3813 static void 3814 sql_help_LOAD(PQExpBuffer buf) 3815 { 3816 appendPQExpBuffer(buf, 3817 "LOAD '%s'", 3818 _("filename")); 3819 } 3820 3821 static void 3822 sql_help_LOCK(PQExpBuffer buf) 3823 { 3824 appendPQExpBuffer(buf, 3825 "LOCK [ TABLE ] [ ONLY ] %s [ * ] [, ...] [ IN %s MODE ] [ NOWAIT ]\n" 3826 "\n" 3827 "%s\n" 3828 "\n" 3829 " ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE\n" 3830 " | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE", 3831 _("name"), 3832 _("lockmode"), 3833 _("where lockmode is one of:")); 3834 } 3835 3836 static void 3837 sql_help_MOVE(PQExpBuffer buf) 3838 { 3839 appendPQExpBuffer(buf, 3840 "MOVE [ %s [ FROM | IN ] ] %s\n" 3841 "\n" 3842 "%s\n" 3843 "\n" 3844 " NEXT\n" 3845 " PRIOR\n" 3846 " FIRST\n" 3847 " LAST\n" 3848 " ABSOLUTE %s\n" 3849 " RELATIVE %s\n" 3850 " %s\n" 3851 " ALL\n" 3852 " FORWARD\n" 3853 " FORWARD %s\n" 3854 " FORWARD ALL\n" 3855 " BACKWARD\n" 3856 " BACKWARD %s\n" 3857 " BACKWARD ALL", 3858 _("direction"), 3859 _("cursor_name"), 3860 _("where direction can be empty or one of:"), 3861 _("count"), 3862 _("count"), 3863 _("count"), 3864 _("count"), 3865 _("count")); 3866 } 3867 3868 static void 3869 sql_help_NOTIFY(PQExpBuffer buf) 3870 { 3871 appendPQExpBuffer(buf, 3872 "NOTIFY %s [ , %s ]", 3873 _("channel"), 3874 _("payload")); 3875 } 3876 3877 static void 3878 sql_help_PREPARE(PQExpBuffer buf) 3879 { 3880 appendPQExpBuffer(buf, 3881 "PREPARE %s [ ( %s [, ...] ) ] AS %s", 3882 _("name"), 3883 _("data_type"), 3884 _("statement")); 3885 } 3886 3887 static void 3888 sql_help_PREPARE_TRANSACTION(PQExpBuffer buf) 3889 { 3890 appendPQExpBuffer(buf, 3891 "PREPARE TRANSACTION %s", 3892 _("transaction_id")); 3893 } 3894 3895 static void 3896 sql_help_REASSIGN_OWNED(PQExpBuffer buf) 3897 { 3898 appendPQExpBuffer(buf, 3899 "REASSIGN OWNED BY { %s | CURRENT_USER | SESSION_USER } [, ...]\n" 3900 " TO { %s | CURRENT_USER | SESSION_USER }", 3901 _("old_role"), 3902 _("new_role")); 3903 } 3904 3905 static void 3906 sql_help_REFRESH_MATERIALIZED_VIEW(PQExpBuffer buf) 3907 { 3908 appendPQExpBuffer(buf, 3909 "REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] %s\n" 3910 " [ WITH [ NO ] DATA ]", 3911 _("name")); 3912 } 3913 3914 static void 3915 sql_help_REINDEX(PQExpBuffer buf) 3916 { 3917 appendPQExpBuffer(buf, 3918 "REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } %s", 3919 _("name")); 3920 } 3921 3922 static void 3923 sql_help_RELEASE_SAVEPOINT(PQExpBuffer buf) 3924 { 3925 appendPQExpBuffer(buf, 3926 "RELEASE [ SAVEPOINT ] %s", 3927 _("savepoint_name")); 3928 } 3929 3930 static void 3931 sql_help_RESET(PQExpBuffer buf) 3932 { 3933 appendPQExpBuffer(buf, 3934 "RESET %s\n" 3935 "RESET ALL", 3936 _("configuration_parameter")); 3937 } 3938 3939 static void 3940 sql_help_REVOKE(PQExpBuffer buf) 3941 { 3942 appendPQExpBuffer(buf, 3943 "REVOKE [ GRANT OPTION FOR ]\n" 3944 " { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }\n" 3945 " [, ...] | ALL [ PRIVILEGES ] }\n" 3946 " ON { [ TABLE ] %s [, ...]\n" 3947 " | ALL TABLES IN SCHEMA %s [, ...] }\n" 3948 " FROM %s [, ...]\n" 3949 " [ CASCADE | RESTRICT ]\n" 3950 "\n" 3951 "REVOKE [ GRANT OPTION FOR ]\n" 3952 " { { SELECT | INSERT | UPDATE | REFERENCES } ( %s [, ...] )\n" 3953 " [, ...] | ALL [ PRIVILEGES ] ( %s [, ...] ) }\n" 3954 " ON [ TABLE ] %s [, ...]\n" 3955 " FROM %s [, ...]\n" 3956 " [ CASCADE | RESTRICT ]\n" 3957 "\n" 3958 "REVOKE [ GRANT OPTION FOR ]\n" 3959 " { { USAGE | SELECT | UPDATE }\n" 3960 " [, ...] | ALL [ PRIVILEGES ] }\n" 3961 " ON { SEQUENCE %s [, ...]\n" 3962 " | ALL SEQUENCES IN SCHEMA %s [, ...] }\n" 3963 " FROM %s [, ...]\n" 3964 " [ CASCADE | RESTRICT ]\n" 3965 "\n" 3966 "REVOKE [ GRANT OPTION FOR ]\n" 3967 " { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }\n" 3968 " ON DATABASE %s [, ...]\n" 3969 " FROM %s [, ...]\n" 3970 " [ CASCADE | RESTRICT ]\n" 3971 "\n" 3972 "REVOKE [ GRANT OPTION FOR ]\n" 3973 " { USAGE | ALL [ PRIVILEGES ] }\n" 3974 " ON DOMAIN %s [, ...]\n" 3975 " FROM %s [, ...]\n" 3976 " [ CASCADE | RESTRICT ]\n" 3977 "\n" 3978 "REVOKE [ GRANT OPTION FOR ]\n" 3979 " { USAGE | ALL [ PRIVILEGES ] }\n" 3980 " ON FOREIGN DATA WRAPPER %s [, ...]\n" 3981 " FROM %s [, ...]\n" 3982 " [ CASCADE | RESTRICT ]\n" 3983 "\n" 3984 "REVOKE [ GRANT OPTION FOR ]\n" 3985 " { USAGE | ALL [ PRIVILEGES ] }\n" 3986 " ON FOREIGN SERVER %s [, ...]\n" 3987 " FROM %s [, ...]\n" 3988 " [ CASCADE | RESTRICT ]\n" 3989 "\n" 3990 "REVOKE [ GRANT OPTION FOR ]\n" 3991 " { EXECUTE | ALL [ PRIVILEGES ] }\n" 3992 " ON { { FUNCTION | PROCEDURE | ROUTINE } %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] [, ...]\n" 3993 " | ALL { FUNCTIONS | PROCEDURES | ROUTINES } IN SCHEMA %s [, ...] }\n" 3994 " FROM %s [, ...]\n" 3995 " [ CASCADE | RESTRICT ]\n" 3996 "\n" 3997 "REVOKE [ GRANT OPTION FOR ]\n" 3998 " { USAGE | ALL [ PRIVILEGES ] }\n" 3999 " ON LANGUAGE %s [, ...]\n" 4000 " FROM %s [, ...]\n" 4001 " [ CASCADE | RESTRICT ]\n" 4002 "\n" 4003 "REVOKE [ GRANT OPTION FOR ]\n" 4004 " { { SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] }\n" 4005 " ON LARGE OBJECT %s [, ...]\n" 4006 " FROM %s [, ...]\n" 4007 " [ CASCADE | RESTRICT ]\n" 4008 "\n" 4009 "REVOKE [ GRANT OPTION FOR ]\n" 4010 " { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }\n" 4011 " ON SCHEMA %s [, ...]\n" 4012 " FROM %s [, ...]\n" 4013 " [ CASCADE | RESTRICT ]\n" 4014 "\n" 4015 "REVOKE [ GRANT OPTION FOR ]\n" 4016 " { CREATE | ALL [ PRIVILEGES ] }\n" 4017 " ON TABLESPACE %s [, ...]\n" 4018 " FROM %s [, ...]\n" 4019 " [ CASCADE | RESTRICT ]\n" 4020 "\n" 4021 "REVOKE [ GRANT OPTION FOR ]\n" 4022 " { USAGE | ALL [ PRIVILEGES ] }\n" 4023 " ON TYPE %s [, ...]\n" 4024 " FROM %s [, ...]\n" 4025 " [ CASCADE | RESTRICT ]\n" 4026 "\n" 4027 "REVOKE [ ADMIN OPTION FOR ]\n" 4028 " %s [, ...] FROM %s [, ...]\n" 4029 " [ GRANTED BY %s ]\n" 4030 " [ CASCADE | RESTRICT ]\n" 4031 "\n" 4032 "%s\n" 4033 "\n" 4034 " [ GROUP ] %s\n" 4035 " | PUBLIC\n" 4036 " | CURRENT_USER\n" 4037 " | SESSION_USER", 4038 _("table_name"), 4039 _("schema_name"), 4040 _("role_specification"), 4041 _("column_name"), 4042 _("column_name"), 4043 _("table_name"), 4044 _("role_specification"), 4045 _("sequence_name"), 4046 _("schema_name"), 4047 _("role_specification"), 4048 _("database_name"), 4049 _("role_specification"), 4050 _("domain_name"), 4051 _("role_specification"), 4052 _("fdw_name"), 4053 _("role_specification"), 4054 _("server_name"), 4055 _("role_specification"), 4056 _("function_name"), 4057 _("argmode"), 4058 _("arg_name"), 4059 _("arg_type"), 4060 _("schema_name"), 4061 _("role_specification"), 4062 _("lang_name"), 4063 _("role_specification"), 4064 _("loid"), 4065 _("role_specification"), 4066 _("schema_name"), 4067 _("role_specification"), 4068 _("tablespace_name"), 4069 _("role_specification"), 4070 _("type_name"), 4071 _("role_specification"), 4072 _("role_name"), 4073 _("role_specification"), 4074 _("role_specification"), 4075 _("where role_specification can be:"), 4076 _("role_name")); 4077 } 4078 4079 static void 4080 sql_help_ROLLBACK(PQExpBuffer buf) 4081 { 4082 appendPQExpBuffer(buf, 4083 "ROLLBACK [ WORK | TRANSACTION ]"); 4084 } 4085 4086 static void 4087 sql_help_ROLLBACK_PREPARED(PQExpBuffer buf) 4088 { 4089 appendPQExpBuffer(buf, 4090 "ROLLBACK PREPARED %s", 4091 _("transaction_id")); 4092 } 4093 4094 static void 4095 sql_help_ROLLBACK_TO_SAVEPOINT(PQExpBuffer buf) 4096 { 4097 appendPQExpBuffer(buf, 4098 "ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] %s", 4099 _("savepoint_name")); 4100 } 4101 4102 static void 4103 sql_help_SAVEPOINT(PQExpBuffer buf) 4104 { 4105 appendPQExpBuffer(buf, 4106 "SAVEPOINT %s", 4107 _("savepoint_name")); 4108 } 4109 4110 static void 4111 sql_help_SECURITY_LABEL(PQExpBuffer buf) 4112 { 4113 appendPQExpBuffer(buf, 4114 "SECURITY LABEL [ FOR %s ] ON\n" 4115 "{\n" 4116 " TABLE %s |\n" 4117 " COLUMN %s.%s |\n" 4118 " AGGREGATE %s ( %s ) |\n" 4119 " DATABASE %s |\n" 4120 " DOMAIN %s |\n" 4121 " EVENT TRIGGER %s |\n" 4122 " FOREIGN TABLE %s\n" 4123 " FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n" 4124 " LARGE OBJECT %s |\n" 4125 " MATERIALIZED VIEW %s |\n" 4126 " [ PROCEDURAL ] LANGUAGE %s |\n" 4127 " PROCEDURE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n" 4128 " PUBLICATION %s |\n" 4129 " ROLE %s |\n" 4130 " ROUTINE %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n" 4131 " SCHEMA %s |\n" 4132 " SEQUENCE %s |\n" 4133 " SUBSCRIPTION %s |\n" 4134 " TABLESPACE %s |\n" 4135 " TYPE %s |\n" 4136 " VIEW %s\n" 4137 "} IS '%s'\n" 4138 "\n" 4139 "%s\n" 4140 "\n" 4141 "* |\n" 4142 "[ %s ] [ %s ] %s [ , ... ] |\n" 4143 "[ [ %s ] [ %s ] %s [ , ... ] ] ORDER BY [ %s ] [ %s ] %s [ , ... ]", 4144 _("provider"), 4145 _("object_name"), 4146 _("table_name"), 4147 _("column_name"), 4148 _("aggregate_name"), 4149 _("aggregate_signature"), 4150 _("object_name"), 4151 _("object_name"), 4152 _("object_name"), 4153 _("object_name"), 4154 _("function_name"), 4155 _("argmode"), 4156 _("argname"), 4157 _("argtype"), 4158 _("large_object_oid"), 4159 _("object_name"), 4160 _("object_name"), 4161 _("procedure_name"), 4162 _("argmode"), 4163 _("argname"), 4164 _("argtype"), 4165 _("object_name"), 4166 _("object_name"), 4167 _("routine_name"), 4168 _("argmode"), 4169 _("argname"), 4170 _("argtype"), 4171 _("object_name"), 4172 _("object_name"), 4173 _("object_name"), 4174 _("object_name"), 4175 _("object_name"), 4176 _("object_name"), 4177 _("label"), 4178 _("where aggregate_signature is:"), 4179 _("argmode"), 4180 _("argname"), 4181 _("argtype"), 4182 _("argmode"), 4183 _("argname"), 4184 _("argtype"), 4185 _("argmode"), 4186 _("argname"), 4187 _("argtype")); 4188 } 4189 4190 static void 4191 sql_help_SELECT(PQExpBuffer buf) 4192 { 4193 appendPQExpBuffer(buf, 4194 "[ WITH [ RECURSIVE ] %s [, ...] ]\n" 4195 "SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n" 4196 " [ * | %s [ [ AS ] %s ] [, ...] ]\n" 4197 " [ FROM %s [, ...] ]\n" 4198 " [ WHERE %s ]\n" 4199 " [ GROUP BY %s [, ...] ]\n" 4200 " [ HAVING %s ]\n" 4201 " [ WINDOW %s AS ( %s ) [, ...] ]\n" 4202 " [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n" 4203 " [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n" 4204 " [ LIMIT { %s | ALL } ]\n" 4205 " [ OFFSET %s [ ROW | ROWS ] ]\n" 4206 " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]\n" 4207 " [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF %s [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ]\n" 4208 "\n" 4209 "%s\n" 4210 "\n" 4211 " [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4212 " [ TABLESAMPLE %s ( %s [, ...] ) [ REPEATABLE ( %s ) ] ]\n" 4213 " [ LATERAL ] ( %s ) [ AS ] %s [ ( %s [, ...] ) ]\n" 4214 " %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4215 " [ LATERAL ] %s ( [ %s [, ...] ] )\n" 4216 " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4217 " [ LATERAL ] %s ( [ %s [, ...] ] ) [ AS ] %s ( %s [, ...] )\n" 4218 " [ LATERAL ] %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n" 4219 " [ LATERAL ] ROWS FROM( %s ( [ %s [, ...] ] ) [ AS ( %s [, ...] ) ] [, ...] )\n" 4220 " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4221 " %s [ NATURAL ] %s %s [ ON %s | USING ( %s [, ...] ) ]\n" 4222 "\n" 4223 "%s\n" 4224 "\n" 4225 " ( )\n" 4226 " %s\n" 4227 " ( %s [, ...] )\n" 4228 " ROLLUP ( { %s | ( %s [, ...] ) } [, ...] )\n" 4229 " CUBE ( { %s | ( %s [, ...] ) } [, ...] )\n" 4230 " GROUPING SETS ( %s [, ...] )\n" 4231 "\n" 4232 "%s\n" 4233 "\n" 4234 " %s [ ( %s [, ...] ) ] AS ( %s | %s | %s | %s | %s )\n" 4235 "\n" 4236 "TABLE [ ONLY ] %s [ * ]", 4237 _("with_query"), 4238 _("expression"), 4239 _("expression"), 4240 _("output_name"), 4241 _("from_item"), 4242 _("condition"), 4243 _("grouping_element"), 4244 _("condition"), 4245 _("window_name"), 4246 _("window_definition"), 4247 _("select"), 4248 _("expression"), 4249 _("operator"), 4250 _("count"), 4251 _("start"), 4252 _("count"), 4253 _("table_name"), 4254 _("where from_item can be one of:"), 4255 _("table_name"), 4256 _("alias"), 4257 _("column_alias"), 4258 _("sampling_method"), 4259 _("argument"), 4260 _("seed"), 4261 _("select"), 4262 _("alias"), 4263 _("column_alias"), 4264 _("with_query_name"), 4265 _("alias"), 4266 _("column_alias"), 4267 _("function_name"), 4268 _("argument"), 4269 _("alias"), 4270 _("column_alias"), 4271 _("function_name"), 4272 _("argument"), 4273 _("alias"), 4274 _("column_definition"), 4275 _("function_name"), 4276 _("argument"), 4277 _("column_definition"), 4278 _("function_name"), 4279 _("argument"), 4280 _("column_definition"), 4281 _("alias"), 4282 _("column_alias"), 4283 _("from_item"), 4284 _("join_type"), 4285 _("from_item"), 4286 _("join_condition"), 4287 _("join_column"), 4288 _("and grouping_element can be one of:"), 4289 _("expression"), 4290 _("expression"), 4291 _("expression"), 4292 _("expression"), 4293 _("expression"), 4294 _("expression"), 4295 _("grouping_element"), 4296 _("and with_query is:"), 4297 _("with_query_name"), 4298 _("column_name"), 4299 _("select"), 4300 _("values"), 4301 _("insert"), 4302 _("update"), 4303 _("delete"), 4304 _("table_name")); 4305 } 4306 4307 static void 4308 sql_help_SELECT_INTO(PQExpBuffer buf) 4309 { 4310 appendPQExpBuffer(buf, 4311 "[ WITH [ RECURSIVE ] %s [, ...] ]\n" 4312 "SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n" 4313 " * | %s [ [ AS ] %s ] [, ...]\n" 4314 " INTO [ TEMPORARY | TEMP | UNLOGGED ] [ TABLE ] %s\n" 4315 " [ FROM %s [, ...] ]\n" 4316 " [ WHERE %s ]\n" 4317 " [ GROUP BY %s [, ...] ]\n" 4318 " [ HAVING %s ]\n" 4319 " [ WINDOW %s AS ( %s ) [, ...] ]\n" 4320 " [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n" 4321 " [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n" 4322 " [ LIMIT { %s | ALL } ]\n" 4323 " [ OFFSET %s [ ROW | ROWS ] ]\n" 4324 " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]\n" 4325 " [ FOR { UPDATE | SHARE } [ OF %s [, ...] ] [ NOWAIT ] [...] ]", 4326 _("with_query"), 4327 _("expression"), 4328 _("expression"), 4329 _("output_name"), 4330 _("new_table"), 4331 _("from_item"), 4332 _("condition"), 4333 _("expression"), 4334 _("condition"), 4335 _("window_name"), 4336 _("window_definition"), 4337 _("select"), 4338 _("expression"), 4339 _("operator"), 4340 _("count"), 4341 _("start"), 4342 _("count"), 4343 _("table_name")); 4344 } 4345 4346 static void 4347 sql_help_SET(PQExpBuffer buf) 4348 { 4349 appendPQExpBuffer(buf, 4350 "SET [ SESSION | LOCAL ] %s { TO | = } { %s | '%s' | DEFAULT }\n" 4351 "SET [ SESSION | LOCAL ] TIME ZONE { %s | LOCAL | DEFAULT }", 4352 _("configuration_parameter"), 4353 _("value"), 4354 _("value"), 4355 _("timezone")); 4356 } 4357 4358 static void 4359 sql_help_SET_CONSTRAINTS(PQExpBuffer buf) 4360 { 4361 appendPQExpBuffer(buf, 4362 "SET CONSTRAINTS { ALL | %s [, ...] } { DEFERRED | IMMEDIATE }", 4363 _("name")); 4364 } 4365 4366 static void 4367 sql_help_SET_ROLE(PQExpBuffer buf) 4368 { 4369 appendPQExpBuffer(buf, 4370 "SET [ SESSION | LOCAL ] ROLE %s\n" 4371 "SET [ SESSION | LOCAL ] ROLE NONE\n" 4372 "RESET ROLE", 4373 _("role_name")); 4374 } 4375 4376 static void 4377 sql_help_SET_SESSION_AUTHORIZATION(PQExpBuffer buf) 4378 { 4379 appendPQExpBuffer(buf, 4380 "SET [ SESSION | LOCAL ] SESSION AUTHORIZATION %s\n" 4381 "SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT\n" 4382 "RESET SESSION AUTHORIZATION", 4383 _("user_name")); 4384 } 4385 4386 static void 4387 sql_help_SET_TRANSACTION(PQExpBuffer buf) 4388 { 4389 appendPQExpBuffer(buf, 4390 "SET TRANSACTION %s [, ...]\n" 4391 "SET TRANSACTION SNAPSHOT %s\n" 4392 "SET SESSION CHARACTERISTICS AS TRANSACTION %s [, ...]\n" 4393 "\n" 4394 "%s\n" 4395 "\n" 4396 " ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n" 4397 " READ WRITE | READ ONLY\n" 4398 " [ NOT ] DEFERRABLE", 4399 _("transaction_mode"), 4400 _("snapshot_id"), 4401 _("transaction_mode"), 4402 _("where transaction_mode is one of:")); 4403 } 4404 4405 static void 4406 sql_help_SHOW(PQExpBuffer buf) 4407 { 4408 appendPQExpBuffer(buf, 4409 "SHOW %s\n" 4410 "SHOW ALL", 4411 _("name")); 4412 } 4413 4414 static void 4415 sql_help_START_TRANSACTION(PQExpBuffer buf) 4416 { 4417 appendPQExpBuffer(buf, 4418 "START TRANSACTION [ %s [, ...] ]\n" 4419 "\n" 4420 "%s\n" 4421 "\n" 4422 " ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }\n" 4423 " READ WRITE | READ ONLY\n" 4424 " [ NOT ] DEFERRABLE", 4425 _("transaction_mode"), 4426 _("where transaction_mode is one of:")); 4427 } 4428 4429 static void 4430 sql_help_TABLE(PQExpBuffer buf) 4431 { 4432 appendPQExpBuffer(buf, 4433 "[ WITH [ RECURSIVE ] %s [, ...] ]\n" 4434 "SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n" 4435 " [ * | %s [ [ AS ] %s ] [, ...] ]\n" 4436 " [ FROM %s [, ...] ]\n" 4437 " [ WHERE %s ]\n" 4438 " [ GROUP BY %s [, ...] ]\n" 4439 " [ HAVING %s ]\n" 4440 " [ WINDOW %s AS ( %s ) [, ...] ]\n" 4441 " [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n" 4442 " [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n" 4443 " [ LIMIT { %s | ALL } ]\n" 4444 " [ OFFSET %s [ ROW | ROWS ] ]\n" 4445 " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]\n" 4446 " [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF %s [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ]\n" 4447 "\n" 4448 "%s\n" 4449 "\n" 4450 " [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4451 " [ TABLESAMPLE %s ( %s [, ...] ) [ REPEATABLE ( %s ) ] ]\n" 4452 " [ LATERAL ] ( %s ) [ AS ] %s [ ( %s [, ...] ) ]\n" 4453 " %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4454 " [ LATERAL ] %s ( [ %s [, ...] ] )\n" 4455 " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4456 " [ LATERAL ] %s ( [ %s [, ...] ] ) [ AS ] %s ( %s [, ...] )\n" 4457 " [ LATERAL ] %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n" 4458 " [ LATERAL ] ROWS FROM( %s ( [ %s [, ...] ] ) [ AS ( %s [, ...] ) ] [, ...] )\n" 4459 " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4460 " %s [ NATURAL ] %s %s [ ON %s | USING ( %s [, ...] ) ]\n" 4461 "\n" 4462 "%s\n" 4463 "\n" 4464 " ( )\n" 4465 " %s\n" 4466 " ( %s [, ...] )\n" 4467 " ROLLUP ( { %s | ( %s [, ...] ) } [, ...] )\n" 4468 " CUBE ( { %s | ( %s [, ...] ) } [, ...] )\n" 4469 " GROUPING SETS ( %s [, ...] )\n" 4470 "\n" 4471 "%s\n" 4472 "\n" 4473 " %s [ ( %s [, ...] ) ] AS ( %s | %s | %s | %s | %s )\n" 4474 "\n" 4475 "TABLE [ ONLY ] %s [ * ]", 4476 _("with_query"), 4477 _("expression"), 4478 _("expression"), 4479 _("output_name"), 4480 _("from_item"), 4481 _("condition"), 4482 _("grouping_element"), 4483 _("condition"), 4484 _("window_name"), 4485 _("window_definition"), 4486 _("select"), 4487 _("expression"), 4488 _("operator"), 4489 _("count"), 4490 _("start"), 4491 _("count"), 4492 _("table_name"), 4493 _("where from_item can be one of:"), 4494 _("table_name"), 4495 _("alias"), 4496 _("column_alias"), 4497 _("sampling_method"), 4498 _("argument"), 4499 _("seed"), 4500 _("select"), 4501 _("alias"), 4502 _("column_alias"), 4503 _("with_query_name"), 4504 _("alias"), 4505 _("column_alias"), 4506 _("function_name"), 4507 _("argument"), 4508 _("alias"), 4509 _("column_alias"), 4510 _("function_name"), 4511 _("argument"), 4512 _("alias"), 4513 _("column_definition"), 4514 _("function_name"), 4515 _("argument"), 4516 _("column_definition"), 4517 _("function_name"), 4518 _("argument"), 4519 _("column_definition"), 4520 _("alias"), 4521 _("column_alias"), 4522 _("from_item"), 4523 _("join_type"), 4524 _("from_item"), 4525 _("join_condition"), 4526 _("join_column"), 4527 _("and grouping_element can be one of:"), 4528 _("expression"), 4529 _("expression"), 4530 _("expression"), 4531 _("expression"), 4532 _("expression"), 4533 _("expression"), 4534 _("grouping_element"), 4535 _("and with_query is:"), 4536 _("with_query_name"), 4537 _("column_name"), 4538 _("select"), 4539 _("values"), 4540 _("insert"), 4541 _("update"), 4542 _("delete"), 4543 _("table_name")); 4544 } 4545 4546 static void 4547 sql_help_TRUNCATE(PQExpBuffer buf) 4548 { 4549 appendPQExpBuffer(buf, 4550 "TRUNCATE [ TABLE ] [ ONLY ] %s [ * ] [, ... ]\n" 4551 " [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]", 4552 _("name")); 4553 } 4554 4555 static void 4556 sql_help_UNLISTEN(PQExpBuffer buf) 4557 { 4558 appendPQExpBuffer(buf, 4559 "UNLISTEN { %s | * }", 4560 _("channel")); 4561 } 4562 4563 static void 4564 sql_help_UPDATE(PQExpBuffer buf) 4565 { 4566 appendPQExpBuffer(buf, 4567 "[ WITH [ RECURSIVE ] %s [, ...] ]\n" 4568 "UPDATE [ ONLY ] %s [ * ] [ [ AS ] %s ]\n" 4569 " SET { %s = { %s | DEFAULT } |\n" 4570 " ( %s [, ...] ) = [ ROW ] ( { %s | DEFAULT } [, ...] ) |\n" 4571 " ( %s [, ...] ) = ( %s )\n" 4572 " } [, ...]\n" 4573 " [ FROM %s [, ...] ]\n" 4574 " [ WHERE %s | WHERE CURRENT OF %s ]\n" 4575 " [ RETURNING * | %s [ [ AS ] %s ] [, ...] ]", 4576 _("with_query"), 4577 _("table_name"), 4578 _("alias"), 4579 _("column_name"), 4580 _("expression"), 4581 _("column_name"), 4582 _("expression"), 4583 _("column_name"), 4584 _("sub-SELECT"), 4585 _("from_item"), 4586 _("condition"), 4587 _("cursor_name"), 4588 _("output_expression"), 4589 _("output_name")); 4590 } 4591 4592 static void 4593 sql_help_VACUUM(PQExpBuffer buf) 4594 { 4595 appendPQExpBuffer(buf, 4596 "VACUUM [ ( %s [, ...] ) ] [ %s [, ...] ]\n" 4597 "VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ANALYZE ] [ %s [, ...] ]\n" 4598 "\n" 4599 "%s\n" 4600 "\n" 4601 " FULL\n" 4602 " FREEZE\n" 4603 " VERBOSE\n" 4604 " ANALYZE\n" 4605 " DISABLE_PAGE_SKIPPING\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 _("and table_and_columns is:"), 4615 _("table_name"), 4616 _("column_name")); 4617 } 4618 4619 static void 4620 sql_help_VALUES(PQExpBuffer buf) 4621 { 4622 appendPQExpBuffer(buf, 4623 "VALUES ( %s [, ...] ) [, ...]\n" 4624 " [ ORDER BY %s [ ASC | DESC | USING %s ] [, ...] ]\n" 4625 " [ LIMIT { %s | ALL } ]\n" 4626 " [ OFFSET %s [ ROW | ROWS ] ]\n" 4627 " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]", 4628 _("expression"), 4629 _("sort_expression"), 4630 _("operator"), 4631 _("count"), 4632 _("start"), 4633 _("count")); 4634 } 4635 4636 static void 4637 sql_help_WITH(PQExpBuffer buf) 4638 { 4639 appendPQExpBuffer(buf, 4640 "[ WITH [ RECURSIVE ] %s [, ...] ]\n" 4641 "SELECT [ ALL | DISTINCT [ ON ( %s [, ...] ) ] ]\n" 4642 " [ * | %s [ [ AS ] %s ] [, ...] ]\n" 4643 " [ FROM %s [, ...] ]\n" 4644 " [ WHERE %s ]\n" 4645 " [ GROUP BY %s [, ...] ]\n" 4646 " [ HAVING %s ]\n" 4647 " [ WINDOW %s AS ( %s ) [, ...] ]\n" 4648 " [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] %s ]\n" 4649 " [ ORDER BY %s [ ASC | DESC | USING %s ] [ NULLS { FIRST | LAST } ] [, ...] ]\n" 4650 " [ LIMIT { %s | ALL } ]\n" 4651 " [ OFFSET %s [ ROW | ROWS ] ]\n" 4652 " [ FETCH { FIRST | NEXT } [ %s ] { ROW | ROWS } ONLY ]\n" 4653 " [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF %s [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ]\n" 4654 "\n" 4655 "%s\n" 4656 "\n" 4657 " [ ONLY ] %s [ * ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4658 " [ TABLESAMPLE %s ( %s [, ...] ) [ REPEATABLE ( %s ) ] ]\n" 4659 " [ LATERAL ] ( %s ) [ AS ] %s [ ( %s [, ...] ) ]\n" 4660 " %s [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4661 " [ LATERAL ] %s ( [ %s [, ...] ] )\n" 4662 " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4663 " [ LATERAL ] %s ( [ %s [, ...] ] ) [ AS ] %s ( %s [, ...] )\n" 4664 " [ LATERAL ] %s ( [ %s [, ...] ] ) AS ( %s [, ...] )\n" 4665 " [ LATERAL ] ROWS FROM( %s ( [ %s [, ...] ] ) [ AS ( %s [, ...] ) ] [, ...] )\n" 4666 " [ WITH ORDINALITY ] [ [ AS ] %s [ ( %s [, ...] ) ] ]\n" 4667 " %s [ NATURAL ] %s %s [ ON %s | USING ( %s [, ...] ) ]\n" 4668 "\n" 4669 "%s\n" 4670 "\n" 4671 " ( )\n" 4672 " %s\n" 4673 " ( %s [, ...] )\n" 4674 " ROLLUP ( { %s | ( %s [, ...] ) } [, ...] )\n" 4675 " CUBE ( { %s | ( %s [, ...] ) } [, ...] )\n" 4676 " GROUPING SETS ( %s [, ...] )\n" 4677 "\n" 4678 "%s\n" 4679 "\n" 4680 " %s [ ( %s [, ...] ) ] AS ( %s | %s | %s | %s | %s )\n" 4681 "\n" 4682 "TABLE [ ONLY ] %s [ * ]", 4683 _("with_query"), 4684 _("expression"), 4685 _("expression"), 4686 _("output_name"), 4687 _("from_item"), 4688 _("condition"), 4689 _("grouping_element"), 4690 _("condition"), 4691 _("window_name"), 4692 _("window_definition"), 4693 _("select"), 4694 _("expression"), 4695 _("operator"), 4696 _("count"), 4697 _("start"), 4698 _("count"), 4699 _("table_name"), 4700 _("where from_item can be one of:"), 4701 _("table_name"), 4702 _("alias"), 4703 _("column_alias"), 4704 _("sampling_method"), 4705 _("argument"), 4706 _("seed"), 4707 _("select"), 4708 _("alias"), 4709 _("column_alias"), 4710 _("with_query_name"), 4711 _("alias"), 4712 _("column_alias"), 4713 _("function_name"), 4714 _("argument"), 4715 _("alias"), 4716 _("column_alias"), 4717 _("function_name"), 4718 _("argument"), 4719 _("alias"), 4720 _("column_definition"), 4721 _("function_name"), 4722 _("argument"), 4723 _("column_definition"), 4724 _("function_name"), 4725 _("argument"), 4726 _("column_definition"), 4727 _("alias"), 4728 _("column_alias"), 4729 _("from_item"), 4730 _("join_type"), 4731 _("from_item"), 4732 _("join_condition"), 4733 _("join_column"), 4734 _("and grouping_element can be one of:"), 4735 _("expression"), 4736 _("expression"), 4737 _("expression"), 4738 _("expression"), 4739 _("expression"), 4740 _("expression"), 4741 _("grouping_element"), 4742 _("and with_query is:"), 4743 _("with_query_name"), 4744 _("column_name"), 4745 _("select"), 4746 _("values"), 4747 _("insert"), 4748 _("update"), 4749 _("delete"), 4750 _("table_name")); 4751 } 4752 4753 4754 const struct _helpStruct QL_HELP[] = { 4755 { "ABORT", 4756 N_("abort the current transaction"), 4757 sql_help_ABORT, 4758 0 }, 4759 4760 { "ALTER AGGREGATE", 4761 N_("change the definition of an aggregate function"), 4762 sql_help_ALTER_AGGREGATE, 4763 9 }, 4764 4765 { "ALTER COLLATION", 4766 N_("change the definition of a collation"), 4767 sql_help_ALTER_COLLATION, 4768 4 }, 4769 4770 { "ALTER CONVERSION", 4771 N_("change the definition of a conversion"), 4772 sql_help_ALTER_CONVERSION, 4773 2 }, 4774 4775 { "ALTER DATABASE", 4776 N_("change a database"), 4777 sql_help_ALTER_DATABASE, 4778 17 }, 4779 4780 { "ALTER DEFAULT PRIVILEGES", 4781 N_("define default access privileges"), 4782 sql_help_ALTER_DEFAULT_PRIVILEGES, 4783 59 }, 4784 4785 { "ALTER DOMAIN", 4786 N_("change the definition of a domain"), 4787 sql_help_ALTER_DOMAIN, 4788 17 }, 4789 4790 { "ALTER EVENT TRIGGER", 4791 N_("change the definition of an event trigger"), 4792 sql_help_ALTER_EVENT_TRIGGER, 4793 3 }, 4794 4795 { "ALTER EXTENSION", 4796 N_("change the definition of an extension"), 4797 sql_help_ALTER_EXTENSION, 4798 40 }, 4799 4800 { "ALTER FOREIGN DATA WRAPPER", 4801 N_("change the definition of a foreign-data wrapper"), 4802 sql_help_ALTER_FOREIGN_DATA_WRAPPER, 4803 5 }, 4804 4805 { "ALTER FOREIGN TABLE", 4806 N_("change the definition of a foreign table"), 4807 sql_help_ALTER_FOREIGN_TABLE, 4808 34 }, 4809 4810 { "ALTER FUNCTION", 4811 N_("change the definition of a function"), 4812 sql_help_ALTER_FUNCTION, 4813 23 }, 4814 4815 { "ALTER GROUP", 4816 N_("change role name or membership"), 4817 sql_help_ALTER_GROUP, 4818 9 }, 4819 4820 { "ALTER INDEX", 4821 N_("change the definition of an index"), 4822 sql_help_ALTER_INDEX, 4823 9 }, 4824 4825 { "ALTER LANGUAGE", 4826 N_("change the definition of a procedural language"), 4827 sql_help_ALTER_LANGUAGE, 4828 1 }, 4829 4830 { "ALTER LARGE OBJECT", 4831 N_("change the definition of a large object"), 4832 sql_help_ALTER_LARGE_OBJECT, 4833 0 }, 4834 4835 { "ALTER MATERIALIZED VIEW", 4836 N_("change the definition of a materialized view"), 4837 sql_help_ALTER_MATERIALIZED_VIEW, 4838 23 }, 4839 4840 { "ALTER OPERATOR", 4841 N_("change the definition of an operator"), 4842 sql_help_ALTER_OPERATOR, 4843 9 }, 4844 4845 { "ALTER OPERATOR CLASS", 4846 N_("change the definition of an operator class"), 4847 sql_help_ALTER_OPERATOR_CLASS, 4848 7 }, 4849 4850 { "ALTER OPERATOR FAMILY", 4851 N_("change the definition of an operator family"), 4852 sql_help_ALTER_OPERATOR_FAMILY, 4853 19 }, 4854 4855 { "ALTER POLICY", 4856 N_("change the definition of a row level security policy"), 4857 sql_help_ALTER_POLICY, 4858 5 }, 4859 4860 { "ALTER PROCEDURE", 4861 N_("change the definition of a procedure"), 4862 sql_help_ALTER_PROCEDURE, 4863 17 }, 4864 4865 { "ALTER PUBLICATION", 4866 N_("change the definition of a publication"), 4867 sql_help_ALTER_PUBLICATION, 4868 5 }, 4869 4870 { "ALTER ROLE", 4871 N_("change a database role"), 4872 sql_help_ALTER_ROLE, 4873 26 }, 4874 4875 { "ALTER ROUTINE", 4876 N_("change the definition of a routine"), 4877 sql_help_ALTER_ROUTINE, 4878 22 }, 4879 4880 { "ALTER RULE", 4881 N_("change the definition of a rule"), 4882 sql_help_ALTER_RULE, 4883 0 }, 4884 4885 { "ALTER SCHEMA", 4886 N_("change the definition of a schema"), 4887 sql_help_ALTER_SCHEMA, 4888 1 }, 4889 4890 { "ALTER SEQUENCE", 4891 N_("change the definition of a sequence generator"), 4892 sql_help_ALTER_SEQUENCE, 4893 10 }, 4894 4895 { "ALTER SERVER", 4896 N_("change the definition of a foreign server"), 4897 sql_help_ALTER_SERVER, 4898 3 }, 4899 4900 { "ALTER STATISTICS", 4901 N_("change the definition of an extended statistics object"), 4902 sql_help_ALTER_STATISTICS, 4903 2 }, 4904 4905 { "ALTER SUBSCRIPTION", 4906 N_("change the definition of a subscription"), 4907 sql_help_ALTER_SUBSCRIPTION, 4908 7 }, 4909 4910 { "ALTER SYSTEM", 4911 N_("change a server configuration parameter"), 4912 sql_help_ALTER_SYSTEM, 4913 3 }, 4914 4915 { "ALTER TABLE", 4916 N_("change the definition of a table"), 4917 sql_help_ALTER_TABLE, 4918 110 }, 4919 4920 { "ALTER TABLESPACE", 4921 N_("change the definition of a tablespace"), 4922 sql_help_ALTER_TABLESPACE, 4923 3 }, 4924 4925 { "ALTER TEXT SEARCH CONFIGURATION", 4926 N_("change the definition of a text search configuration"), 4927 sql_help_ALTER_TEXT_SEARCH_CONFIGURATION, 4928 12 }, 4929 4930 { "ALTER TEXT SEARCH DICTIONARY", 4931 N_("change the definition of a text search dictionary"), 4932 sql_help_ALTER_TEXT_SEARCH_DICTIONARY, 4933 5 }, 4934 4935 { "ALTER TEXT SEARCH PARSER", 4936 N_("change the definition of a text search parser"), 4937 sql_help_ALTER_TEXT_SEARCH_PARSER, 4938 1 }, 4939 4940 { "ALTER TEXT SEARCH TEMPLATE", 4941 N_("change the definition of a text search template"), 4942 sql_help_ALTER_TEXT_SEARCH_TEMPLATE, 4943 1 }, 4944 4945 { "ALTER TRIGGER", 4946 N_("change the definition of a trigger"), 4947 sql_help_ALTER_TRIGGER, 4948 1 }, 4949 4950 { "ALTER TYPE", 4951 N_("change the definition of a type"), 4952 sql_help_ALTER_TYPE, 4953 12 }, 4954 4955 { "ALTER USER", 4956 N_("change a database role"), 4957 sql_help_ALTER_USER, 4958 26 }, 4959 4960 { "ALTER USER MAPPING", 4961 N_("change the definition of a user mapping"), 4962 sql_help_ALTER_USER_MAPPING, 4963 2 }, 4964 4965 { "ALTER VIEW", 4966 N_("change the definition of a view"), 4967 sql_help_ALTER_VIEW, 4968 6 }, 4969 4970 { "ANALYZE", 4971 N_("collect statistics about a database"), 4972 sql_help_ANALYZE, 4973 9 }, 4974 4975 { "BEGIN", 4976 N_("start a transaction block"), 4977 sql_help_BEGIN, 4978 6 }, 4979 4980 { "CALL", 4981 N_("invoke a procedure"), 4982 sql_help_CALL, 4983 0 }, 4984 4985 { "CHECKPOINT", 4986 N_("force a write-ahead log checkpoint"), 4987 sql_help_CHECKPOINT, 4988 0 }, 4989 4990 { "CLOSE", 4991 N_("close a cursor"), 4992 sql_help_CLOSE, 4993 0 }, 4994 4995 { "CLUSTER", 4996 N_("cluster a table according to an index"), 4997 sql_help_CLUSTER, 4998 1 }, 4999 5000 { "COMMENT", 5001 N_("define or change the comment of an object"), 5002 sql_help_COMMENT, 5003 51 }, 5004 5005 { "COMMIT", 5006 N_("commit the current transaction"), 5007 sql_help_COMMIT, 5008 0 }, 5009 5010 { "COMMIT PREPARED", 5011 N_("commit a transaction that was earlier prepared for two-phase commit"), 5012 sql_help_COMMIT_PREPARED, 5013 0 }, 5014 5015 { "COPY", 5016 N_("copy data between a file and a table"), 5017 sql_help_COPY, 5018 21 }, 5019 5020 { "CREATE ACCESS METHOD", 5021 N_("define a new access method"), 5022 sql_help_CREATE_ACCESS_METHOD, 5023 2 }, 5024 5025 { "CREATE AGGREGATE", 5026 N_("define a new aggregate function"), 5027 sql_help_CREATE_AGGREGATE, 5028 59 }, 5029 5030 { "CREATE CAST", 5031 N_("define a new cast"), 5032 sql_help_CREATE_CAST, 5033 10 }, 5034 5035 { "CREATE COLLATION", 5036 N_("define a new collation"), 5037 sql_help_CREATE_COLLATION, 5038 7 }, 5039 5040 { "CREATE CONVERSION", 5041 N_("define a new encoding conversion"), 5042 sql_help_CREATE_CONVERSION, 5043 1 }, 5044 5045 { "CREATE DATABASE", 5046 N_("create a new database"), 5047 sql_help_CREATE_DATABASE, 5048 9 }, 5049 5050 { "CREATE DOMAIN", 5051 N_("define a new domain"), 5052 sql_help_CREATE_DOMAIN, 5053 8 }, 5054 5055 { "CREATE EVENT TRIGGER", 5056 N_("define a new event trigger"), 5057 sql_help_CREATE_EVENT_TRIGGER, 5058 3 }, 5059 5060 { "CREATE EXTENSION", 5061 N_("install an extension"), 5062 sql_help_CREATE_EXTENSION, 5063 4 }, 5064 5065 { "CREATE FOREIGN DATA WRAPPER", 5066 N_("define a new foreign-data wrapper"), 5067 sql_help_CREATE_FOREIGN_DATA_WRAPPER, 5068 3 }, 5069 5070 { "CREATE FOREIGN TABLE", 5071 N_("define a new foreign table"), 5072 sql_help_CREATE_FOREIGN_TABLE, 5073 29 }, 5074 5075 { "CREATE FUNCTION", 5076 N_("define a new function"), 5077 sql_help_CREATE_FUNCTION, 5078 17 }, 5079 5080 { "CREATE GROUP", 5081 N_("define a new database role"), 5082 sql_help_CREATE_GROUP, 5083 19 }, 5084 5085 { "CREATE INDEX", 5086 N_("define a new index"), 5087 sql_help_CREATE_INDEX, 5088 5 }, 5089 5090 { "CREATE LANGUAGE", 5091 N_("define a new procedural language"), 5092 sql_help_CREATE_LANGUAGE, 5093 2 }, 5094 5095 { "CREATE MATERIALIZED VIEW", 5096 N_("define a new materialized view"), 5097 sql_help_CREATE_MATERIALIZED_VIEW, 5098 5 }, 5099 5100 { "CREATE OPERATOR", 5101 N_("define a new operator"), 5102 sql_help_CREATE_OPERATOR, 5103 6 }, 5104 5105 { "CREATE OPERATOR CLASS", 5106 N_("define a new operator class"), 5107 sql_help_CREATE_OPERATOR_CLASS, 5108 5 }, 5109 5110 { "CREATE OPERATOR FAMILY", 5111 N_("define a new operator family"), 5112 sql_help_CREATE_OPERATOR_FAMILY, 5113 0 }, 5114 5115 { "CREATE POLICY", 5116 N_("define a new row level security policy for a table"), 5117 sql_help_CREATE_POLICY, 5118 5 }, 5119 5120 { "CREATE PROCEDURE", 5121 N_("define a new procedure"), 5122 sql_help_CREATE_PROCEDURE, 5123 8 }, 5124 5125 { "CREATE PUBLICATION", 5126 N_("define a new publication"), 5127 sql_help_CREATE_PUBLICATION, 5128 3 }, 5129 5130 { "CREATE ROLE", 5131 N_("define a new database role"), 5132 sql_help_CREATE_ROLE, 5133 19 }, 5134 5135 { "CREATE RULE", 5136 N_("define a new rewrite rule"), 5137 sql_help_CREATE_RULE, 5138 6 }, 5139 5140 { "CREATE SCHEMA", 5141 N_("define a new schema"), 5142 sql_help_CREATE_SCHEMA, 5143 9 }, 5144 5145 { "CREATE SEQUENCE", 5146 N_("define a new sequence generator"), 5147 sql_help_CREATE_SEQUENCE, 5148 5 }, 5149 5150 { "CREATE SERVER", 5151 N_("define a new foreign server"), 5152 sql_help_CREATE_SERVER, 5153 2 }, 5154 5155 { "CREATE STATISTICS", 5156 N_("define extended statistics"), 5157 sql_help_CREATE_STATISTICS, 5158 3 }, 5159 5160 { "CREATE SUBSCRIPTION", 5161 N_("define a new subscription"), 5162 sql_help_CREATE_SUBSCRIPTION, 5163 3 }, 5164 5165 { "CREATE TABLE", 5166 N_("define a new table"), 5167 sql_help_CREATE_TABLE, 5168 78 }, 5169 5170 { "CREATE TABLE AS", 5171 N_("define a new table from the results of a query"), 5172 sql_help_CREATE_TABLE_AS, 5173 6 }, 5174 5175 { "CREATE TABLESPACE", 5176 N_("define a new tablespace"), 5177 sql_help_CREATE_TABLESPACE, 5178 3 }, 5179 5180 { "CREATE TEXT SEARCH CONFIGURATION", 5181 N_("define a new text search configuration"), 5182 sql_help_CREATE_TEXT_SEARCH_CONFIGURATION, 5183 3 }, 5184 5185 { "CREATE TEXT SEARCH DICTIONARY", 5186 N_("define a new text search dictionary"), 5187 sql_help_CREATE_TEXT_SEARCH_DICTIONARY, 5188 3 }, 5189 5190 { "CREATE TEXT SEARCH PARSER", 5191 N_("define a new text search parser"), 5192 sql_help_CREATE_TEXT_SEARCH_PARSER, 5193 6 }, 5194 5195 { "CREATE TEXT SEARCH TEMPLATE", 5196 N_("define a new text search template"), 5197 sql_help_CREATE_TEXT_SEARCH_TEMPLATE, 5198 3 }, 5199 5200 { "CREATE TRANSFORM", 5201 N_("define a new transform"), 5202 sql_help_CREATE_TRANSFORM, 5203 3 }, 5204 5205 { "CREATE TRIGGER", 5206 N_("define a new trigger"), 5207 sql_help_CREATE_TRIGGER, 5208 14 }, 5209 5210 { "CREATE TYPE", 5211 N_("define a new data type"), 5212 sql_help_CREATE_TYPE, 5213 35 }, 5214 5215 { "CREATE USER", 5216 N_("define a new database role"), 5217 sql_help_CREATE_USER, 5218 19 }, 5219 5220 { "CREATE USER MAPPING", 5221 N_("define a new mapping of a user to a foreign server"), 5222 sql_help_CREATE_USER_MAPPING, 5223 2 }, 5224 5225 { "CREATE VIEW", 5226 N_("define a new view"), 5227 sql_help_CREATE_VIEW, 5228 3 }, 5229 5230 { "DEALLOCATE", 5231 N_("deallocate a prepared statement"), 5232 sql_help_DEALLOCATE, 5233 0 }, 5234 5235 { "DECLARE", 5236 N_("define a cursor"), 5237 sql_help_DECLARE, 5238 1 }, 5239 5240 { "DELETE", 5241 N_("delete rows of a table"), 5242 sql_help_DELETE, 5243 4 }, 5244 5245 { "DISCARD", 5246 N_("discard session state"), 5247 sql_help_DISCARD, 5248 0 }, 5249 5250 { "DO", 5251 N_("execute an anonymous code block"), 5252 sql_help_DO, 5253 0 }, 5254 5255 { "DROP ACCESS METHOD", 5256 N_("remove an access method"), 5257 sql_help_DROP_ACCESS_METHOD, 5258 0 }, 5259 5260 { "DROP AGGREGATE", 5261 N_("remove an aggregate function"), 5262 sql_help_DROP_AGGREGATE, 5263 6 }, 5264 5265 { "DROP CAST", 5266 N_("remove a cast"), 5267 sql_help_DROP_CAST, 5268 0 }, 5269 5270 { "DROP COLLATION", 5271 N_("remove a collation"), 5272 sql_help_DROP_COLLATION, 5273 0 }, 5274 5275 { "DROP CONVERSION", 5276 N_("remove a conversion"), 5277 sql_help_DROP_CONVERSION, 5278 0 }, 5279 5280 { "DROP DATABASE", 5281 N_("remove a database"), 5282 sql_help_DROP_DATABASE, 5283 0 }, 5284 5285 { "DROP DOMAIN", 5286 N_("remove a domain"), 5287 sql_help_DROP_DOMAIN, 5288 0 }, 5289 5290 { "DROP EVENT TRIGGER", 5291 N_("remove an event trigger"), 5292 sql_help_DROP_EVENT_TRIGGER, 5293 0 }, 5294 5295 { "DROP EXTENSION", 5296 N_("remove an extension"), 5297 sql_help_DROP_EXTENSION, 5298 0 }, 5299 5300 { "DROP FOREIGN DATA WRAPPER", 5301 N_("remove a foreign-data wrapper"), 5302 sql_help_DROP_FOREIGN_DATA_WRAPPER, 5303 0 }, 5304 5305 { "DROP FOREIGN TABLE", 5306 N_("remove a foreign table"), 5307 sql_help_DROP_FOREIGN_TABLE, 5308 0 }, 5309 5310 { "DROP FUNCTION", 5311 N_("remove a function"), 5312 sql_help_DROP_FUNCTION, 5313 1 }, 5314 5315 { "DROP GROUP", 5316 N_("remove a database role"), 5317 sql_help_DROP_GROUP, 5318 0 }, 5319 5320 { "DROP INDEX", 5321 N_("remove an index"), 5322 sql_help_DROP_INDEX, 5323 0 }, 5324 5325 { "DROP LANGUAGE", 5326 N_("remove a procedural language"), 5327 sql_help_DROP_LANGUAGE, 5328 0 }, 5329 5330 { "DROP MATERIALIZED VIEW", 5331 N_("remove a materialized view"), 5332 sql_help_DROP_MATERIALIZED_VIEW, 5333 0 }, 5334 5335 { "DROP OPERATOR", 5336 N_("remove an operator"), 5337 sql_help_DROP_OPERATOR, 5338 0 }, 5339 5340 { "DROP OPERATOR CLASS", 5341 N_("remove an operator class"), 5342 sql_help_DROP_OPERATOR_CLASS, 5343 0 }, 5344 5345 { "DROP OPERATOR FAMILY", 5346 N_("remove an operator family"), 5347 sql_help_DROP_OPERATOR_FAMILY, 5348 0 }, 5349 5350 { "DROP OWNED", 5351 N_("remove database objects owned by a database role"), 5352 sql_help_DROP_OWNED, 5353 0 }, 5354 5355 { "DROP POLICY", 5356 N_("remove a row level security policy from a table"), 5357 sql_help_DROP_POLICY, 5358 0 }, 5359 5360 { "DROP PROCEDURE", 5361 N_("remove a procedure"), 5362 sql_help_DROP_PROCEDURE, 5363 1 }, 5364 5365 { "DROP PUBLICATION", 5366 N_("remove a publication"), 5367 sql_help_DROP_PUBLICATION, 5368 0 }, 5369 5370 { "DROP ROLE", 5371 N_("remove a database role"), 5372 sql_help_DROP_ROLE, 5373 0 }, 5374 5375 { "DROP ROUTINE", 5376 N_("remove a routine"), 5377 sql_help_DROP_ROUTINE, 5378 1 }, 5379 5380 { "DROP RULE", 5381 N_("remove a rewrite rule"), 5382 sql_help_DROP_RULE, 5383 0 }, 5384 5385 { "DROP SCHEMA", 5386 N_("remove a schema"), 5387 sql_help_DROP_SCHEMA, 5388 0 }, 5389 5390 { "DROP SEQUENCE", 5391 N_("remove a sequence"), 5392 sql_help_DROP_SEQUENCE, 5393 0 }, 5394 5395 { "DROP SERVER", 5396 N_("remove a foreign server descriptor"), 5397 sql_help_DROP_SERVER, 5398 0 }, 5399 5400 { "DROP STATISTICS", 5401 N_("remove extended statistics"), 5402 sql_help_DROP_STATISTICS, 5403 0 }, 5404 5405 { "DROP SUBSCRIPTION", 5406 N_("remove a subscription"), 5407 sql_help_DROP_SUBSCRIPTION, 5408 0 }, 5409 5410 { "DROP TABLE", 5411 N_("remove a table"), 5412 sql_help_DROP_TABLE, 5413 0 }, 5414 5415 { "DROP TABLESPACE", 5416 N_("remove a tablespace"), 5417 sql_help_DROP_TABLESPACE, 5418 0 }, 5419 5420 { "DROP TEXT SEARCH CONFIGURATION", 5421 N_("remove a text search configuration"), 5422 sql_help_DROP_TEXT_SEARCH_CONFIGURATION, 5423 0 }, 5424 5425 { "DROP TEXT SEARCH DICTIONARY", 5426 N_("remove a text search dictionary"), 5427 sql_help_DROP_TEXT_SEARCH_DICTIONARY, 5428 0 }, 5429 5430 { "DROP TEXT SEARCH PARSER", 5431 N_("remove a text search parser"), 5432 sql_help_DROP_TEXT_SEARCH_PARSER, 5433 0 }, 5434 5435 { "DROP TEXT SEARCH TEMPLATE", 5436 N_("remove a text search template"), 5437 sql_help_DROP_TEXT_SEARCH_TEMPLATE, 5438 0 }, 5439 5440 { "DROP TRANSFORM", 5441 N_("remove a transform"), 5442 sql_help_DROP_TRANSFORM, 5443 0 }, 5444 5445 { "DROP TRIGGER", 5446 N_("remove a trigger"), 5447 sql_help_DROP_TRIGGER, 5448 0 }, 5449 5450 { "DROP TYPE", 5451 N_("remove a data type"), 5452 sql_help_DROP_TYPE, 5453 0 }, 5454 5455 { "DROP USER", 5456 N_("remove a database role"), 5457 sql_help_DROP_USER, 5458 0 }, 5459 5460 { "DROP USER MAPPING", 5461 N_("remove a user mapping for a foreign server"), 5462 sql_help_DROP_USER_MAPPING, 5463 0 }, 5464 5465 { "DROP VIEW", 5466 N_("remove a view"), 5467 sql_help_DROP_VIEW, 5468 0 }, 5469 5470 { "END", 5471 N_("commit the current transaction"), 5472 sql_help_END, 5473 0 }, 5474 5475 { "EXECUTE", 5476 N_("execute a prepared statement"), 5477 sql_help_EXECUTE, 5478 0 }, 5479 5480 { "EXPLAIN", 5481 N_("show the execution plan of a statement"), 5482 sql_help_EXPLAIN, 5483 11 }, 5484 5485 { "FETCH", 5486 N_("retrieve rows from a query using a cursor"), 5487 sql_help_FETCH, 5488 17 }, 5489 5490 { "GRANT", 5491 N_("define access privileges"), 5492 sql_help_GRANT, 5493 67 }, 5494 5495 { "IMPORT FOREIGN SCHEMA", 5496 N_("import table definitions from a foreign server"), 5497 sql_help_IMPORT_FOREIGN_SCHEMA, 5498 4 }, 5499 5500 { "INSERT", 5501 N_("create new rows in a table"), 5502 sql_help_INSERT, 5503 19 }, 5504 5505 { "LISTEN", 5506 N_("listen for a notification"), 5507 sql_help_LISTEN, 5508 0 }, 5509 5510 { "LOAD", 5511 N_("load a shared library file"), 5512 sql_help_LOAD, 5513 0 }, 5514 5515 { "LOCK", 5516 N_("lock a table"), 5517 sql_help_LOCK, 5518 5 }, 5519 5520 { "MOVE", 5521 N_("position a cursor"), 5522 sql_help_MOVE, 5523 17 }, 5524 5525 { "NOTIFY", 5526 N_("generate a notification"), 5527 sql_help_NOTIFY, 5528 0 }, 5529 5530 { "PREPARE", 5531 N_("prepare a statement for execution"), 5532 sql_help_PREPARE, 5533 0 }, 5534 5535 { "PREPARE TRANSACTION", 5536 N_("prepare the current transaction for two-phase commit"), 5537 sql_help_PREPARE_TRANSACTION, 5538 0 }, 5539 5540 { "REASSIGN OWNED", 5541 N_("change the ownership of database objects owned by a database role"), 5542 sql_help_REASSIGN_OWNED, 5543 1 }, 5544 5545 { "REFRESH MATERIALIZED VIEW", 5546 N_("replace the contents of a materialized view"), 5547 sql_help_REFRESH_MATERIALIZED_VIEW, 5548 1 }, 5549 5550 { "REINDEX", 5551 N_("rebuild indexes"), 5552 sql_help_REINDEX, 5553 0 }, 5554 5555 { "RELEASE SAVEPOINT", 5556 N_("destroy a previously defined savepoint"), 5557 sql_help_RELEASE_SAVEPOINT, 5558 0 }, 5559 5560 { "RESET", 5561 N_("restore the value of a run-time parameter to the default value"), 5562 sql_help_RESET, 5563 1 }, 5564 5565 { "REVOKE", 5566 N_("remove access privileges"), 5567 sql_help_REVOKE, 5568 94 }, 5569 5570 { "ROLLBACK", 5571 N_("abort the current transaction"), 5572 sql_help_ROLLBACK, 5573 0 }, 5574 5575 { "ROLLBACK PREPARED", 5576 N_("cancel a transaction that was earlier prepared for two-phase commit"), 5577 sql_help_ROLLBACK_PREPARED, 5578 0 }, 5579 5580 { "ROLLBACK TO SAVEPOINT", 5581 N_("roll back to a savepoint"), 5582 sql_help_ROLLBACK_TO_SAVEPOINT, 5583 0 }, 5584 5585 { "SAVEPOINT", 5586 N_("define a new savepoint within the current transaction"), 5587 sql_help_SAVEPOINT, 5588 0 }, 5589 5590 { "SECURITY LABEL", 5591 N_("define or change a security label applied to an object"), 5592 sql_help_SECURITY_LABEL, 5593 29 }, 5594 5595 { "SELECT", 5596 N_("retrieve rows from a table or view"), 5597 sql_help_SELECT, 5598 42 }, 5599 5600 { "SELECT INTO", 5601 N_("define a new table from the results of a query"), 5602 sql_help_SELECT_INTO, 5603 14 }, 5604 5605 { "SET", 5606 N_("change a run-time parameter"), 5607 sql_help_SET, 5608 1 }, 5609 5610 { "SET CONSTRAINTS", 5611 N_("set constraint check timing for the current transaction"), 5612 sql_help_SET_CONSTRAINTS, 5613 0 }, 5614 5615 { "SET ROLE", 5616 N_("set the current user identifier of the current session"), 5617 sql_help_SET_ROLE, 5618 2 }, 5619 5620 { "SET SESSION AUTHORIZATION", 5621 N_("set the session user identifier and the current user identifier of the current session"), 5622 sql_help_SET_SESSION_AUTHORIZATION, 5623 2 }, 5624 5625 { "SET TRANSACTION", 5626 N_("set the characteristics of the current transaction"), 5627 sql_help_SET_TRANSACTION, 5628 8 }, 5629 5630 { "SHOW", 5631 N_("show the value of a run-time parameter"), 5632 sql_help_SHOW, 5633 1 }, 5634 5635 { "START TRANSACTION", 5636 N_("start a transaction block"), 5637 sql_help_START_TRANSACTION, 5638 6 }, 5639 5640 { "TABLE", 5641 N_("retrieve rows from a table or view"), 5642 sql_help_TABLE, 5643 42 }, 5644 5645 { "TRUNCATE", 5646 N_("empty a table or set of tables"), 5647 sql_help_TRUNCATE, 5648 1 }, 5649 5650 { "UNLISTEN", 5651 N_("stop listening for a notification"), 5652 sql_help_UNLISTEN, 5653 0 }, 5654 5655 { "UPDATE", 5656 N_("update rows of a table"), 5657 sql_help_UPDATE, 5658 8 }, 5659 5660 { "VACUUM", 5661 N_("garbage-collect and optionally analyze a database"), 5662 sql_help_VACUUM, 5663 13 }, 5664 5665 { "VALUES", 5666 N_("compute a set of rows"), 5667 sql_help_VALUES, 5668 4 }, 5669 5670 { "WITH", 5671 N_("retrieve rows from a table or view"), 5672 sql_help_WITH, 5673 42 }, 5674 5675 5676 { NULL, NULL, NULL } /* End of list marker */ 5677 }; 5678