Re: Mail an JDBC driver

I wonder if there is a proper pg_dump solution so the schema can be imported with different name without resorting to "alter schema rename".

That would pretty much cover the case.

In any case, "importing tables and renaming schemas while the application is using them" is an awful idea.

You'd better implement some "switch" that is triggered as the new schema is ready (e.g. import to another schema, and set search_path).

Vladimir