mintsoft
/ change_db_owner.sh
Last active
December 16, 2015 21:49
— forked from gingerlime/change_db_owner.sh
Changes the owner on all the tables in a database with support for tables with whitespace and schemata
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| usage() | |
| { | |
| cat << EOF | |
| usage: $0 options | |
| This script set ownership for all table, sequence and views for a given database | |
| Credit: Based on http://stackoverflow.com/a/2686185/305019 by Alex Soto |