[postgis-users] insert .sql using script

searchelite searchelite at gmail.com
Sun Jul 27 07:17:07 PDT 2008


No..i dont have autogenerated sql file..let say that i have a .sql file full
of records update..from that file, i want to insert new row every one minute
to a new table. can i do that with psql?



Paragon Corporation-2 wrote:
> 
> 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
> 
> 
> 

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




More information about the postgis-users mailing list