diff options
| author | Robert Haas <rhaas@postgresql.org> | 2022-05-26 12:54:57 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2022-05-26 12:54:57 -0400 |
| commit | a5fc06bf31352fc57cb34ccbf2ca18214118ab9b (patch) | |
| tree | c39b35ef39de37756969359b8db528e39fd3b3eb | |
| parent | 6f7eec1193f8ddafb6d7ff495d3ce2eb01202a86 (diff) | |
| download | postgresql-a5fc06bf31352fc57cb34ccbf2ca18214118ab9b.tar.gz postgresql-a5fc06bf31352fc57cb34ccbf2ca18214118ab9b.zip | |
In CREATE FOREIGN TABLE syntax synopsis, fix partitioning stuff.
Foreign tables can be partitioned, but previous documentation commits
left the syntax synopsis both incomplete and incorrect.
Justin Pryzby and Amit Langote
Discussion: http://postgr.es/m/20220521130922.GX19626@telsasoft.com
| -rw-r--r-- | doc/src/sgml/ref/create_foreign_table.sgml | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index eabeaf36f51..c9b167edf92 100644 --- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -35,7 +35,8 @@ CREATE FOREIGN TABLE [ IF NOT EXISTS ] <replaceable class="parameter">table_name { <replaceable class="parameter">column_name</replaceable> [ WITH OPTIONS ] [ <replaceable class="parameter">column_constraint</replaceable> [ ... ] ] | <replaceable>table_constraint</replaceable> } [, ... ] -) ] <replaceable class="parameter">partition_bound_spec</replaceable> +) ] +{ FOR VALUES <replaceable class="parameter">partition_bound_spec</replaceable> | DEFAULT } SERVER <replaceable class="parameter">server_name</replaceable> [ OPTIONS ( <replaceable class="parameter">option</replaceable> '<replaceable class="parameter">value</replaceable>' [, ... ] ) ] @@ -52,6 +53,13 @@ CREATE FOREIGN TABLE [ IF NOT EXISTS ] <replaceable class="parameter">table_name [ CONSTRAINT <replaceable class="parameter">constraint_name</replaceable> ] CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ] + +<phrase>and <replaceable class="parameter">partition_bound_spec</replaceable> is:</phrase> + +IN ( <replaceable class="parameter">partition_bound_expr</replaceable> [, ...] ) | +FROM ( { <replaceable class="parameter">partition_bound_expr</replaceable> | MINVALUE | MAXVALUE } [, ...] ) + TO ( { <replaceable class="parameter">partition_bound_expr</replaceable> | MINVALUE | MAXVALUE } [, ...] ) | +WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REMAINDER <replaceable class="parameter">numeric_literal</replaceable> ) </synopsis> </refsynopsisdiv> |