Postgresql Woes

Sreekant skodela at
Wed Jun 13 15:31:21 EDT 2001

Hi folks

I have made a few web sites with postgresql but never needed to know
the list of tables available in the database through pg module.

I guess you can use psql and \dt command or os.popen('psql ... , to
get the list of tables. But is there a decent way of finding out
through python and postgresql [pg] module , all the tables in a

tbl=pg.query("show all tables from mydb") or something similar ??

Thanks a lot for your time

More information about the Python-list mailing list