index

export PGPASSWORD=cat XY; ~~~~ psql -c “SELECT session_date,shot_no,ROUND(t_plasma_duration,3),"U_loop_mean", "Ip_mean" FROM shots WHERE (shot_no > 31150) AND (t_plasma_duration != -1) AND (tags IS NULL OR tags NOT LIKE ‘score=ko’) ORDER BY t_plasma_duration DESC LIMIT 30;” -qAt -U golem golem_database

psql -c “UPDATE shots SET tags=‘score=ko’ WHERE shot_no=36200” -qAt -U golem golem_database

#REPLACE field # Oba Zaroven for DB in shots sessions;do psql -c “UPDATE public.$DB SET session_setup = replace (session_setup, ‘21_SOC_MatyasP_PetrS_PetrM’, ‘21_SOC_MatyasP’)” -qAt -U golem golem_database;done

~~~~