Handling/DataMining/pSQL/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 BETWEEN 31150 AND 36373) AND (t_plasma_duration != -1) ORDER BY t_plasma_duration  DESC LIMIT 30;" -qAt -U golem golem_database