I am porting some code from Perl to Python; in the Perl original I use either DBI::do or a rickety home-built module to pass multiple SQL statements (as one single block of SQL) to the Pg server. The typical usage is something like this: $dbh->do( <<EOSQL ); ALTER TABLE $xn OWNER TO xdev; GRANT ALL ON TABLE $xn TO xdev;
REVOKE ALL ON TABLE $xn FROM PUBLIC; GRANT SELECT ON TABLE $xn TO PUBLIC; EOSQL How can I do this sort of thing from Python? I've looked into the docs for psycopg2, but I can't find anything like the do command used above. Did I overlook it? If not, what can I use instead? I'm not wedded to psycopg2, in fact its lack of documentation worries me; if there's a better alternative that I can use from Python please let me know. TIA! kynn
