Re: [postgis-users] design question: how to geocode multiple dynamic "city, country"? - Mailing list pgsql-general

From Rémi Cura
Subject Re: [postgis-users] design question: how to geocode multiple dynamic "city, country"?
Date
Msg-id CAJvUf_v4869mUZNZ45n6CQEit0GnNFDysvmSMxZ0iCxoZrqWsg@mail.gmail.com
Whole thread Raw
In response to design question: how to geocode multiple dynamic "city, country"?  (zach cruise <zachc1980@gmail.com>)
List pgsql-general
Hey,
my 2 cents :
If you give write access, beware of the sql injections
http://en.wikipedia.org/wiki/SQL_injection

Cheers,
Rémi-C



2014-04-10 21:48 GMT+02:00 zach cruise <zachc1980@gmail.com>:
i accept multiple "city, country" from users on-the-fly, and want to
dynamically map them.

i could create a table where i insert their multiple entries, and then
geocode that table for display.

but i also want to avoid giving write permission to the web user.

i could create a schema and restrict write to that schema.

or something better?
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Linux vs FreeBSD
Next
From: "Victor Sterpu"
Date:
Subject: Correct syntax