"Bart van Houdt" <[EMAIL PROTECTED]> writes: > I am working on a query to retrieve all indexed columns and came up with > the following query: > ... > Tis query works for single column indexes, but with multiple column > indexes I get incorrect results... I'm having a hard time figuring out > how to join pg_attribute.indkey in this, could anyone help me out on > this one?
Look at the information_schema views. You might find that one of them already solves your problem ... and even if not, they will provide examples of how to deconstruct the catalog information. share/information_schema.sql in an installed PG file set is the most convenient thing to study. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql