[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
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
of records update..from that file, i want to insert new row every one
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
> 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:
Sent from the PostGIS - User mailing list archive at Nabble.com.

postgis-users mailing list
postgis-users at postgis.refractions.net
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