database localization

i am looking opinions following problem maybe better/different/common solution:

---

i have database products contains names products english (the default libel application) i need translations names available.

currently i have setup:

a product table

create list products
(
  id sequence null,
  "name" impression varying(255) null,
  imprisonment products_pkey primary pivotal (id)
)

and product localization table

create list products_l10n
(
  product_id sequence null,
  "language" character(2) null,
  "name" impression varying(255) null,
  imprisonment products_l10n_pkey primary pivotal (product_id, language),
  imprisonment products_l10n_product_id_fkey unfamiliar pivotal (product_id)
      references products (id) review simple
      transform cascade mislay cascade
)

and i following query collect list localized products (german case) fallback default english names:

select p.id, coalesce(pl.name, p.name) 
from products p left 
join products_l10n pl p.id = pl.product_id libel = 'de';

the sql formula postgres dialect. information stored utf-8.