Redshift Research Project

System Table Tracker

System view pg_catalog.pg_user_info version 1.0.67699 / 2024-05-26

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

View Text

SELECT pg_shadow.usename,
       CAST('********' AS varchar) AS passwd,
         WHEN pse_col1.value = CAST(- CAST(1 AS smallint) AS text)
           THEN CAST('UNLIMITED' AS text)
         ELSE pse_col1.value
       END AS useconnlimit
FROM pg_shadow
     LEFT JOIN pg_shadow_extended AS pse_col1 ON pg_shadow.usesysid = pse_col1.sysid
                                             AND pse_col1.colnum = 1
WHERE pg_shadow.usename !~~ CAST('f346c9b8%' AS text)
  AND pg_shadow.usename !~~ CAST('ds:%' AS text)

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers