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
|
# SQL definition for indexes
# 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 ] %if {unique} %then [UNIQUE ] %end [INDEX ]
%if {concurrent} %then
[ CONCURRENTLY ]
%end
{name} [ ON ] {table}
%if {index-type} %then
$br [USING ] {index-type}
%end
$br ( {elements} $br )
%if {expression} %then
$br ({expression}) $sp
%end
%if ({pgsql-ver} >=f "15.0") %and {nulls-not-distinct} %then
$br [NULLS NOT DISTINCT]
%end
%if ({pgsql-ver} >=f "11.0") %and {include-cols} %then
$br [INCLUDE ] ({include-cols})
%end
%if {stg-params} %then
$br [WITH (]
%if {factor} %then
[FILLFACTOR = ] {factor}
%end
%if {fast-update} %then
%if {factor} %then [, ] %end
[FASTUPDATE = ON]
%end
%if {buffering} %then
%if {factor} %then [, ] %end
[BUFFERING = ON]
%end
[)]
%end
%if {tablespace} %then
$br [TABLESPACE ] {tablespace}
%end
%if {predicate} %then
$br [WHERE (] {predicate} [)]
%end
;
@include "footer"
|
