search

NINAnor / NOFA

Docs for the NOFA database
GNU General Public License v3.0
1 stars 0 forks source link

Wiki: Explain how to escape quotes in SQL string #35

Closed JakobMiksch closed 7 years ago

JakobMiksch commented 7 years ago

It might be good for users to explain in the wiki how escape quotes in the SQL string.

This is sometimes necessary, like in this example:

SELECT "waterBodyID" FROM nofa.lakes

JakobMiksch commented 7 years ago

https://github.com/NINAnor/NOFA/wiki/Fetch-data-from-NOFA-using-postGIStools-(R)/ead1d1fdd241554aaaa809ac8c43408120abd314

I extended the example. @andersfi I hope you agree