Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to copy tables between databases?
- From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
- To: "Brad Nicholson" <bnichols(at)ca(dot)afilias(dot)info>
- Cc: "Kynn Jones" <kynnjo(at)gmail(dot)com>, "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
- Subject: Re: How to copy tables between databases?
- Date: Tue, 26 Feb 2008 15:00:26 -0600
On Tue, Feb 26, 2008 at 2:36 PM, Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> wrote: > On Tue, 2008-02-26 at 15:19 -0500, Kynn Jones wrote: > > > > Is there a simple way to copy a table from one database to another > > without generating an intermediate dump file? > > > > pg_dump -t <table name> <source DB> | psql -d <target DB> Starting around 8.2 you can have > 1 -t switch, and grab a table or a wildcarded set of tables with each one.
- References:
- How to copy tables between databases?
- From: Kynn Jones
- Re: How to copy tables between databases?
- From: Brad Nicholson
- How to copy tables between databases?
- Prev by Date: Re: How to copy tables between databases?
- Next by Date: Re: utf8 issue
- Previous by thread: Re: How to copy tables between databases?
- Next by thread: win32: how to backup (dump does not work)
- Indexes: