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

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

Python Tornado package error when running server -

Qt QGraphicsScene is not accessable from QGraphicsView (on Qt 5.6.1) -