大网数据广告活动
服务器运维问答

Automatically insert the login name when new row created in postgres

· 52CE 我爱测

In Postgres 10, is it possible to automatically insert the name of the login role when creating a new row? i.e. I'm already using a timestamp to track the date that a row was created. It would also be useful to see which user cre…

问题原文

原帖链接 · Jesse Reilly · CC BY-SA 3.0

In Postgres 10, is it possible to automatically insert the name of the login role when creating a new row?

i.e. I'm already using a timestamp to track the date that a row was created. It would also be useful to see which user created the row.

Thanks!

已采纳解答

原帖链接 · Craig Ringer · CC BY-SA 3.0

Yes. Just make the column's default session_user. (It's a pseudo-variable, not a function call).

If you want to prevent a user from overriding it, you should also make sure to GRANT write permissions to the table on a per-column basis, not to the table as a whole, and make sure the regular operating user is not the table owner.

Or alternately, have a BEFORE INSERT OR UPDATE trigger that sets NEW.the_column := session_user.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2017-10-26)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。