Hi there
I need to add periodically some data from a remote mysql database into our
postgresql database. So, does anyone know how to do it having in mind that
it must be runned every minute or so for adding new records to the
postresql?
Best regards
--
View this message in context:
http://post
So, do you know where I can find out an example for that?
*Fran*
On 14 November 2010 14:13, Leif Biberg Kristensen [via PostgreSQL] <
ml-node+3264406-1436673590-144...@n5.nabble.com
> wrote:
> On Sunday 14. November 2010 13.44.53 franrtorres77 wrote:
> >
> > Hi there
well, I know how to query to mysql but what i dont know is how to then write
that data on the fly to the postgresql
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Adding-data-from-mysql-to-postgresql-periodically-tp3264392p3264417.html
Sent from the PostgreSQL - general
Hello again.
Well, the data that I want to import is some satellite coordinates saved in
mysql , the fields are X and Y and want to import them into a postgis table
for converting these coordinates to a normal latitude and longitude points
because in mysql are saved in Utm format.
I have foound
Hello
I have the next query in mysql to get the time difference from two rows, but
I would like to implement it in postgres, but I'm getting some errors when I
try to query it.
select speed,mobile,date,
timediff(@nexttime,date) as tdiff2, (@nexttime:=date) as Next
from positions
where speed=0 an
