X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4259FD78C3 for ; Tue, 13 Sep 2005 04:59:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79341-09 for ; Tue, 13 Sep 2005 07:59:02 +0000 (GMT) Received: from mailer.unicite.fr.netcentrex.net (mailer.fr.netcentrex.net [62.161.167.249]) by svr1.postgresql.org (Postfix) with ESMTP id 639C8D70DB for ; Tue, 13 Sep 2005 04:58:51 -0300 (ADT) Received: from akira ([192.168.101.228]) by mailer.unicite.fr.netcentrex.net with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id SY2H2N0X; Tue, 13 Sep 2005 09:58:50 +0200 From: "Alban Medici (NetCentrex)" To: "'PostgreSQL - PHP'" Subject: Re: Getting list of Indexes & contrains Date: Tue, 13 Sep 2005 09:58:41 +0200 Organization: NetCentrex MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: <200509082328.40506.andreil1@starlett.lv> Thread-Index: AcW4IHyrMUIBPZ/yQcuPu8cvcP0fuQAGATPA Message-Id: <20050913075851.639C8D70DB@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.704 required=5 tests=[MSGID_FROM_MTA_ID=1.704] X-Spam-Level: * X-Archive-Number: 200509/10 X-Sequence-Number: 3250 If you only want list and not exact description : Use '\di' for indexes=20 And for sample description of a table '\d ' But for real description you have to cross pg_* tables. Regards=20 Alban=20 -----Original Message----- From: pgsql-php-owner@postgresql.org = [mailto:pgsql-php-owner@postgresql.org] On Behalf Of Andrei Verovski (aka MacGuru) Sent: jeudi 8 septembre 2005 22:29 To: PostgreSQL - PHP Subject: [PHP] Getting list of Indexes & contrains Hi, I am using PostgreSQL 8 and adodb. adodb has a built-in function which = scans and retrieves db structure as assotiative array. Unfortunately, it do = not list indexes and constrains. What would be a SQL statement to retrieve = them? Thanks in advance for any suggestion(s). ************************************************ *** =A0 with best regards *** =A0 Andrei Verovski (aka MacGuru) *** =A0 Mac, Linux, DTP, Programming Web Site *** *** =A0 http://snow.prohosting.com/guru4mac/ ************************************************ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend