From: | Pedro Doria Meunier <pdoria(at)netmadeira(dot)com> |
---|---|
To: | Justin <justin(at)emproshunts(dot)com> |
Cc: | Postgresql Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Internationalization |
Date: | 2009-04-11 01:47:53 |
Message-ID: | 49DFF6C9.9090906@netmadeira.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Justin,
First of all thank you for your input. :)
Actually what I have is a fully internationalized site by means of
getttext.
*Some* of the content comes from the PGSQL database where 2 tables
relation with others (namely for sensor data description).
These tables have the simplest arrangement: id, description :]
I wondered if there was some sort of pgsql extension providing a text
replacement mechanism of sorts in order to achieve something like
gettext ...
I guess I'll have to resort to what I've previously thought of ...
Regards,
Pedro Doria Meunier.
Justin wrote:
> 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 )
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFJ3/bA2FH5GXCfxAsRAlZ0AKCnP9LDOJlOrDSF+Ci4G3CpdX8AlgCdFJqQ
5CrOIuWvgVBXCmyZwhjR8r8=
=DmmH
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-04-11 04:03:41 | Re: ERROR: array subscript out of range |
Previous Message | Tom Lane | 2009-04-10 20:18:44 | Re: ERROR: array subscript out of range |