Postgres Pro
Downloads
Home   >   mailing lists

Re: Mail an JDBC driver - Mailing list pgsql-jdbc

From Vladimir Sitnikov
Subject Re: Mail an JDBC driver
Date
Msg-id CAB=Je-H_eLvpKkWjRG_nNtuc1_MjsaPQuh-sNrnmQzp0aKjXNQ@mail.gmail.com
Whole thread Raw
In response to Re: Mail an JDBC driver  (KUNES Michael <Michael.KUNES@frequentis.com>)
List pgsql-jdbc
Tree view

we change the schema name by extending the file that we create via pg_dump.

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

pgsql-jdbc by date:

Previous
From: KUNES Michael
Date:
Subject: Re: Mail an JDBC driver
Next
From: Vladimir Sitnikov
Date:
Subject: v2 protocol: is it still used?