Re: copy/duplicate database schemas

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Jamie Kahgee <jamie(dot)kahgee(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: copy/duplicate database schemas
Date: 2010-06-24 09:16:35
Message-ID: 877hlou6x8.fsf@hi-media-techno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
> On Wed, Jun 23, 2010 at 3:21 PM, Jamie Kahgee <jamie(dot)kahgee(at)gmail(dot)com> wrote:
>> I have an application in a schema and now i need to create other schemas b/c
>> the app needs to support different languages,  is there an easy way to copy
>> an entire schema to a new one (tables, contents, trigges, functions, etc..)?
>> right now i just have
>>
>> schema
>>
>> what I want is
>>
>> schema
>> schema_ar
>> schema_ru
>> etc...
>
> sure:
> 1) pg_dump -n your_schema -s
> 2) sed the resulting schema s/old_schema/new_schema
> if you are lucky, you will have few if any improper replacements, if
> not, tweak sed till it's right
> 3) cat it back into psql

I think you could also :
1) pg_dump -n your_schema -s > your_schema.sql
2) alter schema your_schema rename to your_schema_ar;
3) psql -f your_schema.sql
4) goto 2, pick another name

Regards,
--
dim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message kaifeng.zhu 2010-06-24 09:18:06 Re: Bad query performance with more conditions?
Previous Message Alban Hertroys 2010-06-24 09:14:15 Re: Bad query performance with more conditions?