/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

10 votes315 views4 answers
Mysql one week ago
SQL
0 vote316 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote327 views1 answer
Datagrip execute procedure
SQL
9 votes320 views3 answers
Show table columns mysql command line
SQL
6 votes320 views1 answer
T-sql test if table exists
SQL
10 votes348 views2 answers
Doublon sql
SQL
1 vote307 views1 answer
Show table status command in mysql
SQL
0 vote322 views1 answer
Sql drop procedure if exists
SQL
8 votes269 views8 answers
Second highest salary in mysql
SQL
0 vote308 views1 answer
Get number of tables in database sql
SQL

Share