In QGIS 2.16 you can now rename fields in Postgres, Oracle, OGR and memory layers by double clicking the field name in the layer properties window.
This feature was developed by Nyall Dawson (North Road)
This application was created by Kartoza (Pty) Ltd. Available on GitHub! Version: 2.3.1