Answers for "how to check username in postgresql"

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

postgresql get current user name

SELECT CURRENT_USER;

Posted by: Guest on March-26-2020

how to know the username of postgresql

SELECT current_user,
       user,
       session_user,
       current_database(),
       current_catalog,
       version();

Posted by: Guest on October-25-2021

Code answers related to "how to check username in postgresql"