Re: Copying table to another database.

From: Tycho Fruru <tycho(at)fruru(dot)com>
To: Wim <wdh(at)belbone(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Copying table to another database.
Date: 2002-09-17 09:41:42
Message-ID: 1032255703.26629.8.camel@kungfoo.conostix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2002-09-17 at 11:32, Wim wrote:
> Hello,
>
>
> Anyone knows how to copy a table to another database?

perhaps pg_dump the table and then restore it in another database (you
could pipe the output of pg_dump to the input of a psql so you don't
have to store the dump anywhere.

Good luck,
Tycho

--
Tycho Fruru tycho(at)fruru(dot)com
"Prediction is extremely difficult. Especially about the future."
- Niels Bohr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2002-09-17 09:51:05 Re: connecting inside pl/pgsql
Previous Message Wim 2002-09-17 09:32:30 Copying table to another database.