Alter timestamptz column to timestamp, without re-writing the table

1 vote

1 answer

162 views

postgresql postgresql-performance alter-table timestamp timezone

                          I'm using Postgres Debezium source connectors, which does not support columns with timezone . I want to convert a table column from type from timestamptz to timestamp. 

Postgres table stores data in UTC time zone only, ideally there should not be any value change from this conversion. What is the best way to achieve this?

Asked by Akshay Bande (113 rep)

Jul 4, 2024, 03:08 AM
Last activity: Jul 5, 2024, 05:01 AM

Alter timestamptz column to timestamp, without re-writing the table

Related Questions