[postgis-devel] Re: [postgis-users] create tables smarter

[Paul Ramsey]

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