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(…
Free and Open Source GIS Ramblings 
Thanks for this – how do you install the PostGIS Manager plugin? I downloaded a copy but I’ve no idea where to put it.
Python plugins are stored in ~/.qgis/python/plugins folder. If you download the plugins using plugin installer, you don’t have to do this manually – the tool will take care of everything and inform you of new updates.