Hi,In my migration script while I am using mysqldump to dump my MySQL database and PostgreSQL COPY command to copy the data files to PostgreSQL db, I am getting error cause of the newline in the fields
Mysqldump command:
Mysqldump –u username -p --no-create-info
--skip-triggers --skip-comments --fields-terminated-by =,
--lines-terminated-by=\n –TC:\tmp –r UTF8 dbname
PostgreSQL COPY...
User Profile
Collapse
-
smusabbir started a topic How to process new line in fields while copying data from a file using COPY commandin PostgreSQLHow to process new line in fields while copying data from a file using COPY command
No activity results to display
Show More