copying between Postgres databases - Mailing list pgsql-general

From javier garcia - CEBAS
Subject copying between Postgres databases
Date
Msg-id 200303170910.h2H9Ar217950@natura.cebas.csic.es
Whole thread Raw
Responses Re: copying between Postgres databases  (Joshua Moore-Oliva <josh@chatgris.com>)
Re: copying between Postgres databases  (Andrew Sullivan <andrew@libertyrms.info>)
Re: copying between Postgres databases  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: type-casting and LIKE queries
Next
From: Joshua Moore-Oliva
Date:
Subject: Re: copying between Postgres databases