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: (view raw, whole thread or download thread mbox)
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

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-2017 The PostgreSQL Global Development Group