#!/bin/bash

sudo su postgres <<'EOF'
psql -c 'DROP SCHEMA public;' stagecraft
psql -c 'CREATE SCHEMA public;' stagecraft
psql -c 'ALTER SCHEMA public OWNER TO stagecraft;' stagecraft
EOF

#!/bin/bash

sudo su postgres <<'EOF'
psql -c 'DROP SCHEMA public CASCADE;' stagecraft
psql -c 'CREATE SCHEMA public;' stagecraft
psql -c 'ALTER SCHEMA public OWNER TO stagecraft;' stagecraft
EOF

Add cascade option to drop tables tool
Add cascade option to drop tables tool

The script will fail without this as it needs to cascade to other
relations
