[postgis-users] Postgis and perl
Dave Blasby
dblasby at refractions.net
Wed Sep 11 10:26:35 PDT 2002
> "Eric L. Blevins" wrote:
> Can I use the Perl Postgre database interface to add spatial data to
> the postgis database?
> Or do I have to use the loader program?
Yes - I often use perl to add geometries to postgis. Since PostGIS uses
the standard SQL interface, it really easy.
$sql = "INSERT INTO mygeomtable VALUES (1, setSRID('POINT(1
2)'::geometry,25710))"
$sql2 = "SELECT * FROM mygeomtable WHERE the_geom && setSRID('BOX3D(0
0,10 10)'::box3d,25710)"
dave
More information about the postgis-users
mailing list