Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #postgresql #show #owner #database
ADD COMMENT
Topic
Name
8+4 =