Thanks! I'll check this out and definitely give it a go, though i'm a bit sceptical. What i want to achieve is to have the load on H2 until the processing goes on and only merge the results into my main, PG db. As far as i understand, using linked tables just puts H2 in the middle.
I have two types of tables: 1) Kinda' temporary, i just need that to get to H2, but it is not important to get it out from there. 2) The main table, which i want to update with the results. So for type 1) I want to "dump" that data and have it in H2. On Friday, October 11, 2013 10:30:02 AM UTC+2, Noel Grandin wrote: > > > For DB to DB copying, you might have more joy using linked tables: > http://h2database.com/html/grammar.html#create_linked_table > http://h2database.com/html/advanced.html#linked_tables<http://h2database.com/html/advanced.html?highlight=linked%2Ct&search=linked%20t#linked_tables> > > On 2013-10-10 17:51, Tony Taylor wrote: > > I've started playing around and my first difficulty is about transferring > data. My idea is that i copy the data from Postgres > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
