Pgdumpall
pg_dumpall extracts a PostgreSQL database cluster into a script file.
PGPASSWORD=abc pg_dumpall -U myuser --cleanThis writes to stdout, so redirect as needed.
The --clean option includes commands to drop and recreate the database in the output dump.