Databases what type of field to choose?

Question

PostgreSQL

Hello, I will have a field in which I will enter the timestamp in milliseconds, which will store the date the entry was added to the database
. I use postgres. To do this, when inserting ,
I use the following code in Python: he swears, says that the value of the field type is too large, I use Int

Answer 1

Greetings!
Why insert a time value from Python? It is much more reliable that the DBMS itself sets the current timestamp when inserting a record into the table.
To do this, you just need to add the created_at field to the table with default now:

create table mytable 
(
...
created_at timestamp not null default now()
);

Answer 2

int(round(time.time() * 1000))
Somehow it doesn't look like milliseconds)
https://www.postgresql.org/docs/9.1/static/datatyp...
see the table and choose.