mikeem@gmx.net a écrit :
> Hello, how to create an index with an operator class in pgAdmin3 1.8.2 ?
> On the command line i do:
> CREATE INDEX idx1 ON mytab (mycolumn text_pattern_ops);
>
> But in pgAdmin i cant find any place to add the "text_pattern_ops".
> Anyone help?
>
In pgAdmin's "Create Index" interface, you can't specify an operator
class. This dialog lacks a lot of the capacities of the CREATE INDEX
statement : functional indexes, partial indexes, operator class,
ASC/DESC, NULLS FIRST/LAST.
--
Guillaume. http://www.postgresqlfr.org http://dalibo.com