I am trying to use the copy command in postgres to upload the CSV file into the database using the below command
psql -h 127.0.0.1 -d target -U postgres -c "\copy test FROM 'E:\pg_test\test.csv' delimiter ';'"
Whereas when using the multiple delimiter following error is observed.
ERROR: COPY delimiter must be a single one-byte character
Is there a way to use multiple delimiter? Input file (CSV) couldn't be changed as the user doesn't have write access