I need to generate maps with labels in multiple languages. Currently I have already imported the osm data into postgis and pusblish it with geoserver, but apparently after querying the feature (using the geoserver preview layer feature), I only see one column with name 'name'.
How can I import and then publish labels in multiple languages in the same layer. The result should be that for a given feature the label in the concatenation of the OSM tags values 'name' and 'name:en' (if the later exists, some features are missing this).
Update: For further reference. After searching more I found that the way you filter what gets imported into the db is using the 'style' file (defaults to default.style). In that file one need to add the second of the following lines to also import the name of a feature in English:
node,way name text linear node,way name:en text linear
This tells osm2pgsql to create another column named 'name:en' of type text and store in it the values of the tags with key 'name:en'.