Re: Dragging and dropping tables between databases

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: John Gage <jsmgage(at)numericable(dot)fr>
Cc: NOVICE Postgres elist <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Dragging and dropping tables between databases
Date: 2010-06-03 17:20:32
Message-ID: AANLkTinVPdasfqcmYmYi2RDgwYIDqOPTdyKBme2k70uc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Jun 3, 2010 at 11:29 AM, John Gage <jsmgage(at)numericable(dot)fr> wrote:

> Okay, maybe not that simple, but is there a way to transfer a table
> easily between two databases?
>
> The easiest way I can think of is to back-up the table in an sql file
> and then run the sql file in the other database. Is that the easiest?
>
>
You could also look at the contrib package dblink. However, if you are
planning on making this part of an application, it should be possible to do
this at that level, also.

Sean

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jayadevan M 2010-06-04 06:12:47 BYTEA - issue
Previous Message A. Kretschmer 2010-06-03 17:09:18 Re: Dragging and dropping tables between databases