[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