postgresql what is the best way to export specific column from specific table from a DB to another

Question

When I do this command :

SELECT language, title FROM cms_title WHERE language != 'en' AND title != 'Blog';

I see the pages I want to copy from a DB on the development server to the production server.

So, my aim is to dump those specific pages and then insert them in the production DB.

My question is : Is it possible ? Is it the best practice / way of doing it ?

Thank you so much in advance for the time spent on my request.

Answer 1

I do it the following way:

1.create dump:

psql -h dbhost1 -d dbname -U dbuser -c "copy(SELECT language, title FROM cms_title WHERE language != 'en' AND title != 'Blog') to stdout" > dump.tsv`

2.import dump:

psql -h dbhost2 -d dbname -U dbuser -c 'copy cms_title from stdin' < dump.tsv

This will append imported data to the table.