Postgres Pro
Downloads
Home   >   mailing lists

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

From Kynn Jones
Subject Re: Easiest way to copy table from one db to another?
Date
Msg-id c2350ba40806200546t4f4d90dey1eeff1fe89fa1395@mail.gmail.com
Whole thread Raw
In response to Re: Easiest way to copy table from one db to another?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Tree view
On Wed, Jun 18, 2008 at 4:08 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
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

Thanks!

Kynn

pgsql-general by date:

Previous
From: "Dmitry Koterov"
Date:
Subject: How to UPDATE in ROW-style?
Next
From: Hermann Muster
Date:
Subject: Connection to second database on server