Re: Dragging and dropping tables between databases - Mailing list pgsql-novice

From Sean Davis
Subject Re: Dragging and dropping tables between databases
Date
Msg-id AANLkTinVPdasfqcmYmYi2RDgwYIDqOPTdyKBme2k70uc@mail.gmail.com
Whole thread Raw
In response to Dragging and dropping tables between databases  (John Gage <jsmgage@numericable.fr>)
List pgsql-novice


On Thu, Jun 3, 2010 at 11:29 AM, John Gage <jsmgage@numericable.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

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Dragging and dropping tables between databases
Next
From: Jayadevan M
Date:
Subject: BYTEA - issue