pg_shadow

A system catalogue view showing properties of all roles that are marked as rolcanlogin in pg_authid

pg_shadow is a system catalogue view showing properties of all roles that are marked as rolcanlogin in pg_authid.

pg_shadow was created for backwards compatibility when the former pg_shadow table was replaced by pg_authid in PostgreSQL 8.1 (commit 7762619e).

Definition by PostgreSQL version

pg_shadow (PostgreSQL 14)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 13)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 12)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 11)

               View "pg_catalog.pg_shadow"
    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_shadow

pg_shadow (PostgreSQL 10)

               View "pg_catalog.pg_shadow"
    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_shadow

pg_shadow (PostgreSQL 9.6)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 9.5)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 9.4)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 9.3)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 9.2)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 9.1)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 9.0)

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

Documentation: pg_shadow

pg_shadow (PostgreSQL 8.4)

    View "pg_catalog.pg_shadow"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  | 
View definition:
 SELECT pg_authid.rolname AS usename, pg_authid.oid AS usesysid, pg_authid.rolcreatedb AS usecreatedb, pg_authid.rolsuper AS usesuper, pg_authid.rolcatupdate AS usecatupd, pg_authid.rolpassword AS passwd, pg_authid.rolvaliduntil::abstime AS valuntil, pg_authid.rolconfig AS useconfig
   FROM pg_authid
  WHERE pg_authid.rolcanlogin;

Documentation: pg_shadow

pg_shadow (PostgreSQL 8.3)

    View "pg_catalog.pg_shadow"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  | 
View definition:
 SELECT pg_authid.rolname AS usename, pg_authid.oid AS usesysid, pg_authid.rolcreatedb AS usecreatedb, pg_authid.rolsuper AS usesuper, pg_authid.rolcatupdate AS usecatupd, pg_authid.rolpassword AS passwd, pg_authid.rolvaliduntil::abstime AS valuntil, pg_authid.rolconfig AS useconfig
   FROM pg_authid
  WHERE pg_authid.rolcanlogin;

Documentation: pg_shadow

pg_shadow (PostgreSQL 8.2)

    View "pg_catalog.pg_shadow"
   Column    |  Type   | Modifiers 
-------------+---------+-----------
 usename     | name    | 
 usesysid    | oid     | 
 usecreatedb | boolean | 
 usesuper    | boolean | 
 usecatupd   | boolean | 
 passwd      | text    | 
 valuntil    | abstime | 
 useconfig   | text[]  | 
View definition:
 SELECT pg_authid.rolname AS usename, pg_authid.oid AS usesysid, pg_authid.rolcreatedb AS usecreatedb, pg_authid.rolsuper AS usesuper, pg_authid.rolcatupdate AS usecatupd, pg_authid.rolpassword AS passwd, pg_authid.rolvaliduntil::abstime AS valuntil, pg_authid.rolconfig AS useconfig
   FROM pg_authid
  WHERE pg_authid.rolcanlogin;

Documentation: pg_shadow

Change history

PostgreSQL 9.5
- column usecatupd removed (commit bb8582ab)
- column usebypassrls added (commit 491c029d)
PostgreSQL 9.1
- column userepl added (commit 9b8aff8c)
PostgreSQL 8.1
- added (commit 7762619e)

References

PostgreSQL documentation: pg_shadow

Version charts

Useful overviews

Useful links

Contents

pg_shadow

Definition by PostgreSQL version

pg_shadow (PostgreSQL 14)

pg_shadow (PostgreSQL 13)

pg_shadow (PostgreSQL 12)

pg_shadow (PostgreSQL 11)

pg_shadow (PostgreSQL 10)

pg_shadow (PostgreSQL 9.6)

pg_shadow (PostgreSQL 9.5)

pg_shadow (PostgreSQL 9.4)

pg_shadow (PostgreSQL 9.3)

pg_shadow (PostgreSQL 9.2)

pg_shadow (PostgreSQL 9.1)

pg_shadow (PostgreSQL 9.0)

pg_shadow (PostgreSQL 8.4)

pg_shadow (PostgreSQL 8.3)

pg_shadow (PostgreSQL 8.2)

Change history

References

Categories

See also