Re: Support for Physical Column Reordering in PG

2025-05-18 Thread Tom Lane
Srinath Reddy Sadipiralla writes: > So is making a patch to have a sql command to reposition the column like > other databases makes sense? thoughts ? There have been multiple attempts over the years to separate physical and logical column positions. They've failed :-(. You might trawl the mail

Support for Physical Column Reordering in PG

2025-05-18 Thread Srinath Reddy Sadipiralla
Hi,is there any better way to change the order of a column except 1) creating a new table and do insert with select with rearranged columns 2) using views use case: there are cases where we might be using delta compression between tuples we have a table like "create table temp(x bigint,y char(3),z