Skip site navigation (1) Skip section navigation (2)

Re: Getting list of Indexes & contrains

From: "Alban Medici (NetCentrex)" <amedici(at)fr(dot)netcentrex(dot)net>
To: "'PostgreSQL - PHP'" <pgsql-php(at)postgresql(dot)org>
Subject: Re: Getting list of Indexes & contrains
Date: 2005-09-13 07:58:41
Message-ID: 20050913075851.639C8D70DB@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-php
 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(at)postgresql(dot)org [mailto:pgsql-php-owner(at)postgresql(dot)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


In response to

pgsql-php by date

Next:From: John DeSoiDate: 2005-09-13 11:53:55
Subject: Re: commit and rollback
Previous:From: Jason MinionDate: 2005-09-12 17:13:13
Subject: Re: [SPAM] - pg_dump - Bayesian Filter detected spam

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group