How to create a Table with Geometry Column in PostGIS
Do you need to create a table with a geometry column in PostGIS from scratch?
Can’t remember the syntax of AddGeometryColumn(varchar catalog_name, varchar schema_name, varchar table_name, varchar column_name, integer srid, varchar type, integer dimension)? I can’t. ;)
Let’s make our lives easier: QGIS PostGIS Manager offers a convenient GUI for creating tables with geometry columns:
PostGIS Manager Create Table dialog
The dialog works a lot like what you’re probably used to in pgAdmin – with the added nicety of supporting Geometry columns.
In my opinion, this is the fastest way so far to create a spatially enabled table. It provides a much better user experience than telling users (especially new ones) to use AddGeometryColumn(…
