Postgres Pro
Downloads
Home   >   mailing lists

Re: Easiest way to copy table from one db to another? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Easiest way to copy table from one db to another?
Date
Msg-id dcc563d10806181308jffcc11esa2dedfa59ea51e11@mail.gmail.com
Whole thread Raw
In response to Easiest way to copy table from one db to another?  ("Kynn Jones" <kynnjo@gmail.com>)
Responses Re: Easiest way to copy table from one db to another?  ("Kynn Jones" <kynnjo@gmail.com>)
List pgsql-general
Tree view 
On Wed, Jun 18, 2008 at 1:48 PM, Kynn Jones <kynnjo@gmail.com> wrote:
>
>
> What's the simplest way to copy a table from one database to another one
> running on the same server?

Easiest way to me:

pg_dump -t tablename dbname | psql otherdbname

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: RETURNING clause in 8.2
Next
From: "Dave Lee"
Date:
Subject: Re: migrating from mysql: need to convert empty string to null