Re: Internationalization

From: Justin <justin(at)emproshunts(dot)com>
To: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
Cc: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Internationalization
Date: 2009-04-10 19:30:27
Message-ID: 49DF9E53.1030607@emproshunts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pedro Doria Meunier wrote:
> Hi all,
>
> I'm wondering how to internationalize contents of a table, short of
> having a column for each language string ...
> Anyone with some experience to share? :)
>
> Regards,
> Pedro Doria Meunier
>
How about parent child table layout. The child table has one record for
translation for each document. something like this

Create table ParentDoc (
docid serial,
description text )

Create table ChildDoc (
docid integer,
doc_text text,
short_description text,
language text )

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-04-10 20:18:44 Re: ERROR: array subscript out of range
Previous Message Bruce Momjian 2009-04-10 19:23:56 Re: Multiple character encodings within a single database/table?