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 can create schema copy ? How to make a copy of schema Company5 so that schema called Company6 is created ? Is there any sample code available ? Andrus
