On Feb 8, 2008 9:06 AM, Andrej Kastrin <[EMAIL PROTECTED]> wrote:
> The answer is simple no. I know I can to some preprocessing on input
> files using awk, sed etc. but don't want to change the structure of the
> file.
If the problem is that you have | characters in your data, then can
you change
Andrej Kastrin wrote:
Colin Wetherbee wrote:
Andrej Kastrin wrote:
||5354235||,||some text...|| ||1234567||,||some text...||
||1234568||,||some text...||
The sql statement I defined was:
COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS
'||';
but the error:
ERROR: COPY quo
The answer is simple no. I know I can to some preprocessing on input
files using awk, sed etc. but don't want to change the structure of the
file.
Colin Wetherbee wrote:
Andrej Kastrin wrote:
||5354235||,||some text...|| ||1234567||,||some text...||
||1234568||,||some text...||
The sql stat
Andrej Kastrin wrote:
||5354235||,||some text...|| ||1234567||,||some text...||
||1234568||,||some text...||
The sql statement I defined was:
COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS
'||';
but the error:
ERROR: COPY quote must be a single ASCII character
I guess I'
Dear all,
I have to copy the file with the following delimiters into the database:
||5354235||,||some text...||
||1234567||,||some text...||
||1234568||,||some text...||
The sql statement I defined was:
COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS '||';
but the error:
ER