psql create dump of database without data code example Example: how to take database dump in postgresql pg_dump dbname > outfile