Обсуждение: Gettting Error When Loading Timestamp Field

Поиск
Список
Период
Сортировка

Gettting Error When Loading Timestamp Field

От
Pam Wampler
Дата:
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