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,

Kopper · Accepted Answer · 2021-12-06 20:27:38Z

0

if I understand your question correctly, that solves

"creation_date" timestamp not null default CURRENT_TIMESTAMP

see this question: here.

answered Dec 6, 2021 at 20:27

Kopper

12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

EdwinMald Over a year ago

Thanks Kopper how Can do the same to the creation_user?

EdwinMald Over a year ago

I think we can use current_user from postgress... Thanks a lot.

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related