From 311bcfc6b3acdd6fd152798c7f287ddf74fa2a98 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Tue, 16 Apr 2024 21:46:48 +0200 Subject: Adding upstream version 15.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/view-pg-shadow.html | 71 +++++++++++++++++++++++++++++++++++ 1 file changed, 71 insertions(+) create mode 100644 doc/src/sgml/html/view-pg-shadow.html (limited to 'doc/src/sgml/html/view-pg-shadow.html') diff --git a/doc/src/sgml/html/view-pg-shadow.html b/doc/src/sgml/html/view-pg-shadow.html new file mode 100644 index 0000000..28fe479 --- /dev/null +++ b/doc/src/sgml/html/view-pg-shadow.html @@ -0,0 +1,71 @@ + +54.25. pg_shadow
54.25. pg_shadow
Prev UpChapter 54. System ViewsHome Next

54.25. pg_shadow

+ The view pg_shadow exists for backwards + compatibility: it emulates a catalog that existed in + PostgreSQL before version 8.1. + It shows properties of all roles that are marked as + rolcanlogin in + pg_authid. +

+ The name stems from the fact that this table + should not be readable by the public since it contains passwords. + pg_user + is a publicly readable view on + pg_shadow that blanks out the password field. +

Table 54.25. pg_shadow Columns

+ Column Type +

+

+ Description +

+ usename name + (references pg_authid.rolname) +

+

+ User name +

+ usesysid oid + (references pg_authid.oid) +

+

+ ID of this user +

+ usecreatedb bool +

+

+ User can create databases +

+ usesuper bool +

+

+ User is a superuser +

+ userepl bool +

+

+ User can initiate streaming replication and put the system in and + out of backup mode. +

+ usebypassrls bool +

+

+ User bypasses every row-level security policy, see + Section 5.8 for more information. +

+ passwd text +

+

+ Password (possibly encrypted); null if none. See + pg_authid + for details of how encrypted passwords are stored. +

+ valuntil timestamptz +

+

+ Password expiry time (only used for password authentication) +

+ useconfig text[] +

+

+ Session defaults for run-time configuration variables +


Prev Up Next
54.24. pg_settings Home 54.26. pg_shmem_allocations
\ No newline at end of file -- cgit v1.2.3