/SQL/How to check database username and password in postgresql

How to check database username and password in postgresql

How to check database username and password in postgresql

sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'postgres';"

2

How to know the username of postgresql

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

0

Similar codes

0 vote153 views3 answers
How to increase size of column in sql
SQL
0 vote142 views1 answer
Order by ip address sql
SQL
0 vote179 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
1 vote155 views1 answer
Mysql drop key
SQL
0 vote156 views4 answers
Sql rownum
SQL
6 votes244 views3 answers
Psql show columns of table
SQL
0 vote146 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote160 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote207 views2 answers
Mysql cast to varchar
SQL
2 votes151 views1 answer
Compare date in sql
SQL

Share