Home Backup complete postgis database with geometry transformation
Reply: 0

Backup complete postgis database with geometry transformation

user510
1#
user510 Published in July 20, 2018, 1:13 am

I have a PostGIS enabled PostgreSQL database that is no longer needed in production. I would like to back it up, but the geometry columns of PostGIS should be transformed to a simple, long-term stable text format like WKT.

I'm aware of the ST_AsText function.

SELECT road_id, ST_AsText(road_geom) AS geom, road_name FROM roads;

But how do I apply this to backup the complete database with several tables with geometries and many without?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.330943 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO