Index Information - Mailing list pgsql-general

From Karam Chand
Subject Index Information
Date
Msg-id 20040226141857.28375.qmail@web60802.mail.yahoo.com
Whole thread Raw
In response to Re: postgreSQL licenseing  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Index Information  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: help using arrays in a function
Next
From: "Keith Bottner"
Date:
Subject: PL/pgSQL debugger