Answers for "postgres user can see all databases"

SQL
1

how to check database username and password in postgresql

sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'postgres';"
Posted by: Guest on August-18-2020
0

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;
Posted by: Guest on November-12-2021

Code answers related to "postgres user can see all databases"

Code answers related to "SQL"

Browse Popular Code Answers by Language