Gettting Error When Loading Timestamp Field

From: Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Gettting Error When Loading Timestamp Field
Date: 2002-02-19 22:11:27
Message-ID: 2E4528861499D41199D200A0C9B15BC0012F4653@taylorwhite.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Aarni Ruuhimäki / Megative Tmi / KYMI.com 2002-02-20 12:38:08 One big table or several smaller tables ?
Previous Message Patrick Hatcher 2002-02-19 21:43:46 Query between databases?