get the table dump in pg_dump code example Example: postgresql pg_dump pg_dump -U user -d db_name -h 127.0.0.1 > dump.sql