Redshift Observatory

System Table Tracker

System view pg_catalog.pg_user version 1.0.81462 / 2025-01-09

schema	name	column	data type
pg_catalog	pg_user	passwd	varchar(8)
pg_catalog	pg_user	usecatupd	bool
pg_catalog	pg_user	useconfig	text[]
pg_catalog	pg_user	usecreatedb	bool
pg_catalog	pg_user	usename	name
pg_catalog	pg_user	usesuper	bool
pg_catalog	pg_user	usesysid	int4
pg_catalog	pg_user	valuntil	abstime

View Text

SELECT pg_shadow.usename,
       pg_shadow.usesysid,
       pg_shadow.usecreatedb,
       pg_shadow.usesuper,
       pg_shadow.usecatupd,
       CAST('********' AS varchar) AS passwd,
       pg_shadow.valuntil,
       pg_shadow.useconfig
FROM pg_shadow
WHERE pg_shadow.usename !~~ CAST('f346c9b8%' AS text)
  AND pg_shadow.usename !~~ CAST('ds:%' AS text)

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers