[OSM-dev] Update to osm-new.xml
Artem Pavlenko
artem at pavlenko.uklinux.net
Wed Nov 29 09:47:18 GMT 2006
Sxpert, cool!
Yes, indeed, "natural" works fine. We just have to be careful to do the
same in osm.xml
Artem.
raphael Jacquot wrote:
> 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