TABLE NAMEpostgres_users
DESCRIPTIONThe postgres_users table stores all the users for PostgreSQL.
Because a single person may have access to multiple PostgreSQL
servers, this table represents what is common to them across all
machines. The machine specific details are in the
postgres_server_users table. COLUMNS| column | type | null | unique | references | referenced_by | since_version | description |
|---|
| username | postgres_username | false | true | usernames.username | postgres_server_users.username | 1.80.0 | the username of the user | | createdb | boolean | false | false | | | 1.0a100 | usecreatedb flag | | trace | boolean | false | false | | | 1.0a100 | usetrace flag | | super | boolean | false | false | | | 1.0a100 | usesuper flag | | catupd | boolean | false | false | | | 1.0a100 | usecatupd flag | | disable_log | fkey | true | false | disable_log.pkey | | 1.0a100 | indicates that this account is disabled |
|
