Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA51215 for ; Mon, 22 Feb 1999 10:44:16 -0500 (EST) (envelope-from sferac@bo.nettuno.it) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id QAA14475; Mon, 22 Feb 1999 16:44:07 +0100 (MET) Received: from rosso.sferacarta.com (bo.nettuno.it) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 10EwFF-0006Iq-00; Mon, 22 Feb 1999 14:22:01 +0000 Message-ID: <36D15A55.634FFC5A@bo.nettuno.it> Date: Mon, 22 Feb 1999 14:23:33 +0100 From: "jose' soares" Organization: Sferacarta Software X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: Michael Olivier CC: "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] SQL-Query 2 get primary key References: <19990220051943.20371.rocketmail@send1e.yahoomail.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Michael Olivier ha scritto: > 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) > This is my version: hygea=> select version(); version ------------------------------------------------------------- PostgreSQL 6.4.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2. (1 row) -- - Jose' -