Import a CSV file into postgres with dynamic paths

import.sh

#!/bin/bash -e

SAMPLES_PATH="$(pwd)/samples.csv"

uname="$(uname)"

# When on Windows, you need to pass the path as c:/path/to/file
# rather than /c/path/to/file (as expected by PostgreSQL).
if [[ "$uname" != "Linux" && "$uname" != "Darwin" ]]; then
  # remove the leading slash and replace the second slash with :/
  SAMPLES_PATH="$(echo $SAMPLES_PATH | sed 's|/||;s|/|:/|')"
fi

psql <<- EOF
\\copy samples from '$SAMPLES_PATH' csv header;
EOF