Monday, July 1, 2013

Re: data transfer between databases

On 1 July 2013 13:02, Mike Dewhirst <miked@dewhirst.com.au> wrote:
 
On 1/07/2013 9:35pm, Tom Evans wrote:
On Sun, Jun 30, 2013 at 11:24 PM, Mike Dewhirst <miked@dewhirst.com.au> wrote:
mulianto and Avraham

Thanks for your suggestions. Dumping data isn't the entire problem - which
is this:

There will be an *ongoing* need to add new data from tables in one database
to the same-named tables in another database on a remote machine. Two of the
tables are in a m2m relationship.


You can use direct access via "foreign tables" the name of the Postgres distributed database feature.
http://www.postgresql.org/docs/devel/static/sql-createforeigntable.html

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment