postgres - how to alter a column with timestamp?

Question

In postgre sql - How do I alter a column which has time stamp. Currently the column is defined as below -
creation_time timestamp(6) with time zone
and i want to make the above column not null also. So i have tried below but had no luck

ALTER TABLE my_table ALTER COLUMN creation_time TYPE timestamp(6) with time zone NOT NULL;

What is the correct syntax ?

"Had no luck".. what does that mean? Wrong syntax? or something else? Basically you can't alter a column to be not nullable, if it contains nulls, so my recomendation is - loss the null values and then try again. Also, after quick google search, this it the syntax: ALTER TABLE table_name ALTER COLUMN column_name SET NOT NULL; — sagi
– sagi, Commented Oct 20, 2021 at 11:46

klin · Accepted Answer · 2021-10-20 11:47:54Z

1

According to the documentation:

alter table my_table alter creation_time set not null;

answered Oct 20, 2021 at 11:47

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

postgres - how to alter a column with timestamp?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related