select all except for a specific column

Question

I have a table with more than 20 columns, I want to get all columns except for one which I'll use in a conditional expression.

SELECT s.* (BUT NOT column1), 
   CASE WHEN column1 is null THEN 1 ELSE 2 END AS column1 
from tb_sample s;

Can I achieve it in PostgreSQL given the logic above?

Answer 1

It may not be ideal, but you can use information_schema to get the columns and use the column to exclude in the where clause.

That gives you a list of all the column names you DO want, which you can copy/paste into your select query:

select textcat(column_name, ',')
from information_schema.columns
where table_name ='table_name' and column_name !='column_to_exclude';