Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9DCBE9FBEA7 for ; Fri, 8 Jun 2007 16:14:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 24397-05 for ; Fri, 8 Jun 2007 16:14:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx1.wp.pl (mx1.wp.pl [212.77.101.5]) by postgresql.org (Postfix) with ESMTP id D337F9FB696 for ; Fri, 8 Jun 2007 16:14:16 -0300 (ADT) Received: (wp-smtpd smtp.wp.pl 5745 invoked from network); 8 Jun 2007 21:14:14 +0200 Received: from aayj39.neoplus.adsl.tpnet.pl (HELO [127.0.0.1]) (ipluta@[83.6.121.39]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with SMTP for ; 8 Jun 2007 21:14:14 +0200 Message-ID: <4669AA77.1040503@wp.pl> Date: Fri, 08 Jun 2007 21:13:59 +0200 From: Ireneusz Pluta User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: Andreas Kretschmer CC: pgsql-sql@postgresql.org Subject: Re: show index from [table] References: <112402456@web.de> <20070608154753.GA23791@KanotixBox> In-Reply-To: <20070608154753.GA23791@KanotixBox> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A. X-WP-SPAM: NO 0000000 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/77 X-Sequence-Number: 28567 Andreas Kretschmer napisał(a): > > Yes, right. > > >> but actually i would need the information from within a (postgres) >> sql-query. is there a possibility to get information about the indices >> which have been created on a table? >> > > Yes, of corse. Please start psql with the -E - option. Now you can see > the underlying sql-statement for commands like \di. > > > ... or even better: select * from pg_indexes where tablename = 'your_table';