export-dump-from-one-table-as-sql-inserts.md

create table export_table as
select id, name, city
from nyummy.cimory
where city = 'tokio'

$ pg_dump --table=export_table --data-only --column-inserts my_database > data.sql

Source