Am 09.01.25 um 20:17 schrieb veem v:
Out of curiosity, why NUMERIC(15,0) instead of BIGINT?It's for aligning the database column types to the data model and it's happening across all the upstream downstream systems. I was thinking if this can be made faster with the single line alter statement "Alter table <table_name> alter column <column_name> type numeric(15,0) USING <column_name>::NUMERIC(15,0);"
Hmm, I would rather change numeric(15,0) to bigint if I had to "align" types across systems.
