On Jul 7, 2011, at 4:22 PM, Even Rouault wrote:
>
>> 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 synt
> 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
On Jul 7, 2011, at 3:17 PM, Even Rouault wrote:
> Le jeudi 07 juillet 2011 21:57:31, William Kyngesburye a écrit :
>> I'm having a problem joining a Postgres table to a shapefile. I've done
>> this in the past with MySQL tables.
>>
>> ogrinfo -al -so myshapefile.shp -sql "SELECT * FROM myshapefi
Le jeudi 07 juillet 2011 21:57:31, William Kyngesburye a écrit :
> I'm having a problem joining a Postgres table to a shapefile. I've done
> this in the past with MySQL tables.
>
> ogrinfo -al -so myshapefile.shp -sql "SELECT * FROM myshapefile LEFT JOIN
> 'PG:dbname=mypgdb host=localhost user=so
I'm having a problem joining a Postgres table to a shapefile. I've done this
in the past with MySQL tables.
ogrinfo -al -so myshapefile.shp -sql "SELECT * FROM myshapefile LEFT JOIN
'PG:dbname=mypgdb host=localhost user=someuser password='.mypgtable ON
myshapefile.keyfield = mypgtable.keyfield
