diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-14 19:16:24 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-14 19:16:24 +0000 |
| commit | 2a0f262beff32ba86bcb58f3273214e5d0517c09 (patch) | |
| tree | 24c0ad10dab36bbd5c22743d3c88c4e0ccd5bc65 /src/bin/psql/sql_help.c | |
| parent | Releasing progress-linux version 16.2-2~progress7.99u1. (diff) | |
| download | postgresql-16-2a0f262beff32ba86bcb58f3273214e5d0517c09.tar.xz postgresql-16-2a0f262beff32ba86bcb58f3273214e5d0517c09.zip | |
Merging upstream version 16.3.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'src/bin/psql/sql_help.c')
| -rw-r--r-- | src/bin/psql/sql_help.c | 30 |
1 files changed, 21 insertions, 9 deletions
diff --git a/src/bin/psql/sql_help.c b/src/bin/psql/sql_help.c index 5baae9c..bf2fc48 100644 --- a/src/bin/psql/sql_help.c +++ b/src/bin/psql/sql_help.c @@ -162,7 +162,8 @@ sql_help_ALTER_DEFAULT_PRIVILEGES(PQExpBuffer buf) " ON TYPES\n" " TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n" "\n" - "GRANT { USAGE | CREATE | ALL [ PRIVILEGES ] }\n" + "GRANT { { USAGE | CREATE }\n" + " [, ...] | ALL [ PRIVILEGES ] }\n" " ON SCHEMAS\n" " TO { [ GROUP ] %s | PUBLIC } [, ...] [ WITH GRANT OPTION ]\n" "\n" @@ -193,7 +194,8 @@ sql_help_ALTER_DEFAULT_PRIVILEGES(PQExpBuffer buf) " [ CASCADE | RESTRICT ]\n" "\n" "REVOKE [ GRANT OPTION FOR ]\n" - " { USAGE | CREATE | ALL [ PRIVILEGES ] }\n" + " { { USAGE | CREATE }\n" + " [, ...] | ALL [ PRIVILEGES ] }\n" " ON SCHEMAS\n" " FROM { [ GROUP ] %s | PUBLIC } [, ...]\n" " [ CASCADE | RESTRICT ]", @@ -1299,7 +1301,7 @@ sql_help_ALTER_TABLE(PQExpBuffer buf) "\n" "%s\n" "\n" - "{ %s | ( %s ) } [ %s ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]\n" + "{ %s | ( %s ) } [ COLLATE %s ] [ %s [ ( %s = %s [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]\n" "\n" "%s\n" "\n" @@ -1425,7 +1427,10 @@ sql_help_ALTER_TABLE(PQExpBuffer buf) _("exclude_element in an EXCLUDE constraint is:"), _("column_name"), _("expression"), + _("collation"), _("opclass"), + _("opclass_parameter"), + _("value"), _("referential_action in a FOREIGN KEY/REFERENCES constraint is:"), _("column_name"), _("column_name")); @@ -2187,7 +2192,7 @@ sql_help_CREATE_DATABASE(PQExpBuffer buf) " [ WITH ] [ OWNER [=] %s ]\n" " [ TEMPLATE [=] %s ]\n" " [ ENCODING [=] %s ]\n" - " [ STRATEGY [=] %s ] ]\n" + " [ STRATEGY [=] %s ]\n" " [ LOCALE [=] %s ]\n" " [ LC_COLLATE [=] %s ]\n" " [ LC_CTYPE [=] %s ]\n" @@ -2885,7 +2890,7 @@ sql_help_CREATE_TABLE(PQExpBuffer buf) "\n" "%s\n" "\n" - "{ %s | ( %s ) } [ %s ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]\n" + "{ %s | ( %s ) } [ COLLATE %s ] [ %s [ ( %s = %s [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]\n" "\n" "%s\n" "\n" @@ -2979,7 +2984,10 @@ sql_help_CREATE_TABLE(PQExpBuffer buf) _("exclude_element in an EXCLUDE constraint is:"), _("column_name"), _("expression"), + _("collation"), _("opclass"), + _("opclass_parameter"), + _("value"), _("referential_action in a FOREIGN KEY/REFERENCES constraint is:"), _("column_name"), _("column_name")); @@ -4068,7 +4076,9 @@ sql_help_MERGE(PQExpBuffer buf) "%s\n" "\n" "UPDATE SET { %s = { %s | DEFAULT } |\n" - " ( %s [, ...] ) = ( { %s | DEFAULT } [, ...] ) } [, ...]\n" + " ( %s [, ...] ) = [ ROW ] ( { %s | DEFAULT } [, ...] ) |\n" + " ( %s [, ...] ) = ( %s )\n" + " } [, ...]\n" "\n" "%s\n" "\n" @@ -4097,6 +4107,8 @@ sql_help_MERGE(PQExpBuffer buf) _("expression"), _("column_name"), _("expression"), + _("column_name"), + _("sub-SELECT"), _("and merge_delete is:")); } @@ -4437,7 +4449,7 @@ sql_help_SECURITY_LABEL(PQExpBuffer buf) " DATABASE %s |\n" " DOMAIN %s |\n" " EVENT TRIGGER %s |\n" - " FOREIGN TABLE %s\n" + " FOREIGN TABLE %s |\n" " FUNCTION %s [ ( [ [ %s ] [ %s ] %s [, ...] ] ) ] |\n" " LARGE OBJECT %s |\n" " MATERIALIZED VIEW %s |\n" @@ -5178,7 +5190,7 @@ const struct _helpStruct QL_HELP[] = { N_("define default access privileges"), "sql-alterdefaultprivileges", sql_help_ALTER_DEFAULT_PRIVILEGES, - 59}, + 61}, {"ALTER DOMAIN", N_("change the definition of a domain"), @@ -6066,7 +6078,7 @@ const struct _helpStruct QL_HELP[] = { N_("conditionally insert, update, or delete rows of a table"), "sql-merge", sql_help_MERGE, - 27}, + 29}, {"MOVE", N_("position a cursor"), |