On 24 Mar 2014, at 5:32, Rajeev rastogi wrote:
> On 21st March 2014, Ashmita Jain Wrote:
>
> >It is taking date as an empty string.
> >Try defining the empty field as ‘\N’ in your source file.
>
> ‘\N’ in copy source file always results into an empty string (unless
> something written in ne
On 21st March 2014, Ashmita Jain Wrote:
>It is taking date as an empty string.
>Try defining the empty field as '\N' in your source file.
'\N' in copy source file always results into an empty string (unless something
written in new line), which is correct only.
So COPY from such source file will
Bill Todd <[EMAIL PROTECTED]> writes:
> I am beginning to suspect this is impossible.
That's correct: see the COPY reference page. A quoted value is never
considered to match the NULL string.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgr
Joshua D. Drake wrote:
On Fri, 2008-12-05 at 12:00 -0700, Bill Todd wrote:
Joshua D. Drake wrote:
On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:
null as IS NULL results in the following error.
ERROR: syntax error at or near "is"
LINE 5: null as is null
On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:
> Using 8.3.3 I am trying to import a CSV file using the following copy
> command.
>
> copy billing.contact from 'c:/export/contact.csv'
> with delimiter as ','
> null as ''
> csv quote as '"';
>
> The following record record causes an error be
