Left Join postgres SQL duplicate ON column
Solution 1:
The recommended solution is to not use select * but only select those columns that you really need.
If you want to stick with select * you can join with the using() clause instead. This will then return the index column only once.
select *
from ltc_ts lt
left join ltc_stock_metrics lsm using ("index")