score:1

Accepted answer

you can name the columns by defining column aliases:

select to_char((nivo_prelivnik.date1 + nivo_prelivnik.time1), 'dd/mm/yyyy hh24:mi:ss') as col1,
       round(cast(izch_nivo*100 as numeric), 1) as col2,
       round(cast(debit as numeric), 3) as col3
from nivo_prelivnik;

note the use of as after the expression. you can then refer to these in the result set.


Related Query