pg_roles

A system catalogue view listing available roles

pg_roles is a system catalogue view listing available roles

pg_roles was added in PostgreSQL 8.1 (commit 7762619e).

Definition by PostgreSQL version

pg_roles (PostgreSQL 15)

                         View "pg_catalog.pg_roles"
     Column     |           Type           | Collation | Nullable | Default 
----------------+--------------------------+-----------+----------+---------
 rolname        | name                     |           |          | 
 rolsuper       | boolean                  |           |          | 
 rolinherit     | boolean                  |           |          | 
 rolcreaterole  | boolean                  |           |          | 
 rolcreatedb    | boolean                  |           |          | 
 rolcanlogin    | boolean                  |           |          | 
 rolreplication | boolean                  |           |          | 
 rolconnlimit   | integer                  |           |          | 
 rolpassword    | text                     |           |          | 
 rolvaliduntil  | timestamp with time zone |           |          | 
 rolbypassrls   | boolean                  |           |          | 
 rolconfig      | text[]                   | C         |          | 
 oid            | oid                      |           |          |

Documentation: pg_roles

pg_roles (PostgreSQL 14)

                         View "pg_catalog.pg_roles"
     Column     |           Type           | Collation | Nullable | Default 
----------------+--------------------------+-----------+----------+---------
 rolname        | name                     |           |          | 
 rolsuper       | boolean                  |           |          | 
 rolinherit     | boolean                  |           |          | 
 rolcreaterole  | boolean                  |           |          | 
 rolcreatedb    | boolean                  |           |          | 
 rolcanlogin    | boolean                  |           |          | 
 rolreplication | boolean                  |           |          | 
 rolconnlimit   | integer                  |           |          | 
 rolpassword    | text                     |           |          | 
 rolvaliduntil  | timestamp with time zone |           |          | 
 rolbypassrls   | boolean                  |           |          | 
 rolconfig      | text[]                   | C         |          | 
 oid            | oid                      |           |          |

Documentation: pg_roles

pg_roles (PostgreSQL 13)

                         View "pg_catalog.pg_roles"
     Column     |           Type           | Collation | Nullable | Default 
----------------+--------------------------+-----------+----------+---------
 rolname        | name                     |           |          | 
 rolsuper       | boolean                  |           |          | 
 rolinherit     | boolean                  |           |          | 
 rolcreaterole  | boolean                  |           |          | 
 rolcreatedb    | boolean                  |           |          | 
 rolcanlogin    | boolean                  |           |          | 
 rolreplication | boolean                  |           |          | 
 rolconnlimit   | integer                  |           |          | 
 rolpassword    | text                     |           |          | 
 rolvaliduntil  | timestamp with time zone |           |          | 
 rolbypassrls   | boolean                  |           |          | 
 rolconfig      | text[]                   | C         |          | 
 oid            | oid                      |           |          |

Documentation: pg_roles

pg_roles (PostgreSQL 12)

                         View "pg_catalog.pg_roles"
     Column     |           Type           | Collation | Nullable | Default 
----------------+--------------------------+-----------+----------+---------
 rolname        | name                     |           |          | 
 rolsuper       | boolean                  |           |          | 
 rolinherit     | boolean                  |           |          | 
 rolcreaterole  | boolean                  |           |          | 
 rolcreatedb    | boolean                  |           |          | 
 rolcanlogin    | boolean                  |           |          | 
 rolreplication | boolean                  |           |          | 
 rolconnlimit   | integer                  |           |          | 
 rolpassword    | text                     |           |          | 
 rolvaliduntil  | timestamp with time zone |           |          | 
 rolbypassrls   | boolean                  |           |          | 
 rolconfig      | text[]                   | C         |          | 
 oid            | oid                      |           |          |

Documentation: pg_roles

pg_roles (PostgreSQL 11)

                         View "pg_catalog.pg_roles"
     Column     |           Type           | Collation | Nullable | Default 
----------------+--------------------------+-----------+----------+---------
 rolname        | name                     |           |          | 
 rolsuper       | boolean                  |           |          | 
 rolinherit     | boolean                  |           |          | 
 rolcreaterole  | boolean                  |           |          | 
 rolcreatedb    | boolean                  |           |          | 
 rolcanlogin    | boolean                  |           |          | 
 rolreplication | boolean                  |           |          | 
 rolconnlimit   | integer                  |           |          | 
 rolpassword    | text                     |           |          | 
 rolvaliduntil  | timestamp with time zone |           |          | 
 rolbypassrls   | boolean                  |           |          | 
 rolconfig      | text[]                   |           |          | 
 oid            | oid                      |           |          |

Documentation: pg_roles

pg_roles (PostgreSQL 10)

                         View "pg_catalog.pg_roles"
     Column     |           Type           | Collation | Nullable | Default 
----------------+--------------------------+-----------+----------+---------
 rolname        | name                     |           |          | 
 rolsuper       | boolean                  |           |          | 
 rolinherit     | boolean                  |           |          | 
 rolcreaterole  | boolean                  |           |          | 
 rolcreatedb    | boolean                  |           |          | 
 rolcanlogin    | boolean                  |           |          | 
 rolreplication | boolean                  |           |          | 
 rolconnlimit   | integer                  |           |          | 
 rolpassword    | text                     |           |          | 
 rolvaliduntil  | timestamp with time zone |           |          | 
 rolbypassrls   | boolean                  |           |          | 
 rolconfig      | text[]                   |           |          | 
 oid            | oid                      |           |          |

Documentation: pg_roles

pg_roles (PostgreSQL 9.6)

              View "pg_catalog.pg_roles"
     Column     |           Type           | Modifiers 
----------------+--------------------------+-----------
 rolname        | name                     | 
 rolsuper       | boolean                  | 
 rolinherit     | boolean                  | 
 rolcreaterole  | boolean                  | 
 rolcreatedb    | boolean                  | 
 rolcanlogin    | boolean                  | 
 rolreplication | boolean                  | 
 rolconnlimit   | integer                  | 
 rolpassword    | text                     | 
 rolvaliduntil  | timestamp with time zone | 
 rolbypassrls   | boolean                  | 
 rolconfig      | text[]                   | 
 oid            | oid                      |

Documentation: pg_roles

pg_roles (PostgreSQL 9.5)

              View "pg_catalog.pg_roles"
     Column     |           Type           | Modifiers 
----------------+--------------------------+-----------
 rolname        | name                     | 
 rolsuper       | boolean                  | 
 rolinherit     | boolean                  | 
 rolcreaterole  | boolean                  | 
 rolcreatedb    | boolean                  | 
 rolcanlogin    | boolean                  | 
 rolreplication | boolean                  | 
 rolconnlimit   | integer                  | 
 rolpassword    | text                     | 
 rolvaliduntil  | timestamp with time zone | 
 rolbypassrls   | boolean                  | 
 rolconfig      | text[]                   | 
 oid            | oid                      |

Documentation: pg_roles

pg_roles (PostgreSQL 9.4)

              View "pg_catalog.pg_roles"
     Column     |           Type           | Modifiers 
----------------+--------------------------+-----------
 rolname        | name                     | 
 rolsuper       | boolean                  | 
 rolinherit     | boolean                  | 
 rolcreaterole  | boolean                  | 
 rolcreatedb    | boolean                  | 
 rolcatupdate   | boolean                  | 
 rolcanlogin    | boolean                  | 
 rolreplication | boolean                  | 
 rolconnlimit   | integer                  | 
 rolpassword    | text                     | 
 rolvaliduntil  | timestamp with time zone | 
 rolconfig      | text[]                   | 
 oid            | oid                      |

Documentation: pg_roles

pg_roles (PostgreSQL 9.3)

              View "pg_catalog.pg_roles"
     Column     |           Type           | Modifiers 
----------------+--------------------------+-----------
 rolname        | name                     | 
 rolsuper       | boolean                  | 
 rolinherit     | boolean                  | 
 rolcreaterole  | boolean                  | 
 rolcreatedb    | boolean                  | 
 rolcatupdate   | boolean                  | 
 rolcanlogin    | boolean                  | 
 rolreplication | boolean                  | 
 rolconnlimit   | integer                  | 
 rolpassword    | text                     | 
 rolvaliduntil  | timestamp with time zone | 
 rolconfig      | text[]                   | 
 oid            | oid                      |

Documentation: pg_roles

pg_roles (PostgreSQL 9.2)

              View "pg_catalog.pg_roles"
     Column     |           Type           | Modifiers 
----------------+--------------------------+-----------
 rolname        | name                     | 
 rolsuper       | boolean                  | 
 rolinherit     | boolean                  | 
 rolcreaterole  | boolean                  | 
 rolcreatedb    | boolean                  | 
 rolcatupdate   | boolean                  | 
 rolcanlogin    | boolean                  | 
 rolreplication | boolean                  | 
 rolconnlimit   | integer                  | 
 rolpassword    | text                     | 
 rolvaliduntil  | timestamp with time zone | 
 rolconfig      | text[]                   | 
 oid            | oid                      |

Documentation: pg_roles

pg_roles (PostgreSQL 9.1)

              View "pg_catalog.pg_roles"
     Column     |           Type           | Modifiers 
----------------+--------------------------+-----------
 rolname        | name                     | 
 rolsuper       | boolean                  | 
 rolinherit     | boolean                  | 
 rolcreaterole  | boolean                  | 
 rolcreatedb    | boolean                  | 
 rolcatupdate   | boolean                  | 
 rolcanlogin    | boolean                  | 
 rolreplication | boolean                  | 
 rolconnlimit   | integer                  | 
 rolpassword    | text                     | 
 rolvaliduntil  | timestamp with time zone | 
 rolconfig      | text[]                   | 
 oid            | oid                      |

Documentation: pg_roles

pg_roles (PostgreSQL 9.0)

              View "pg_catalog.pg_roles"
    Column     |           Type           | Modifiers 
---------------+--------------------------+-----------
 rolname       | name                     | 
 rolsuper      | boolean                  | 
 rolinherit    | boolean                  | 
 rolcreaterole | boolean                  | 
 rolcreatedb   | boolean                  | 
 rolcatupdate  | boolean                  | 
 rolcanlogin   | boolean                  | 
 rolconnlimit  | integer                  | 
 rolpassword   | text                     | 
 rolvaliduntil | timestamp with time zone | 
 rolconfig     | text[]                   | 
 oid           | oid                      |

Documentation: pg_roles

pg_roles (PostgreSQL 8.4)

              View "pg_catalog.pg_roles"
    Column     |           Type           | Modifiers 
---------------+--------------------------+-----------
 rolname       | name                     | 
 rolsuper      | boolean                  | 
 rolinherit    | boolean                  | 
 rolcreaterole | boolean                  | 
 rolcreatedb   | boolean                  | 
 rolcatupdate  | boolean                  | 
 rolcanlogin   | boolean                  | 
 rolconnlimit  | integer                  | 
 rolpassword   | text                     | 
 rolvaliduntil | timestamp with time zone | 
 rolconfig     | text[]                   | 
 oid           | oid                      | 
View definition:
 SELECT pg_authid.rolname, pg_authid.rolsuper, pg_authid.rolinherit, pg_authid.rolcreaterole, pg_authid.rolcreatedb, pg_authid.rolcatupdate, pg_authid.rolcanlogin, pg_authid.rolconnlimit, '********'::text AS rolpassword, pg_authid.rolvaliduntil, pg_authid.rolconfig, pg_authid.oid
   FROM pg_authid;

Documentation: pg_roles

pg_roles (PostgreSQL 8.3)

              View "pg_catalog.pg_roles"
    Column     |           Type           | Modifiers 
---------------+--------------------------+-----------
 rolname       | name                     | 
 rolsuper      | boolean                  | 
 rolinherit    | boolean                  | 
 rolcreaterole | boolean                  | 
 rolcreatedb   | boolean                  | 
 rolcatupdate  | boolean                  | 
 rolcanlogin   | boolean                  | 
 rolconnlimit  | integer                  | 
 rolpassword   | text                     | 
 rolvaliduntil | timestamp with time zone | 
 rolconfig     | text[]                   | 
 oid           | oid                      | 
View definition:
 SELECT pg_authid.rolname, pg_authid.rolsuper, pg_authid.rolinherit, pg_authid.rolcreaterole, pg_authid.rolcreatedb, pg_authid.rolcatupdate, pg_authid.rolcanlogin, pg_authid.rolconnlimit, '********'::text AS rolpassword, pg_authid.rolvaliduntil, pg_authid.rolconfig, pg_authid.oid
   FROM pg_authid;

Documentation: pg_roles

pg_roles (PostgreSQL 8.2)

              View "pg_catalog.pg_roles"
    Column     |           Type           | Modifiers 
---------------+--------------------------+-----------
 rolname       | name                     | 
 rolsuper      | boolean                  | 
 rolinherit    | boolean                  | 
 rolcreaterole | boolean                  | 
 rolcreatedb   | boolean                  | 
 rolcatupdate  | boolean                  | 
 rolcanlogin   | boolean                  | 
 rolconnlimit  | integer                  | 
 rolpassword   | text                     | 
 rolvaliduntil | timestamp with time zone | 
 rolconfig     | text[]                   | 
 oid           | oid                      | 
View definition:
 SELECT pg_authid.rolname, pg_authid.rolsuper, pg_authid.rolinherit, pg_authid.rolcreaterole, pg_authid.rolcreatedb, pg_authid.rolcatupdate, pg_authid.rolcanlogin, pg_authid.rolconnlimit, '********'::text AS rolpassword, pg_authid.rolvaliduntil, pg_authid.rolconfig, pg_authid.oid
   FROM pg_authid;

Documentation: pg_roles

Change history

PostgreSQL 9.5
- column rolcatupdate removed (commit bb8582ab)
- column rolbypassrls added (commit 491c029d)
PostgreSQL 9.1
- column rolreplication added (commit 9b8aff8c)
PostgreSQL 8.1
- added (commit 7762619e)

References

PostgreSQL documentation: pg_roles

Version charts

Useful overviews

Useful links

Contents

pg_roles

Definition by PostgreSQL version

pg_roles (PostgreSQL 15)

pg_roles (PostgreSQL 14)

pg_roles (PostgreSQL 13)

pg_roles (PostgreSQL 12)

pg_roles (PostgreSQL 11)

pg_roles (PostgreSQL 10)

pg_roles (PostgreSQL 9.6)

pg_roles (PostgreSQL 9.5)

pg_roles (PostgreSQL 9.4)

pg_roles (PostgreSQL 9.3)

pg_roles (PostgreSQL 9.2)

pg_roles (PostgreSQL 9.1)

pg_roles (PostgreSQL 9.0)

pg_roles (PostgreSQL 8.4)

pg_roles (PostgreSQL 8.3)

pg_roles (PostgreSQL 8.2)

Change history

References

Categories

See also