[postgis-users] Create table as doesn't populate geometry_columns

Simon O'Malley simonom at gmail.com
Mon Jun 19 01:23:32 PDT 2006


Hi Brent

Thanks for that.

What then is the purpose of the f_table_catalog column then.

It says it is not null, but mine is obviously filled with blanks???

Simon

On 6/19/06, Brent Wood <pcreso at pcreso.com> wrote:
>
>
>
> --- Simon O'Malley <simonom at gmail.com> wrote:
>
> > Hi List
> >
> > Should a create table as select statement also add an entry into the
> > geometry_columns table.
> >
>
> Hi Simon.
>
> Debatable. I'd like to think it should, but it doesn't :-)
>
> Geometry_column entries are only created by creategeometrycolumn(), for
> tables
> created by selects, or views, you'll need to do it manually.
>
> Brent
>
>
> > i.e.
> >
> > create table table1 as select id, transform(shape, 4326) as shape from
> > table;
> >
> > select * from geometry_columns where f_table_name = 'table1';
> > ------
> > (0 rows)
> >
> > Or is there something I have missed?
> >
> > Cheers
> > Simon
> > > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060619/48d3f251/attachment.html>


More information about the postgis-users mailing list