This is a very simple problem, I am using the psql terminal command COPY as shown bellow
COPY tbname FROM '/tmp/file.csv' delimiter '|' csv;
However this file.csv contains data such as
as well as
I tried to use the double quote to escape the quotes as the Postgres site suggested
random|stuff|32"" random|other ""stuff""|15
This seems to remove the quotes completely which I don't want.
Is there a way to get the import to just treat these quotes as regular characters so that they appear in the database as they do in the csv file?