The below command is an example of creating a sql file of the us_states table in my local development postgres database for Rudolph. This is helpful for giving data to other developers, for instance this is how postcodes for the US, Germany, and the Netherlands have been shared with Hardin D&D developers to put into visual manager.
pg_dump -h localhost -p 5432 -U postgres -d cre_cmbs_development -t us_states > us_states.sql