pg_user

A system view providing a publicly-accessible version of pg_shadow

pg_user is a system catalogue view providing a publicly-accessible version of pg_shadow, with identical fields apart from passwd, which is displayed as a series of asterisks (regardless of whether or not a password is set for the user).

pg_user was added in in PostgreSQL 6.3, replacing the former system catalogue table pg_user, which was replaced by pg_shadow.

Definition by PostgreSQL version

pg_user (PostgreSQL 15)

                        View "pg_catalog.pg_user"
    Column    |           Type           | Collation | Nullable | Default 
--------------+--------------------------+-----------+----------+---------
 usename      | name                     |           |          | 
 usesysid     | oid                      |           |          | 
 usecreatedb  | boolean                  |           |          | 
 usesuper     | boolean                  |           |          | 
 userepl      | boolean                  |           |          | 
 usebypassrls | boolean                  |           |          | 
 passwd       | text                     |           |          | 
 valuntil     | timestamp with time zone |           |          | 
 useconfig    | text[]                   | C         |          |

Documentation: pg_user

pg_user (PostgreSQL 14)

                        View "pg_catalog.pg_user"
    Column    |           Type           | Collation | Nullable | Default 
--------------+--------------------------+-----------+----------+---------
 usename      | name                     |           |          | 
 usesysid     | oid                      |           |          | 
 usecreatedb  | boolean                  |           |          | 
 usesuper     | boolean                  |           |          | 
 userepl      | boolean                  |           |          | 
 usebypassrls | boolean                  |           |          | 
 passwd       | text                     |           |          | 
 valuntil     | timestamp with time zone |           |          | 
 useconfig    | text[]                   | C         |          |

Documentation: pg_user

pg_user (PostgreSQL 13)

                        View "pg_catalog.pg_user"
    Column    |           Type           | Collation | Nullable | Default 
--------------+--------------------------+-----------+----------+---------
 usename      | name                     |           |          | 
 usesysid     | oid                      |           |          | 
 usecreatedb  | boolean                  |           |          | 
 usesuper     | boolean                  |           |          | 
 userepl      | boolean                  |           |          | 
 usebypassrls | boolean                  |           |          | 
 passwd       | text                     |           |          | 
 valuntil     | timestamp with time zone |           |          | 
 useconfig    | text[]                   | C         |          |

Documentation: pg_user

pg_user (PostgreSQL 12)

                        View "pg_catalog.pg_user"
    Column    |           Type           | Collation | Nullable | Default 
--------------+--------------------------+-----------+----------+---------
 usename      | name                     |           |          | 
 usesysid     | oid                      |           |          | 
 usecreatedb  | boolean                  |           |          | 
 usesuper     | boolean                  |           |          | 
 userepl      | boolean                  |           |          | 
 usebypassrls | boolean                  |           |          | 
 passwd       | text                     |           |          | 
 valuntil     | timestamp with time zone |           |          | 
 useconfig    | text[]                   | C         |          |

Documentation: pg_user

pg_user (PostgreSQL 11)

                View "pg_catalog.pg_user"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 usename      | name    |           |          | 
 usesysid     | oid     |           |          | 
 usecreatedb  | boolean |           |          | 
 usesuper     | boolean |           |          | 
 userepl      | boolean |           |          | 
 usebypassrls | boolean |           |          | 
 passwd       | text    |           |          | 
 valuntil     | abstime |           |          | 
 useconfig    | text[]  |           |          |

Documentation: pg_user

pg_user (PostgreSQL 10)

                View "pg_catalog.pg_user"
    Column    |  Type   | Collation | Nullable | Default 
--------------+---------+-----------+----------+---------
 usename      | name    |           |          | 
 usesysid     | oid     |           |          | 
 usecreatedb  | boolean |           |          | 
 usesuper     | boolean |           |          | 
 userepl      | boolean |           |          | 
 usebypassrls | boolean |           |          | 
 passwd       | text    |           |          | 
 valuntil     | abstime |           |          | 
 useconfig    | text[]  |           |          |

Documentation: pg_user

pg_user (PostgreSQL 9.6)

     View "pg_catalog.pg_user"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 usename      | name    | 
 usesysid     | oid     | 
 usecreatedb  | boolean | 
 usesuper     | boolean | 
 userepl      | boolean | 
 usebypassrls | boolean | 
 passwd       | text    | 
 valuntil     | abstime | 
 useconfig    | text[]  |

Documentation: pg_user

pg_user (PostgreSQL 9.5)

     View "pg_catalog.pg_user"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 usename      | name    | 
 usesysid     | oid     | 
 usecreatedb  | boolean | 
 usesuper     | boolean | 
 userepl      | boolean | 
 usebypassrls | boolean | 
 passwd       | text    | 
 valuntil     | abstime | 
 useconfig    | text[]  |

Documentation: pg_user

pg_user (PostgreSQL 9.4)

     View "pg_catalog.pg_user"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 userepl     | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  |

Documentation: pg_user

pg_user (PostgreSQL 9.3)

     View "pg_catalog.pg_user"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 userepl     | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  |

Documentation: pg_user

pg_user (PostgreSQL 9.2)

     View "pg_catalog.pg_user"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 userepl     | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  |

Documentation: pg_user

pg_user (PostgreSQL 9.1)

     View "pg_catalog.pg_user"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 userepl     | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  |

Documentation: pg_user

pg_user (PostgreSQL 9.0)

     View "pg_catalog.pg_user"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  |

Documentation: pg_user

pg_user (PostgreSQL 8.4)

     View "pg_catalog.pg_user"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  | 
View definition:
 SELECT pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb, pg_shadow.usesuper, pg_shadow.usecatupd, '********'::text AS passwd, pg_shadow.valuntil, pg_shadow.useconfig
   FROM pg_shadow;

Documentation: pg_user

pg_user (PostgreSQL 8.3)

     View "pg_catalog.pg_user"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  | 
View definition:
 SELECT pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb, pg_shadow.usesuper, pg_shadow.usecatupd, '********'::text AS passwd, pg_shadow.valuntil, pg_shadow.useconfig
   FROM pg_shadow;

Documentation: pg_user

pg_user (PostgreSQL 8.2)

     View "pg_catalog.pg_user"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  | 
View definition:
 SELECT pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb, pg_shadow.usesuper, pg_shadow.usecatupd, '********'::text AS passwd, pg_shadow.valuntil, pg_shadow.useconfig
   FROM pg_shadow;

Documentation: pg_user

Change history

PostgreSQL 9.5
- column usecatupd removed (commit bb8582ab)
- column usebypassrls added (commit 491c029d)
PostgreSQL 9.1
- column userepl added (commit 9b8aff8c)
PostgreSQL 7.3
- column useconfig added (commit 1aac2c85)
- column usetrace removed (commit 739adf32)
PostgreSQL 6.3
- added, replacing the former pg_user table (commit 780068f8)

Examples

Sample row from pg_user:

postgres=# SELECT * FROM pg_user WHERE usename='postgres'\x\g\x
Expanded display is on.
-[ RECORD 1 ]+---------------------------
usename      | postgres
pg_authid|usesysid\\     | 10
usecreatedb  | t
usesuper     | t
userepl      | t
usebypassrls | t
passwd       | ********
valuntil     | 
useconfig    | {password_encryption=true}

References

PostgreSQL documentation: pg_user

Version charts

Useful overviews

Useful links

Contents

pg_user

Definition by PostgreSQL version

pg_user (PostgreSQL 15)

pg_user (PostgreSQL 14)

pg_user (PostgreSQL 13)

pg_user (PostgreSQL 12)

pg_user (PostgreSQL 11)

pg_user (PostgreSQL 10)

pg_user (PostgreSQL 9.6)

pg_user (PostgreSQL 9.5)

pg_user (PostgreSQL 9.4)

pg_user (PostgreSQL 9.3)

pg_user (PostgreSQL 9.2)

pg_user (PostgreSQL 9.1)

pg_user (PostgreSQL 9.0)

pg_user (PostgreSQL 8.4)

pg_user (PostgreSQL 8.3)

pg_user (PostgreSQL 8.2)

Change history

Examples

References

Categories

See also