[postgis-users] catalog value in geometry_columns

Nicolas Ribot nicky666 at gmail.com
Sat Oct 1 10:35:29 PDT 2005

> I have a Postgis database built from dumped tables.
> The new database does not have any entries in the geometry_columns table, so
> I'm looking at a script to insert these.
> I can get the geometrytype & dimension from the table easily enough, but I'm
> confused by:
> from the docs:
> but
>   "There is not PostgreSQL analogue of "catalog" so that column is left blank"
> The field seems to have nothing in it, which I assume is a null string, rather
> than a Postgres NULL?
> What is the appropriate value to insert in this field?

An empty string does the trick ('')


More information about the postgis-users mailing list