\di won't display indexes

From: Chip Castle <chip(at)chipcastle(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: \di won't display indexes
Date: 2000-01-04 15:37:46
Message-ID: 387213CA.FFD56532@chipcastle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

The following psql transcript shows that \di and \ds commands do not
show output, but that specifying a table explicitly (av_parts for
example) does show the layout of my table as well as the indexes I
expected to see. To make matters more confusing, my queries are
extremely slow, so it appears that the indexes actually DO NOT EXIST.

My Questions:
How can I get the \di and \ds options to work?
How do I verify that the indexes do exist?

BTW: We're running PostGres 6.5.3

=========================================================

parts=> \di
Couldn't find any indices!
parts=> \ds
Couldn't find any sequences!
parts=> \d
Couldn't find any tables, sequences or indices!
parts=> \d av_parts

Table = av_parts
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| itemid | int4 not null default nextval (
| 4 |
| vendorid | int4
| 4 |
| partnumber | varchar()
| 25 |
| alternatepartnumber | varchar()
| 25 |
| nsn | varchar()
| 15 |
| description | varchar()
| 50 |
| condition | varchar()
| 10 |
| quantity | int4
| 4 |
| rawpartnumber | varchar()
| 25 |
| rawalternatenumber | varchar()
| 25 |
| rawnsnnumber | varchar()
| 15 |
| date | int4
| 4 |
| cagecode | varchar()
| 10 |
+----------------------------------+----------------------------------+-------+
Indices: av_parts_alternatepartnumber_in
av_parts_itemid_key
av_parts_nsn_index
av_parts_partnumber_index
av_parts_rawalternatenumber_ind
av_parts_rawnsnnumber_index
av_parts_rawpartnumber_index
av_parts_vendorid_index
parts=>

==============================================================================
Thanks!
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chip Castle Chip Castle Dot Com, Inc.
chip(at)chipcastle(dot)com http://www.chipcastle.com
504.412.8002 Perl CGI MySQL E-commerce
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ulf Mehlig 2000-01-04 16:13:38 dificulties with views and aggregates
Previous Message The Hermit Hacker 2000-01-04 13:20:09 Re: [GENERAL] Future of PostgreSQL