Re: best method to copy data across databases - Mailing list pgsql-sql

reina_ga@hotmail.com (Tony Reina) writes:
> If the 2 tables have different arrangements, then I'm not sure if
> there is a quick way. The safest way is probably to do a pg_dump
> --attribute-inserts.

In recent versions (definitely 7.4, don't remember about 7.3),
pg_dump will include a column list in its COPY commands, so a
plain pg_dump should work.  The way with COPY will be a good bit
faster than a pile of INSERT commands.
        regards, tom lane