The ALL_USERS view provides the information on all usernames.

Parameter Type Description
username TEXT The name of a user.
user_id OID The numeric user id assigned to the user.
created TIMESTAMP WITHOUT TIME ZONE This parameter is supported for compatibility only. The value is NULL.