How to make a copy of schema - Mailing list pgsql-general

From Andrus
Subject How to make a copy of schema
Date
Msg-id egtml3$m2n$1@news.hub.org
Whole thread Raw
Responses Re: How to make a copy of schema
List pgsql-general
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



pgsql-general by date:

Previous
From: Chris Mair
Date:
Subject: Re: Triggers
Next
From: "Merlin Moncure"
Date:
Subject: Re: more anti-postgresql FUD