Re: copy/duplicate database schemas

On Wed, Jun 23, 2010 at 3:21 PM, Jamie Kahgee <jamie.kahgee@gmail.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

merlin