Postgres Pro
Downloads
Home   >   mailing lists

How to load nulls into timestamp field - Mailing list pgsql-novice

From Pam Wampler
Subject How to load nulls into timestamp field
Date
Msg-id 2E4528861499D41199D200A0C9B15BC0012F4647@taylorwhite.com
Whole thread Raw
Responses Re: How to load nulls into timestamp field  ("Joshua b. Jore" <josh@greentechnologist.org>)
List pgsql-novice
Tree view 
If I am trying to load data into tables:
using psql  -c "\copy $file from $file using delimiters | "

and the table has a column of datatype timestamp that allows nulls,
the input record has the delimiter | in its place --
I get the ERROR:  copy: line 1, Bad timestamp external representation ''

why?  please help

Pam Wampler

pgsql-novice by date:

Previous
From: John Herreshoff
Date:
Subject: Re: pg_dump - groups and users.
Next
From: "Joshua b. Jore"
Date:
Subject: Re: How to load nulls into timestamp field