Skip to content

Commit 74e2829

Browse files
committed
doc: document the CREATE INDEX "USING" clause
Somehow this was in the syntax but had no description. Reported-by: robertcorrington@gmail.com Discussion: https://postgr.es/m/164228771825.31954.2719791849363756957@wrigleys.postgresql.org Backpatch-through: 10
1 parent 7d66cce commit 74e2829

File tree

1 file changed

+12
-0
lines changed

1 file changed

+12
-0
lines changed

doc/src/sgml/ref/create_index.sgml

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -149,6 +149,18 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
149149
</listitem>
150150
</varlistentry>
151151

152+
<varlistentry>
153+
<term><literal>USING</literal></term>
154+
<listitem>
155+
<para>
156+
The optional <literal>USING</literal> clause specifies an index
157+
type as described in <xref linkend="indexes-types"/>. If not
158+
specified, a default index type will be used based on the
159+
data types of the columns.
160+
</para>
161+
</listitem>
162+
</varlistentry>
163+
152164
<varlistentry>
153165
<term><literal>INCLUDE</literal></term>
154166
<listitem>

0 commit comments

Comments
 (0)