[postgis-users] AddGeometryColumn doesn't quote column name properly

Bernhard Herzog bh at intevation.de
Thu Nov 13 03:12:39 PST 2003

strk <strk at keybit.net> writes:

> bh wrote:
>> Adding the double quotes there as well would probably fix the problem
>> for names with spaces but would still not work for names with double
>> quotes. Double quotes also don't work in the table name even though
>> spaces do. The best solution for all of these problems would be to use
>> the quote_ident function instead of explicit double quotes.
> from which postgresql is quote_ident() available ?

According to the HISTORY file of PostgreSQL 7.2.1 quote_ident was added
together with quote_literal in 7.1. AddGeometryColumn already uses
quote_literal so it shuld be safe to use quote_ident too.


Intevation GmbH                                 http://intevation.de/
Sketch                                 http://sketch.sourceforge.net/
Thuban                                  http://thuban.intevation.org/

More information about the postgis-users mailing list