copying between Postgres databases

From: javier garcia - CEBAS <rn001(at)cebas(dot)csic(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: copying between Postgres databases
Date: 2003-03-17 09:21:29
Message-ID: 200303170910.h2H9Ar217950@natura.cebas.csic.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi;
I've got two questions:

1) What is the best way to copy a Postgres table in one database into another
Postgres database? Is it possible to copy the structure and the data at the
same time?

2) Is there a way to do a short of pg_dump and to use the resulting file as
input to another database, but preserving existing tables in this latter?

Thanks and regards

Javier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Moore-Oliva 2003-03-17 09:39:01 Re: copying between Postgres databases
Previous Message Lincoln Yeoh 2003-03-17 04:24:03 Re: type-casting and LIKE queries