Hi Folks !
Is there a way to parse, within pgsql, a .csv file coming from MS-SQL so that
it could be read into a table with COPY ?
The file has too many line breaks like and #-character marking the actual
line break:
prod_id;prod_name;EAN;xxx;xxx;xxx;
- prod description
- prod description#
prod_id;prod_name;EAN; ...#
How could this be parsed to look like this:
prod_id;prod_name;EAN;xxx;xxx;xxx; - prod description - prod description#
prod_id;prod_name;EAN; ...#
Any hints and advice much appreciated.
BR,
aarni
