塨的博客

postgres=# \du                             List of roles Role name |                   Attributes                   | Member of -----------+------------------------------------------------+-----

SELECT u.datname  FROM pg_catalog.pg_database u where u.datname='rftDatabase';

databasename=rftDatabaseresult=`psql   SELECT count(u.datname) FROM pg_catalog.pg_database u where u.datname='${databasename}'; EOF`DBID=`echo $result | awk -F' ' '{print $3}'`echo "${DB

databaseuser=globus1result=`psql   SELECT u.usename FROM pg_catalog.pg_user u  where u.usename='${databaseuser}'; EOF`usename=`echo $result | awk -F' ' '{print $3}'`echo "${usename}"if