Andrej Ricnik-Bay wrote:
On 3/20/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
The source file comes from extracts on our main application which sits
inside an in-house pretending-to-be-a-dbms file system. The content of
these extracts would be difficult to change - the extract program would
need to parse the data looking for quotes and preceed them with the
necessary escape character.
Not being a proper database dump it's not a simple matter of flicking a
switch to get it to include the escape character. The way the extracts
are written would require a few dozen lines of code to each extract, and
theres about 40ish extracts.
Plus I don't maintain that side of our code, and those that do can be a
bit lazy and I'd likely be waiting months to get it done - if they even
decide to do it.
Pipe it through sed and replace the Carets with TABS?
sed 's/^/\t/g' c:/temp/autodrs_deal_lines.txt >
c:/temp/autodrs_deal_lines.tab
Then use copy like so:
\copy table from 'c:/temp/autodrs_deal_lines.tab' delimiter E'\t' null ''
Cheers,
Andrej
The data contains tabs... don't ask why... I don't have a clue :P
I'll do something along the lines of sed... but not with sed, I'll use
the command line interpreter on the OpenVMS systems where the extracts
run. I just thought there might have been a quicker way to switch it off
in the copy command, i.e. specifying "quote none" as one of the
parameters to the command. I guess not...
Thanks for the pointers.
P.
--
Paul Lambert
Database Administrator
AutoLedgers
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
