Postgresql show owner of database

SELECT d.datname as "Name",
pg_catalog.pg_get_userbyid(d.datdba) as "Owner"
FROM pg_catalog.pg_database d
WHERE d.datname = 'database_name'
ORDER BY 1;

Source: stackoverflow.com

Similar codes

0 vote106 views1 answer
How to locate pg_hba.conf file
SQL
1 vote92 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote89 views1 answer
Sql last 7 days
SQL
0 vote49 views1 answer
Postgres delete where id in
SQL
0 vote92 views1 answer
Watch mysql command line
SQL
0 vote97 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
3 votes95 views1 answer
Kill mysql processlist in whose time more than 200
SQL
28 votes106 views6 answers
Foreign key
SQL
16 votes98 views2 answers
Mysql date between two dates
SQL
-1 vote98 views2 answers
Installing mysql on centos 7
SQL