Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

The names of columns are written using English letters.

Can the names of columns be automatically renamed using another language?

share|improve this question
    
Why do you want to change column names? –  Nicolas Boisteault Aug 27 at 12:28
    
For people who will work with them in QGIS. It'll be easier to understand what is this. –  bable Aug 27 at 12:52
1  
what locale is is the postgres DB in? –  Mapperz Aug 27 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 at 12:02

3 Answers 3

up vote 3 down vote accepted

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.

share|improve this answer
    
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 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 at 9:13

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

Settings > Options > Locale

enter image description here


EDIT:

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

share|improve this answer
    
Thank's, but it didn't help. –  bable Aug 27 at 13:12
    
@bable, I've updated my post in the hope it might help. –  Joseph Aug 27 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 
  select
    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.

share|improve this answer
    
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 at 7:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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