| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: primary key |
| Date: | 2002-10-24 20:51:31 |
| Message-ID: | 20021024205131.GA8777@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Travis Bauer | 2002-10-24 20:57:14 | Database backend not shutting down |
| Previous Message | Hadley Willan | 2002-10-24 20:39:12 | Re: Hot Backup |