PostGreSQL - Loader Configuration
PostGreSQL UserDB datasource configuration
LoaderCommand | <CAMPAIGN_HOME>/partitions/partition1/load.sh <PASSWORD> <TABLENAME> <DATAFILE> |
LoaderCommandForAppend | <CAMPAIGN_HOME>/partitions/partition1/load.sh <PASSWORD> <TABLENAME> <DATAFILE> |
LoaderDelimiter | , |
LoaderDelimiterForAppend | , |
PostGreSQL Loader script :
[hcluser@COMP-5059-1 partition1]$ cat load.sh
export PGPASSWORD="$1"
cp $3 /tmp/
/usr/pgsql-13/bin/psql -U autodcc -d autodcc -c "\COPY $2 FROM '$3' DELIMITER ','
CSV HEADER;"
exit $?