1

I have created a connection between QGIS (ver. 3.10.1-A Coruña) and PostgreSQL (pgAdmin 4).

Every time I edit/update my table in QGIS I have to delete the table in PostgreSQL and re-import again the updated table from QGIS.

How can I update the table without deleting it?

2
  • there should be a 'live' update of the 'remote' potsgres layer you modify ... you must be doing something wrong ... are you sure you commit the changes u make ? – snaileater Apr 25 '20 at 9:07
  • Yes, there something wrong in the workflow. PostgreSQL is a database server. PgAdmin4 and QGIS are both clients, connected to that database. Can you explain you workflow? – etrimaille Apr 25 '20 at 10:24
0

In PGAdmin4, open the db/schema/table tree. Right click on the table. A context menu will appear and there will be an option to REFRESH. Also note the comments about about "COMMIT". See also the manual http://127.0.0.1:32927/help/help/editgrid.html

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.