Postgresql, below an example of query for show table pg_shadow.

 

Postgresql, below an example of query for show table pg_shadow.

Pg_shadow is views its contains information about rolename and user password,user password validity,user connection , etc.

#pg_shadow #postgres #postgresql #database #dba

#backend #linux