[postgis-users] insert .sql using script

Paragon Corporation lr at pcorp.us
Sat Jul 26 22:23:11 PDT 2008

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

Hope that helps,

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
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:
Sent from the PostGIS - User mailing list archive at Nabble.com.

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list