Re: Copy Data Question - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: Copy Data Question
Date
Msg-id 20060626144900.72507.qmail@web31802.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Copy Data Question  (<operationsengineer1@yahoo.com>)
List pgsql-novice
> Richard, i'm not sure if you have seen one of my many
> posts today, but OOo was enclosing everything in ''.
> while unintuitive, i finally figured out i could
> delete either of two text delimiter options so that
> the text wasn't delimited - and the problem went away.

Yes that is true.  But for the sake of argument, the copy command sould have worked for values
enclosed in quotes as well.  Perhaps the QUOTE [ AS ] 'quote',  is your case the quote was a "'"
,  possibly you needed to specify QUOTE AS ''''.  Maybe quote escaping was required in the copy
command.

Regards,

Richard Broersma Jr.

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: really simple example of c-code and pqlib library
Next
From: "Garcia, Joshua"
Date:
Subject: Variable array sizes with PQexecParams