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

strk strk at keybit.net
Thu Nov 13 05:17:47 PST 2003

bh wrote:
> 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.



More information about the postgis-users mailing list