Possible to automatically create a timestamp record on insert with Postgres?

Question

I've just created a Postgres database and table ('users'). My table has a created_at column of type:

TIMESTAMP WITH TIME ZONE NOT NULL;

I basically want to use this column to keep track of when a new user is created. Is there a way to have Postgres automatically update this with each insert or do I have to supply it a value for this on every insert?

(I want to say when using it before with Sequelize, it created this automatically - so wondering if this was done through Sequelize as a default when inserting).

Thank you!

You might also want to look at this answer, which talks about how to create a trigger based on update, create, or other events. These types of triggers can be used to update/create a timestamp when a row is created, or any time it's updated: stackoverflow.com/questions/31147796/… — Matt Morgan
– Matt Morgan, Commented Dec 23, 2016 at 20:52
Possible duplicate of How do I automatically update a timestamp in PostgreSQL — faintsignal
– faintsignal, Commented Dec 23, 2016 at 23:00

faintsignal · Accepted Answer · 2016-12-23 20:51:17Z

20

You can declare a timestamp field to automatically be filled with the current time on INSERT by including the DEFAULT now() clause in your column definition.

answered Dec 23, 2016 at 20:51

faintsignal

1,8363 gold badges22 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Possible to automatically create a timestamp record on insert with Postgres?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related