[postgis-users] insert .sql using script

[Paragon Corporation]

Where are you inserting from? If from some user input might be faster to
insert from your app e.g. php, .NET etc.

 Is your update.sql file being autogenerated every one minute?

If so - I suppose you can use psql command line something like

psql -h someserver -p 5432 -U someuser -d somedb -f
"\somepath\somefiletorun.sql"

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
searchelite
Sent: Thursday, July 24, 2008 11:58 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] insert .sql using script


Hi all, can anybody please tell me how to insert data automatically in
postgresql? i'm using postgresql 8.3 in windows XP environment. I have a
file update.sql and i want to insert new row every, let say one minute. Is
there any easy way to do that?

thanks in advance
--
View this message in context:
http://www.nabble.com/insert-.sql-using-script-tp18644795p18644795.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users