/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 vote124 views1 answer
Order by monthly in sql
SQL
6 votes128 views1 answer
Oracle trigger after logon on database
SQL
2 votes153 views1 answer
Sql OR
SQL
0 vote151 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote137 views1 answer
SQL Query to delete all the tables in a database
SQL
11 votes164 views2 answers
Set default column value sql
SQL
4 votes132 views1 answer
Update table from another table oracle
SQL
1 vote127 views1 answer
How much every mysql database record takes from diskspace
SQL
15 votes131 views4 answers
How to get all tables in sql
SQL
1 vote154 views2 answers
End mysql command
SQL

Share