Is there a way to save manual QGIS changes to Postgis to SQL script?

Question

I am manually editing a Postgis layar with QGIS and would like to export these manual changes in the form of an SQL script. This way:

• I can do it automatically next time i need to
• it is easier to work on remote machines where i don't have QGIS

Is this possible?

Answer 1

Don't know how to do it specifically for QGIS, but when I want to know what queries an application is executing, I turn on logging on the database. If you are only interested in seeing update/inserts you can do this:

ALTER DATABASE mygisdb SET log_statement='mod';

Read: http://www.postgresql.org/docs/9.0/static/runtime-config-logging.html for more details

Then check your logs after your QGIS change and copy the statements.

Logs are usually kept in pg_log folder (check your postgresql.conf to be sure).

Answer 2

I have no idea to do it automatically with QGIS but I know that you can retrieve WKT geometry just with copy and past data from QGIS to text file. You need to write the SQL part (*UPDATE FROM XXXX SET the_geom='' WHERE id='YY'* ou INSERT).

Hope it helps,

Y.