I have connected to PostgreSQL and imported the layer to QGIS.

The column names are written using English letters.

Can the names of columns be automatically translated to another language?

  • Why do you want to change column names? – Nicolas Boisteault Aug 27 '14 at 12:28
  • For people who will work with them in QGIS. It'll be easier to understand what is this. – bable Aug 27 '14 at 12:52
  • 1
    what locale is is the postgres DB in? – Mapperz Aug 27 '14 at 13:46
  • what locale is is the postgres DB in? – Mapperz Sorry, but can you rewrite your question, I don't understand It, english is not my native language. – bable Aug 28 '14 at 12:02

Open the "Layer properties" and go to the "Fields" tab. You will see a column "Alias". Whatever you enter there will be used throughout the user interface.

  • Thanks, It's almost that I need. But If there are a lot of tables, It is not easy to rename each column. I want it to make automatically. Is there any way to do it? – bable Aug 28 '14 at 12:06
  • 1
    You could write a script that updates the project file or a python plugin to automate the process. You could also open a feature request on the issue page and ask for support of translation files for projects. – Matthias Kuhn Aug 29 '14 at 9:13

I haven't tested this but perhaps this might help:

Settings > Options > Locale

enter image description here


The only other method I can think of is:

Add Vector Layer > Encoding

And select whichever one you think is suitable. Hope this helps!

enter image description here

  • Thank's, but it didn't help. – bable Aug 27 '14 at 13:12
  • @bable, I've updated my post in the hope it might help. – Joseph Aug 27 '14 at 13:56

I'm not sure if I understand you correctly but if You're trying to translate english names of columns into your local language automaticaly I think you can't do this in QGIS.

The only resolution that I mind is creating a view on database and show this view in QGIS

Create view translated_table as 
    id as translated_id,
    field2 as translated_field2,
  from table

I'm only not sure if you can edit data via views, but if you only want to show it in QGIS this could be resolution.

  • If you have postgreSQL 9.3 you should create a materialized view. This way, your users will be able to do all crud (create/read/update/delete) operations. – Nicolas Boisteault Aug 28 '14 at 7:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.