#!/usr/bin/env bash
set -x
# Do the following before running
#su - postgres
#psql
#postgres=#   \l
#postgres=#   \c boo
#boo=#        \q

# pg_lsclusters
# pg_ctlclusters 9.6 main status
# pg_ctlclusters 9.6 main start
# pg_ctlclusters 9.6 main stop

# show data_directory;
# INSERT INTO
#    pg_catalog.pg_database(
#      datname, datdba, encoding, datcollate, datctype, datistemplate, datallowconn,
#      datconnlimit, datlastsysoid, datfrozenxid, datminmxid, dattablespace, datacl)
#    VALUES(
#                             -- Write Your collation
#      'NewDBname', 10, 6, 'Turkish_Turkey.1254', 'Turkish_Turkey.1254',
#      False, True, -1, 12400, '536', '1', 1663, Null);
# select oid from pg_database a where a.datname = 'boo';

#reset password
#/etc/postgresql-9.6/main/pg_hba.conf
#`local  all   all   trust`
#Then systemctl restart postgresql

SCHEMA=public
DB=boo
USER=postgres
PGPASSWORD=

#run this manually first
#psql -Atc "select tablename,schemaname from pg_tables" $DB $USER
tables=`psql -Atc "select tablename from pg_tables where schemaname='$SCHEMA'" $DB $USER`
for TBL in $tables
do
psql -c "COPY $SCHEMA.$TBL TO STDOUT WITH CSV" $DB $USER > $TBL.csv
done