On Mon, 17 Mar 2003, javier garcia - CEBAS wrote:
> 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?
Sure, just pipe the output of pg_dump to psql:
pg_dump database1 -t tablename | psql database2 -e