Re: Alter table fast - Mailing list pgsql-general

From shammat@gmx.net
Subject Re: Alter table fast
Date
Msg-id 9e3d705e-df1d-4d32-b5ba-718f492cb1cc@gmx.net
Whole thread Raw
In response to Re: Alter table fast  (veem v <veema0000@gmail.com>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: veem v
Date:
Subject: Re: Alter table fast
Next
From: Andy Hartman
Date:
Subject: Display Bytea field