qgis - How to refresh the attribute table of a layer after editing the table in the DB-Manager?

Is there any way to refresh the attribute table of a layer after editing the table (e.g. add a column) in the DB-Manager?

Answer

Short and sweet:

1. Install changeDataSource plugin.


2. Right-click on the layer in the Layers Panel and select Change vector datasource.


3. In the dialog box that appears, just hit OK without changing any of the settings.

Basically, you are "changing" the vector datasource to what it already was, but this forces QGIS to reload the layer definition.

Tested in QGIS 2.14 on Linux Mint 17.2.