Postgres Pro
Downloads
Home   >   mailing lists

Thread: list all indices

list all indices

From
Ben-Nes Michael
Date:
Hi All

How do I list all the indicies that I have in a db ?

Re: list all indices

From
DaVinci
Date:
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