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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of searchelite Sent: Sunday, July 27, 2008 10:17 AM To: postgis-users@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@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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
