RE: [postgis-users] insert .sql using script

2008-07-29 Thread Obe, Regina
have drivers for postgresql. Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of searchelite Sent: Monday, July 28, 2008 11:20 PM To: postgis-users@postgis.refractions.net Subject: RE: [postgis-users] insert .sql using script Thank

RE: [postgis-users] insert .sql using script

2008-07-28 Thread searchelite
Thanks for the reply.. The reason why i want to do this is because i want to simulate real-time gps data from gps collected table.. I have a gps record table, and i want to insert the record into the database every ten seconds Thanks Obe, Regina DND\MIS wrote: > > Yes. Although it depend

RE: [postgis-users] insert .sql using script

2008-07-28 Thread Obe, Regina
om: [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

RE: [postgis-users] insert .sql using script

2008-07-27 Thread searchelite
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 fas

RE: [postgis-users] insert .sql using script

2008-07-26 Thread Paragon Corporation
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 "\so