[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