1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
|
# SQL definition for foreign tables
# CAUTION: Do not modify this file unless you know what you are doing.
# Code generation can be broken if incorrect changes are made.
@include "ddlend"
@include "objlabel"
@include "prependedsql"
[CREATE FOREIGN TABLE ] {name}
%if {partitioned-table} %then
$br [PARTITION OF ] {partitioned-table} $sp
%end
%if %not {partitioned-table} %then
[ (] $br
%if %not {gen-alter-cmds} %then
%if {columns} %then
{columns}
%end
%if {inh-columns} %then
{inh-columns}
%end
%if {constraints} %then
{constraints}
%end
%end
%if %not {constraints} %then $br %end
)
%else
%if %not {gen-alter-cmds} %and {partitioned-table} %and {constraints} %then
[ (] $br {constraints} $br [)]
%end
%end
%if {partitioned-table} %then
$br [FOR VALUES ] {partition-bound-expr}
%end
%if {ancestor-table} %then $br [ INHERITS(] {ancestor-table} [)] %end
$br [SERVER ] {server}
%if {options} %then $br [OPTIONS (] {options} [)] %end
;
{ddl-end}
%if {gen-alter-cmds} %then
%if {columns} %then $br {columns} %end
%if {constraints} %then $br {constraints} %end
%end
%if {comment} %then {comment} %end
%if {cols-comment} %then {cols-comment} %end
%if {owner} %then {owner} %end
%if {appended-sql} %then
{appended-sql}
{ddl-end}
%end
%if {initial-data} %then
$br {initial-data} $br
%end
$br
|