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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of searchelite Sent: Thursday, July 24, 2008 11:58 PM To: postgis-users@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
