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 )

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to