• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

Useful links

pg_shadow (table)

pg_shadow was a system catalogue table containing information about database users.

pg_shadow was added in PostgreSQL 6.3 (commit 780068f8, replacing pg_user), and replaced in PostgreSQL 8.1 by pg_authid, with pg_shadow becoming a system catalogue view (commit 7762619e).

Change history

• PostgreSQL 8.1
  • replaced by pg_authid and converted to a view (commit 7762619e)
• PostgreSQL 7.3
  • column usetrace removed (commit 739adf32)
• PostgreSQL 6.3
  • added (commit 780068f8)

References

Categories

See also