Received: from send1e.yahoomail.com (send1e.yahoomail.com [205.180.60.64]) by hub.org (8.9.2/8.9.1) with SMTP id AAA69173 for ; Sat, 20 Feb 1999 00:20:41 -0500 (EST) (envelope-from molivier@yahoo.com) Message-ID: <19990220051943.20371.rocketmail@send1e.yahoomail.com> Received: from [207.181.255.222] by send1e; Fri, 19 Feb 1999 21:19:43 PST Date: Fri, 19 Feb 1999 21:19:43 -0800 (PST) From: Michael Olivier Subject: Re: [SQL] SQL-Query 2 get primary key To: "jose' soares" Cc: "pgsql-sql@postgreSQL.org" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii This doesn't work for me in 6.3.2-10 on RH Linux. Is this a newer feature? ---jose' soares 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