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

Re: get list of databases and tables in Postgres

From: "Chris Smith" <chris(at)interspire(dot)com>
To: "'Chris Boget'" <chris(at)wild(dot)net>,"'Majolee InfoTech'" <info(at)majolee(dot)info>,"'Wim Paulussen'" <wim(at)chen(dot)be>
Cc: <pgsql-php(at)postgresql(dot)org>
Subject: Re: get list of databases and tables in Postgres
Date: 2004-03-01 22:30:49
Message-ID: 000701c3ffdc$dfb169e0$0d00a8c0@chris (view raw or flat)
Thread:
Lists: pgsql-php
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



In response to

Responses

pgsql-php by date

Next:From: scott.marloweDate: 2004-03-01 22:31:17
Subject: Re: get list of databases and tables in Postgres
Previous:From: Chris SmithDate: 2004-03-01 22:29:16
Subject: Re: SQLSTATE in PHP?

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