PG_USER_INFO

PG_USER_INFO is an Amazon Redshift system view that shows user information, such as user ID and password expiration time.

Only superusers can see PG_USER_INFO.

Table columns

PG_USER_INFO contains the following columns. For more information, see the PostgreSQL documentation.

Column name	Data type	Description
usename	name	The username.
usesysid	integer	The user ID.
usecreatedb	boolean	True if the user can create databases.
usesuper	boolean	True if the user is a superuser.
usecatupd	boolean	True if the user can update system catalogs.
passwd	text	The password.
valuntil	abstime	The password's expiration date and time.
useconfig	text[]	The session defaults for run-time variables.
useconnlimit	text	The number of connections that the user can open.