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

Re: get list of databases and tables in Postgres

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Chris Smith <chris(at)interspire(dot)com>
Cc: "'Chris Boget'" <chris(at)wild(dot)net>,"'Majolee InfoTech'" <info(at)majolee(dot)info>,"'Wim Paulussen'" <wim(at)chen(dot)be>, <pgsql-php(at)postgresql(dot)org>
Subject: Re: get list of databases and tables in Postgres
Date: 2004-03-01 22:31:17
Message-ID: Pine.LNX.4.33.0403011530580.1074-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-php
If you're running 7.4, look into the iformation_schema for such things.  
That likely won't change.

On Tue, 2 Mar 2004, Chris Smith wrote:

> He wants to do it through PHP - so I don't think this will work.
> 
> You could always
> 
> psql -E -l
> 
> BUT - that query *could* change depending on the version of postgresql
> you're running.
> 
> Chris.
> 
> -----Original Message-----
> From: pgsql-php-owner(at)postgresql(dot)org
> [mailto:pgsql-php-owner(at)postgresql(dot)org] On Behalf Of Chris Boget
> Sent: Tuesday, March 02, 2004 1:29 AM
> To: Majolee InfoTech; Wim Paulussen
> Cc: pgsql-php(at)postgresql(dot)org
> Subject: Re: [PHP] get list of databases and tables in Postgres
> 
> 
> > select datname from pg_database;
> 
> Or simply:
> 
> \d
> 
> unless I'm missing something...
> 
> Chris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> 


In response to

pgsql-php by date

Next:From: Seader, CameronDate: 2004-03-01 23:50:15
Subject: pg_fetch_row Problem
Previous:From: Chris SmithDate: 2004-03-01 22:30:49
Subject: Re: get list of databases and tables in Postgres

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