PostgreSQL database dump wrapper

pg_dump_wrapper.bash

#!/bin/bash

# pg_dump wrapper
#   - add 'CREATE DATABASE' to dump
#   - compress with bzip2
#   - timestamp

if [[ "$1" == "" ]]; then
    echo "  Usage: "
    echo "     $0 <db_name>"
    echo
    echo "  This will create a timestamped, compressed sql dump of a single database."
    echo "  To restore use"
    echo "     bzcat <dump_file> | psql -q"
else
    pg_dump -C $1 | bzip2 > $1_`date "+%Y%m%d-%H%M"`.sql.bz2
fi