Gettting Error When Loading Timestamp Field - Mailing list pgsql-novice

From Pam Wampler
Subject Gettting Error When Loading Timestamp Field
Date
Msg-id 2E4528861499D41199D200A0C9B15BC0012F4653@taylorwhite.com
Whole thread Raw
List pgsql-novice
I am getting this error when I am trying to load a timestamp field

pam=> \copy test from 'pamtest' using delimiters | with null as ' '
\.
ERROR:  copy: line 1, parser: parse error at or near ":"
PQendcopy: resetting connection

This is my input file
1002101585|313501705281|FN|1|0|2|10-AUG-2001:13:30:048

thanks
Pam Wampler

pgsql-novice by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Query between databases?
Next
From: Pam Wampler
Date:
Subject: inserting a timestamp show wrong timezone