#bin/bash

cd files

for x in $(ls *.csv); do
        if [[ $x != 'tmp_res_25001.csv' ]]; then
           PGPASSWORD=practice123 psql -U postgres -d messageTest -c "\copy msg from '$x' csv delimiter ';'" -h localhost -p 5432;
        fi
done