| 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: | Whole Thread | Raw Message | 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...
| 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? |