Postgresql Woes

Michael Linnemann m.linnemann at addcom.de
Wed Jun 13 16:45:44 EDT 2001


Am 13 Jun 2001 12:31:21 -0700 schrieb Sreekant:

>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
>database!

Call psql with the -E parameter and it will tell you all its secrets :-)

BTW, I found this in the FAQ. Seems they are well worth reading.

Regards
Michael



More information about the Python-list mailing list