[OSM-dev] Update to osm-new.xml
raphael Jacquot
sxpert at sxpert.org
Wed Nov 29 09:25:37 GMT 2006
Nick Whitelegg wrote:
> Hello Artem,
>
>> Nick,
>
>> Unfortunately, NATURAL is a reserved keyword in PostgreSQL.
>
> How awkward :-(
>
>> Perhaps we could use natural_ ??
>
> I guess it's the osm2pgsql.c which would need modifying, translating
> "natural" tags to a "natural_" table?
>
> Nick
simpler, you can use "" quotes to force it:
sxpert=# create table test (
sxpert(# "natural" text
sxpert(# );
CREATE TABLE
sxpert=# \d test
Table "public.test"
Column | Type | Modifiers
---------+------+-----------
natural | text |
sxpert=#
More information about the dev
mailing list