Postgres Pro
Downloads
Home   >   mailing lists

copy/duplicate database schemas - Mailing list pgsql-general

From Jamie Kahgee
Subject copy/duplicate database schemas
Date
Msg-id AANLkTillxq9Ee1DAzWKwh1a9TFPQXKSB6knPb6QC3EWz@mail.gmail.com
Whole thread Raw
Responses Re: copy/duplicate database schemas  (Merlin Moncure <mmoncure@gmail.com>)
Re: copy/duplicate database schemas  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view
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...

Thanks,
Jamie K.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: No PL/PHP ? Any reason?
Next
From: Merlin Moncure
Date:
Subject: Re: Problem Using RowType Declaration with Table Domains