I have a five company Postgres 8.1 database.
Each company data is stored in a different schema named Company1, Company2,
..., Company5
There is also public schema which contains common data.
Now customer wants to add sixth company to database.
In need to add some routine to my application which
am Sun, dem 15.10.2006, um 19:10:53 +0300 mailte Andrus folgendes:
> I have a five company Postgres 8.1 database.
>
> Each company data is stored in a different schema named Company1, Company2,
> ..., Company5
> There is also public schema which contains common data.
>
> Now customer wants to a
>> In need to add some routine to my application which can create schema
>> copy ?
>
> You can make a pg_dump with option -n Company5, replace in the dump
> Company5 with Company6 and restore this.
I dont have suffix like _schema in my company schema names.
So "Company5" string may be used in pla