Postgresql更新已存在数据库下表的拥有者

以下代码由PHP站长网 52php.cn收集自互联网

现在PHP站长网小编把它分享给大家，仅供参考

#!/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
        Also merged changes from @sharoonthomas
 
OPTIONS:
   -h      Show this message
   -d      Database name
   -o      Owner
EOF
}
 
DB_NAME=
NEW_OWNER=
PGSQL_USER=postgres
 
while getopts "hd:o:" OPTION 
do
    case $OPTION in
        h)  
            usage
            exit 1
            ;;  
        d)  
            DB_NAME=$OPTARG
            ;;  
        o)  
            NEW_OWNER=$OPTARG
            ;;  
    esac
done
 
if [[ -z $DB_NAME ]] || [[ -z $NEW_OWNER ]]
then
     usage
     exit 1
fi
 
for tbl in `psql -U $PGSQL_USER -qAt -c "select tablename from pg_tables where schemaname = 'public';" ${DB_NAME}` 
           `psql -U $PGSQL_USER -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" ${DB_NAME}` 
           `psql -U $PGSQL_USER -qAt -c "select table_name from information_schema.views where table_schema = 'public';" ${DB_NAME}` ;
do  
    psql -U $PGSQL_USER -c "alter table "$tbl" owner to ${NEW_OWNER}" ${DB_NAME} ;
done

以上内容由PHP站长网【52php.cn】收集整理供大家参考研究

如果以上内容对您有帮助，欢迎收藏、点赞、推荐、分享。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!