On Tue, 1 Aug 2006 15:30:48 -0700 "Daniel Joo" <[EMAIL PROTECTED]> 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. The cursor object has a "description" data member. Look at the DB-API spec: http://www.python.org/dev/peps/pep-0249/ under "Cursor Objects". Python 2.3.3 (#1, Jan 3 2004, 07:17:11) [GCC 3.3.2] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import pgdb >>> db=pgdb.connect(database='pigrestore', host='ivy') >>> cur=db.cursor() >>> cur.execute('select * from machine') >>> print cur.description [('machine_name', 'text', -1, -1, None, None, None), ('machine_id', 'int2', -1, 2, None, None, None), ('area', 'text', -1, -1, None, None, None), ('text', 'text', -1, -1, None, None, None)] >>> -- "Are the gods not just?" "Oh no, child. What would become of us if they were?" (C.S. Lewis) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
