How to check database and database owner information on psql

 How to check database and database owner information on psql:


 You can check with \list command 


example:


testsub=> \list

                                             List of databases

      Name      |   Owner   | Encoding |     Collate     |      Ctype      |       Access privileges

----------------+-----------+----------+-----------------+-----------------+--------------------------------

 testdb             | testuser | UTF8     | en_US.UTF-8     | en_US.UTF-8     |


No comments:

Post a Comment

View running queries in postgresql

 View running queries in postgreSQL: SELECT * FROM pg_stat_activity;