How to update columns automatically in Postgres when we insert a new row?

Question

I have two columns in specific table in Postgres. When new row is inserted, I want to know how to automatically insert data in two column

So if I have a table insert table_name( nombre) values ('xxxxxx'). I want that creation_date(current day) and creation_user(current user in database) also inserted in the table.

Thanks for your help.

Best,

score 0 · Answer 1 · answered Dec 06 '21 at 20:27

0

if I understand your question correctly, that solves

"creation_date" timestamp not null default CURRENT_TIMESTAMP

see this question: here.

answered Dec 06 '21 at 20:27

Kopper

1
2

Thanks Kopper how Can do the same to the creation_user? – EdwinMald Dec 06 '21 at 21:15
I think we can use current_user from postgress... Thanks a lot. – EdwinMald Dec 06 '21 at 21:17

How to update columns automatically in Postgres when we insert a new row?

1 Answers1