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

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

pg_shadow (table)

A former system table containing information about database users

This entry relates to a PostgreSQL feature, application/utility, website or other subject which is no longer available/maintained.

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

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

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

PostgreSQL 8.0 documentation: pg_shadow

Categories

See also

pg_authid, pg_group, pg_shadow