[gdal-dev] joining shapefile to PG table

[Even Rouault]

> Only simplified the names.  The shapefile name starts with numbers (natural
> earth shapefiles).  There's the problem.  I removed the leading numbers,
> and simplified the shapefile names to a few letters (they're also long
> names), no syntax error (segfault).  Renamed with a short name with a
> single leading number, again the syntax error.
> 
> So, it's a SQL limitation on names?

Yes, SQL identifiers cannot start by a number without being quoted (the SQL 
engine of previous versions was perhaps a bit more tolerant, but the newer 
behaviour is closer to the one of the SQL engines you find in DBs such as 
postgres, mysql, sqlite, etc...)

I've managed to make the request work (*) by changing it like the following :

ogrinfo 123.dbf  -sql "select * from '123' onetwothree left join 
'PG:dbname=autotest port=5432'.poly on onetwothree.prfedea = poly.prfedea"

1) quote the layername after the FROM : '123'
2) just after, add an alias name for the layername : onetwothree
3) use the alias name in the ON because it won't like 123 or '123'



(*) : will crash afterwards with 1.8.0 when being evaluated...

> 
> -----
> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
> http://www.kyngchaos.com/
> 
> "Those people who most want to rule people are, ipso-facto, those least
> suited to do it."
> 
> - A rule of the universe, from the HitchHiker's Guide to the Galaxy