I had occasion to import data from a table in a database and import it into another table on another database on another server. pg_dump with -a, -D, -t options gives the table data as a set of INSERT statements. The thing is that I needed to insert into a table with a different name, with only selected fields which were named differently. I tried
(
Read more... )