Re: operator cl***** in pgAdmin

mikeem@[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-sup****t mailing list (pgadmin-sup****t@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-sup****t