[postgis-users] create tables smarter

Paul Ramsey pramsey at cleverelephant.ca
Wed Jun 4 08:41:19 PDT 2008


On Wed, Jun 4, 2008 at 8:34 AM, Frank Warmerdam <warmerdam at pobox.com> wrote:
> I did a presentation at PGCon and the issue of AddGeometryColumn() being
> necessary to populate the geometry_columns table came up.  Some of the
> postgres techies suggested there has been work so that extension defined
> types could actually take extra arguments when used in the CREATE TABLE
> statement and that this might let us avoid the need to use
> AddGeometryColumn().
>
> ie.
>
> CREATE TABLE ROADS
>  (id   INT,
>   name VARCHAR(255),
>   geom GEOMETRY(<dimension>,<srid>,<type>) )

Really truly? This is something we've been asking for, for some time,
but I wasn't really holding my breath. Time to go code spelunking and
see if it's there.

P



More information about the postgis-users mailing list