Bash script to drop all tables from a postgresql database and import new data from a file28.02.17

#!/bin/bash                                                                                                                                                                                                                      
die () {
    echo >&2 "$@"
    exit 1
}

if [ $# -eq 0 ] ; then
    die "usage : droptables server user database"
elif [ $# -eq 1 ] ; then
    die "usage : droptables server user database"
elif [ $# -eq 2 ] ; then
    die "usage : droptables server user database"
elif [ $# -eq 3 ] ; then
    SERVER=$1
    USER=$2
    DATABASE=$3
else
    die "usage : droptables server user database"
fi

echo "s:$SERVER u:$USER d:$DATABASE"

psql -h $SERVER -U $USER -d $DATABASE -t -c "SELECT 'DROP TABLE ' || n.nspname || '.' || c.relname || ' CASCADE;' FROM pg_catalog.pg_class AS c LEFT JOIN pg_catalog.pg_namespace AS n ON n.oid = c.relnamespace WHERE relkind =\
 'r' AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid)" > /tmp/droptables
echo "Password:"
psql -h $SERVER -d $DATABASE -U $USER -f /tmp/droptables
psql -h $SERVER -U $USER $DATABASE -f $DATABASE.sql

http://www.fermasoft.com/Blog/Delete-all-tables-in-a-PostgreSQL-schema-without-dropping-the-schema-itself

Anonymous

Bash script to drop all tables from a postgresql database and import new data from a file28.02.17

Information Epoch 1751405681