Sample Header Ad - 728x90

PostgreSQL, PostGIS: Copying a schema with a geometry column

2 votes
1 answer
862 views
According to the PostGIS manual , geometry columns should not by added directly, but using AddGeometryColumn() : > AddGeometryColumn — Adds a geometry column to an existing table of > attributes. I am copying a schema from one PostgreSQL instance to another. I wonder if the SQL created by pg_dump is good enough - will it create the geometry columns the same way AddGeometryColumn() does?
Asked by Adam Matan (12079 rep)
Jul 17, 2014, 04:32 PM
Last activity: Jul 17, 2014, 07:46 PM