Re: [GENERAL] How to make a copy of schema

2006-11-24 Thread Andrus
>> 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

Re: [GENERAL] How to make a copy of schema

2006-10-15 Thread A. Kretschmer
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