CREATE OR REPLACE VIEW localization.localized_resources_view
AS
SELECT ((replace(resources.path, '.resx'::text, ''::text) || '.'::text) || localized_resources.culture_code) || '.resx'::text AS resource,
resources.key,
localized_resources.culture_code,
localized_resources.value
FROM localization.resources
JOIN localization.localized_resources ON localized_resources.key = resources.key
ORDER BY resources.path;