search

pramsey / pgsql-ogr-fdw

PostgreSQL foreign data wrapper for OGR
MIT License
239 stars 34 forks source link

' not being escaped in column_name #124

Closed robe2 closed 7 years ago

robe2 commented 7 years ago

I had a CSV file that had a header:

Presenter's Email

and it failed. So I changed the autogenerated foreign table definition from

`
presenter_s_email varchar OPTIONS (column_name 'Presenter's Email'),

`

to

`
presenter_s_email varchar OPTIONS (column_name $col$Presenter's Email$col$),

`

I'll try to provide a patch for this

robe2 commented 7 years ago

Committed patch resolves this.