Postgres Pro
Downloads
Home   >   mailing lists

Re: viewing the description of tables from python DB-API - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: viewing the description of tables from python DB-API
Date
Msg-id 20060801230039.GA20401@alvh.no-ip.org
Whole thread Raw
In response to viewing the description of tables from python DB-API  ("Daniel Joo" <djoo@vistagen-inc.com>)
List pgsql-sql
Tree view 
Daniel Joo wrote:

> 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.  

Try \d under psql -E sometime.  It'll give you the query it uses.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-sql by date:

Previous
From: "Daniel Joo"
Date:
Subject: viewing the description of tables from python DB-API
Next
From: "Rodrigo De Leon"
Date:
Subject: Re: viewing the description of tables from python DB-API