How to send multiple SQL commands from Python?

[Kynn Jones <kynnjo@xxxxxxxxx>]

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