[SQL] Moving tables accross schemas in PostgreSQL 7.3

Hi folks, what would be the best way of moving my tables out of public schema to a schema "foo"? I have few a 100s of tables to move? Regds Mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit

[SQL] How to take advantage of PREPARED QUERIES of PGSQL 7.3 in mod_perl enviornment?

Hi Like many others we also use postgresql as the backend DataBase server for our web applications. I am curious how can i take advantage of this new feature. Typically each mod_perl (perl enabled apache) httpd process creates a persistant connection with the DB server (this acheived by conn