Index Information

Hello

How do I display the field(s) used to create an index,
as in
"CREATE INDEX <index name> ON <table name> (<field1>
[, <field2>...])" ?

I tried with psql with -E option and if I execute the
query independently then it is showing the index names
and a index definition like

CREATE INDEX ON..... from which I believe psql is
getting column names?

On what what criteria it is fetching the column
information...the only thing i can believe is that the
column names are within ()...Am I true?

Karam


__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools