Re: [GENERAL] copy/duplicate database schemas

2010-06-24 Thread Karsten Hilbert
> > This adds significant complexity to your code, especially since (AFAIK) > > there aren't really any good i18n tools for Pg's SQL, PL/PgSQL, etc. > > But there is - whether good or not: Go to > http://gitorious.org/gnumed and browse the tree under > gnumed/server/SQL/. Look at the i18n schema

Re: [GENERAL] copy/duplicate database schemas

2010-06-24 Thread Dimitri Fontaine
Merlin Moncure writes: > On Wed, Jun 23, 2010 at 3:21 PM, Jamie Kahgee 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,

Re: [GENERAL] copy/duplicate database schemas

2010-06-24 Thread Karsten Hilbert
On Thu, Jun 24, 2010 at 11:29:48AM +0800, Craig Ringer wrote: > You might want to investigate internationalization options instead, > where you can process your "master" sources to produce a list of > strings, and have translators translate those strings. Your code loads > the string lists, and de

Re: [GENERAL] copy/duplicate database schemas

2010-06-23 Thread Craig Ringer
On 24/06/10 03:21, Jamie Kahgee 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..)? Others have replied w

Re: [GENERAL] copy/duplicate database schemas

2010-06-23 Thread Merlin Moncure
On Wed, Jun 23, 2010 at 3:21 PM, Jamie Kahgee 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 n