copy.sh 233 B

1234567891011
  1. #!/bin/bash
  2. export PGPASSWORD=$4
  3. host=$1
  4. port=$2
  5. username=$3
  6. dbname=$5
  7. table=$6
  8. filename=$7
  9. columns=$8
  10. psql -h "${host}" -p "${port}" -U "${username}" -d "${dbname}" -c "\\copy ${table} ${columns} from ${filename} with csv header;"