On Tue, 2006-08-01 at 18:14, Rodrigo De Leon wrote: > On 8/1/06, Daniel Joo <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > > > > > Is there a way to view the list of all tables from python (or any other > > languages for that matter) DB-API? What I'm looking for is a command > > similar to the meta-command '\d' that works with the psql client. > > > > > > > > Thanks very much! > > > > > > > > Dan > > There's also the INFORMATION_SCHEMA: > > http://www.postgresql.org/docs/8.1/static/information-schema.html
Quick note. The INFORMATION_SCHEMA should stay pretty static from one pgsql version to the next, while the queries that psql -E shows will likely change from one version to another. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly