Dump a schema from a Heroku app's database.

heroku-pg-dump-schema.sh

#!/bin/sh

# Usage: heroku-pg-dump-schema.sh HEROKU-APP-NAME DB-ENV-VAR-NAME SCHEMA-NAME

app=$1
env_var=$2
schema=$3

db_url=`heroku config -s --app ${app} | grep ${env_var}`

export PGDATABASE=`sed -E 's|^.*/([a-zA-Z0-9]*)$|\1|' <<EOF
$db_url
EOF`
export PGHOST=`sed -E 's|^.*@([-.a-zA-Z0-9]*):.*$|\1|' <<EOF
$db_url
EOF`
export PGPORT=`sed -E 's|^.*:([-.a-zA-Z0-9]*)/.*$|\1|' <<EOF
$db_url
EOF`
export PGUSER=`sed -E 's|^.*//([a-zA-Z0-9]*):.*$|\1|' <<EOF
$db_url
EOF`
export PGPASSWORD=`sed -E 's|^.*:([a-zA-Z0-9]*)@.*$|\1|' <<EOF
$db_url
EOF`

pg_dump --schema ${schema} -Osx

Original script required modification for it to work (for me anyway). Modified script below in case it might help someone else

#!/bin/sh
​
# Usage: heroku-pg-dump-schema.sh HEROKU-APP-NAME SCHEMA-NAME
​
app=$1
schema=$2
​
db_url=`heroku config --app ${app} | grep HEROKU_POSTGRESQL`
​
export PGDATABASE=`sed -E 's/^.*\/([a-zA-Z0-9]*)$/\1/' <<EOF
$db_url
EOF`
export PGHOST=`sed -E 's/^.*@([-.a-zA-Z0-9]*):.*$/\1/' <<EOF
$db_url
EOF`
export PGPORT=`sed -E 's/^.*:([-.a-zA-Z0-9]*)\/.*$/\1/' <<EOF
$db_url
EOF`
export PGUSER=`sed -E 's/^.*\/\/([a-zA-Z0-9]*):.*$/\1/' <<EOF
$db_url
EOF`
export PGPASSWORD=`sed -E 's/^.*:([a-zA-Z0-9]*)@.*$/\1/' <<EOF
$db_url
EOF`
​
pg_dump --schema ${schema} -Osxv -f schema.sql