pg_dump all tables not consistently (!!!)

pg_dump_tables.sh

#!/bin/bash

mydir=/var/lib/pgsql/backups/`date +%Y-%m-%d_%H-%M`

function dumpdb {
  mkdir -p $mydir/$1
  for tbl in  `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" $1` ; do
    pg_dump -t $tbl $1 | gzip > $mydir/$1/$tbl.sql.gz;
  done
}

function dumpall {
  for db in  `psql -qAt -c "SELECT datname FROM pg_database;"` ; do
    dumpdb $db;
  done
}

dumpall