Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

can't see operator classes



i use pgAdminIII (Win32 binary) version 1.4.3 to test my relational DB
running on Postgresql v8.1.3.

For some indexes i use operator classes such as varchar_pattern_ops
for LIKE selections. but i cant see the operator class definition in
pgAdmin table "properties". They are seen in dumps that i have created
with pg_dump.

ex:

dump file segment created by pg_dump for index__xxx_yyy
--------------------------------------------
CREATE UNIQUE INDEX index__xxx_yyy ON xxx USING btree (yyy varchar_pattern_ops);

pgAdmin properties section for index__xxx__yyy
----------------------------------------
CREATE UNIQUE INDEX index__xxx__yyy
 ON xxx
 USING btree
 (yyy);

is there a way to see such operator classes?

advTHANKSance

erbiL...



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group