Re: unknown index

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: unknown index
Date: 2002-01-07 22:01:31
Message-ID: Pine.LNX.4.30.0201071701030.8360-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jodi Kanter writes:

> I am working with a database that was not created by our team. There are
> some indexes set up on a table and I need to understand what type they are
> and how they are functioning.
> How can I look at this in Postgres?

\d tablename or \d indexname in psql.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gyozo Papp 2002-01-08 01:37:56 REQUEST: database security issues in PHP manual
Previous Message Peter Eisentraut 2002-01-07 22:00:38 Re: granting all to user