I am in the process of moving a FoxPro based system to PostgreSQL. We have several tables that have memo fields which contain carriage returns and line feeds that I need to preserve. I thought if I converted these into the appropriate \r and \n codes that they would be imported as carriage returns and line feeds, but instead they are stored in the database as \r and \n.
The command I am using is: copy main.company from E'f:\company.csv" DELIMITER "|" CSV HEADER QUOTE '"' ESCAPE E'\\'; The command imports all of the data, but I want the escaped codes to be expanded to their actual values. Can anyone assist me with this? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
