Re: [GENERAL] Easiest way to copy table from one db to another?

2008-06-20 Thread Kynn Jones
On Wed, Jun 18, 2008 at 4:08 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Wed, Jun 18, 2008 at 1:48 PM, Kynn Jones <[EMAIL PROTECTED]> 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

Re: [GENERAL] Easiest way to copy table from one db to another?

2008-06-18 Thread Scott Marlowe
On Wed, Jun 18, 2008 at 1:48 PM, Kynn Jones <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-gen

[GENERAL] Easiest way to copy table from one db to another?

2008-06-18 Thread Kynn Jones
What's the simplest way to copy a table from one database to another one running on the same server? TIA! Kynn