| From: | Michael Olivier <molivier(at)yahoo(dot)com> |
|---|---|
| To: | "jose' soares" <sferac(at)bo(dot)nettuno(dot)it> |
| Cc: | "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] SQL-Query 2 get primary key |
| Date: | 1999-02-20 05:19:43 |
| Message-ID: | 19990220051943.20371.rocketmail@send1e.yahoomail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
This doesn't work for me in 6.3.2-10 on RH Linux. Is this a newer
feature?
---jose' soares <sferac(at)bo(dot)nettuno(dot)it> wrote:
>
> You may query pg_indexes as in:
>
> select * from pg_indexes where tablename = 'test';
>
> tablename|indexname|indexdef
>
---------+---------+-----------------------------------------------------------------------
>
> test |test_pkey|CREATE UNIQUE INDEX "test_pkey" ON "test" USING
btree
> ("id" "int4_ops")
> (1 row)
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-02-20 06:06:48 | Re: [SQL] questions on interpreting the output of explain |
| Previous Message | Michael Olivier | 1999-02-20 05:07:48 | questions on interpreting the output of explain |