[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