From 0fab33916789eba84a1646a33da70dcb261fbd74 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Thu, 26 May 2022 12:55:04 -0400 Subject: [PATCH] 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 --- doc/src/sgml/ref/create_foreign_table.sgml | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index e0a30ed6c26..d8a2bebb57f 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 ] table_name { column_name [ WITH OPTIONS ] [ column_constraint [ ... ] ] | table_constraint } [, ... ] -) ] partition_bound_spec +) ] +{ FOR VALUES partition_bound_spec | DEFAULT } SERVER server_name [ OPTIONS ( option 'value' [, ... ] ) ] @@ -51,6 +52,13 @@ CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name [ CONSTRAINT constraint_name ] CHECK ( expression ) [ NO INHERIT ] + +and partition_bound_spec is: + +IN ( { numeric_literal | string_literal | TRUE | FALSE | NULL } [, ...] ) | +FROM ( { numeric_literal | string_literal | TRUE | FALSE | MINVALUE | MAXVALUE } [, ...] ) + TO ( { numeric_literal | string_literal | TRUE | FALSE | MINVALUE | MAXVALUE } [, ...] ) | +WITH ( MODULUS numeric_literal, REMAINDER numeric_literal ) -- 2.39.5