To create a dump of all the inserts with data and column names using pg_dump

pg_dump -U your_username -d your_database -h your_host -p your_port --column-inserts --data-only -f output.sql

#postgres #database