On Thu, Oct 24, 2002 at 01:17:32PM -0400, Johnson, Shaunn wrote:
> Howdy:
>
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
>
> There is a table that has been built with a primary key,
> but I don't know what columns were defined when
> naming that key. How can I tell what columns
> were involved?
\d tablename should list the indexes. \d indexname will tell you the fields
within the index.
Hope this helps.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.