[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