tag:blogger.com,1999:blog-2752642124667077789.post2190099678647916093..comments2023-12-06T18:23:27.072+10:30Comments on That Guy From Delhi: Which SQL causes a Table Rewrite in Postgres?Robins Tharakanhttp://www.blogger.com/profile/02748267202194708735noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2752642124667077789.post-52006652165341689072023-03-10T23:22:59.002+10:302023-03-10T23:22:59.002+10:30@intgr - Appreciate the feedback. Updated the grid...@intgr - Appreciate the feedback. Updated the grid with said feedback.Robins Tharakanhttps://www.blogger.com/profile/02748267202194708735noreply@blogger.comtag:blogger.com,1999:blog-2752642124667077789.post-18057591398572531482021-07-04T16:35:40.538+09:302021-07-04T16:35:40.538+09:30This comment has been removed by a blog administrator.James Zicrovhttps://www.blogger.com/profile/00094356083987556970noreply@blogger.comtag:blogger.com,1999:blog-2752642124667077789.post-30264795149377370202021-01-08T03:51:46.791+10:302021-01-08T03:51:46.791+10:30Additionally, `ALTER TABLE ALTER COLUMN TYPE TEXT`...Additionally, `ALTER TABLE ALTER COLUMN TYPE TEXT` can avoid a rewrite if the old type is binary compatible. For example when increasing the length limit of VARCHAR(n), or converting VARCHAR(n) to TEXT.<br />intgrhttps://www.blogger.com/profile/14696232909148155489noreply@blogger.com