Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: operator classes in pgAdmin
- From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
- To: mikeem(at)gmx(dot)net
- Cc: pgadmin-support(at)postgresql(dot)org
- Subject: Re: operator classes in pgAdmin
- Date: Tue, 25 Mar 2008 13:13:22 +0100
mikeem(at)gmx(dot)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
- References:
- operator classes in pgAdmin
- From: mikeem
- operator classes in pgAdmin
- Prev by Date: operator classes in pgAdmin
- Next by Date: bug when creating/dropping function with a user defiend domain (adds size)
- Previous by thread: operator classes in pgAdmin
- Next by thread: bug when creating/dropping function with a user defiend domain (adds size)
- Indexes: