[postgis-users] insert .sql using script

Obe, Regina robe.dnd at cityofboston.gov
Mon Jul 28 05:11:35 PDT 2008


Yes.  Although it depends which environment you will be inserting from.
psql may not be the best option.  If it is not an autogenerated sql
file, I'm not sure why you would be doing this or maybe I just don't
quite understand what you are saying.

 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
searchelite
Sent: Sunday, July 27, 2008 10:17 AM
To: postgis-users at postgis.refractions.net
Subject: RE: [postgis-users] insert .sql using script


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.

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.




More information about the postgis-users mailing list