Re: Dumping a table from one database and adding it to another

On 12/02/2010 12:49 PM, James B. Byrne wrote:
> I have read the documentation respecting backups but I cannot seem
> to find any mention of the specific case that I wish performed.
>
> I have a pair of tables in a production database that I wish to dump
> and then restore to a new, different database. I can, and probably
> will, recreate the tables and column layouts in the new database.
>
> Is there a way to load the data dumped from a single table in one
> database into a new, possibly differently named, table in a
> different database, using PG utilities?
>
>

In my previous post comment should have read, change below :<

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com