Re: Alter table fast

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.