Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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	

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group