/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 vote174 views1 answer
Mysql procedure between two tables
SQL
0 vote195 views1 answer
How to combine rows in sql server procedure
SQL
0 vote178 views1 answer
Select nth row in mysql
SQL
5 votes185 views1 answer
Find table from column name in sql
SQL
0 vote165 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote179 views1 answer
Raiserror with nowait
SQL
5 votes176 views3 answers
Oracle first day of last year
SQL
2 votes183 views1 answer
Oracle percentage
SQL
0 vote190 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote182 views1 answer
How to populate a table in MySQL from and existing csv file
SQL

Share