\di won't display indexes
От | Chip Castle |
---|---|
Тема | \di won't display indexes |
Дата | |
Msg-id | 387213CA.FFD56532@chipcastle.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] \di won't display indexes
|
Список | 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@chipcastle.com http://www.chipcastle.com 504.412.8002 Perl CGI MySQL E-commerce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
В списке pgsql-general по дате отправления: