Postgres Pro
Downloads
Home   >   mailing lists

Re: list all indices - Mailing list pgsql-general

From DaVinci
Subject Re: list all indices
Date
Msg-id 20010719130403.A18648@fangorn.net
Whole thread Raw
In response to list all indices  (Ben-Nes Michael <miki@canaan.co.il>)
List pgsql-general
Tree view 
On Thu, Jul 19, 2001 at 01:23:16PM +0300, Ben-Nes Michael wrote:
> How do I list all the indicies that I have in a db ?

 from psql:

     \di

 and from shell prompt:

     psql database -c '\di'

 Greets.

                         David

pgsql-general by date:

Previous
From: Mark kirkwood
Date:
Subject: Re: How Postgresql Compares For Query And Load Operations
Next
From: Mark kirkwood
Date:
Subject: Re: How Postgresql Compares For Query And Load Operations