Обсуждение: operator classes in pgAdmin

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?

Ciao!

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