can't see operator classes

From: "Erbil KARAMAN" <erbilkaraman(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: can't see operator classes
Date: 2006-11-30 13:19:22
Message-ID: 96d9feae0611300519hcd4c84ax6d005edb9eb37f4f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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...

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-11-30 13:30:50 Re: can't see operator classes
Previous Message Joris Dobbelsteen 2006-11-30 10:02:55 Re: Can tables have calculated columns?