postgresql - select all except for a specific column -


i have table more 20 columns, want columns except 1 i'll use in conditional expression.

select s.* (but not column1),     case when column1 null 1 else 2 end column1  tb_sample s; 

can achieve in postgresql given logic above?


Comments