From: Alban Medici (NetCentrex) <amedici@fr.netcentrex.net>
To: 'PostgreSQL - PHP' <pgsql-php@postgresql.org>
Subject: Re: Getting list of Indexes & contrains
Date: Tue, 13 Sep 2005 09:58:41 +0200
Message-ID: <20050913075851.639C8D70DB@svr1.postgresql.org> (raw)
In-Reply-To: <200509082328.40506.andreil1@starlett.lv>
If you only want list and not exact description :
Use '\di' for indexes
And for sample description of a table '\d <yourtable>'
But for real description you have to cross pg_* tables.
Regards
Alban
-----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).
************************************************
*** with best regards
*** Andrei Verovski (aka MacGuru)
*** Mac, Linux, DTP, Programming Web Site
***
*** http://snow.prohosting.com/guru4mac/
************************************************
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: amedici@fr.netcentrex.net
Subject: Re: Getting list of Indexes & contrains
In-Reply-To: <20050913075851.639C8D70DB@svr1.postgresql.org>
References: <200509082328.40506.andreil1@starlett.lv> <20050913075851.639C8D70DB@svr1.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox