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@xxxxxxxxxxxxxx [mailto:pgsql-php-owner@xxxxxxxxxxxxxx] On Behalf Of Chris Boget Sent: Tuesday, March 02, 2004 1:29 AM To: Majolee InfoTech; Wim Paulussen Cc: pgsql-php@xxxxxxxxxxxxxx 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
