Postgresql Woes

Ng Pheng Siong ngps at madcap.dyndns.org
Thu Jun 14 12:18:11 EDT 2001


According to Sreekant <skodela at hotmail.com>:
> con=pg.connect("mydb")
> tbl=pg.query("show all tables from mydb") or something similar ??

"select tablename from pg_tables where tableowner = current_user"

Other system tables of interest are pg_user(s) and pg_database(s).


-- 
Ng Pheng Siong <ngps at post1.com> * http://www.post1.com/home/ngps

Quidquid latine dictum sit, altum viditur.



More information about the Python-list mailing list