when i am joining same tables to compare results(e.g. two different days processing) i should manually give the names to col names:

select n.join_column,
n.value n_value, o.value o_value
from awesome_values_day2 n
join awesome_values_day1 o on n.join_column = o.join_column;

It would be very usefull to format somehow column names which i want to select and add aliases like: alias || '_' || colname.



Please sign in to leave a comment.