[EMAIL PROTECTED] 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

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Reply via email to