I have two PostGIS databases on two different servers. The first server is PostGIS 2.0 and the second server is PostGIS 1.5.
On the PostGIS 2.0 I have a table "lakes" with MULTIPOLYGON geometry column. My task is to copy my table from the PostGIS 2.0 database on the first server to a PostGIS 1.5 on the second server.
I can't access the first database through remote connection, and therefore I can only export the table by exporting it to a .sql file.
What command do I use to export my "lakes" table to an .sql file to ensure that the geometry column information and the spatial index is correctly recreated in the second database?
I used the tool shp2pgsql before. Is there a similar tool for "PostGIS to PostGIS" export?