You can easily dump Openlayers Layer to GeoJSON saving not only geometry but all the attributes as well. GeoJSON can be store anywhere, as a file or in a database. import GeoJSON from 'ol/format/GeoJSON.js' const format = new GeoJSON({ featureProjection: 'EPSG:3857' }); const layers = map.getLayers(); // map is 'ol/Map' object const source = layers.item(0)....


According to these documentations - http://rivergis.com/requirements.html - the database name should be rivergis. Your settings have localhost as the server, var as the database and rivergis as the user. Try switching database to rivergis, and using postgres as a username if you're still having issues.


Your question says 'append columns' while your code is really about appending rows, or unioning, two tables. There's already an answer for how you would union; here's how you would append the fields to your new table. alter table srs2013_1 add column the_geom geometry(Geometry,SRID); -- where SRID is your coordinate system alter table srs2013_1 add column ...

Only top voted, non community-wiki answers of a minimum length are eligible