how to dump data into pgsql code example
Example 1: postgresql pg_dump
pg_dump -U user -d db_name -h 127.0.0.1 > dump.sql
Example 2: psql load dump
psql databasename < data_base_dump
Example 3: how to backup postgresql database using pg_dump
pg_dump dbname > outfile