Dump data and schema from PostgreSQL DB

dump_schema_data_from_postgres.sh

#!/bin/bash

DBNAME="dbname"
tables=$(psql -d $DBNAME -t -c "SELECT table_name FROM information_schema.tables WHERE table_schema='public' and table_type='BASE TABLE'"|cut -d' ' -f2)
while IFS= read -r table; do
    pg_dump --schema-only -t $table $DBNAME > $table.schema
    pg_dump --data-only -t $table $DBNAME > $table.data
done <<< "$tables"