如何查看数据库用户的创建时间？

答：通过系统表PG_AUTH_HISTORY中的passwordtime字段查看用户密码的初始设置时间，即该用户的创建时间。

gaussdb=# SELECT t1.usename, t1.usesysid, min(t2.passwordtime) as create_time FROM pg_user t1, pg_auth_history t2 WHERE t1.usename='jerry' AND t1.usesysid = t2.roloid GROUP BY t1.usename, t1.usesysid;
 usename | usesysid |          create_time          
---------+----------+-------------------------------
 jerry   |    27311 | 2024-07-23 14:46:08.284336+08
(1 row)