Postgres Pro
Downloads
Home   >   mailing lists

need help with copy function - Mailing list pgsql-general

From Robert Ngo
Subject need help with copy function
Date
Msg-id 000801c485c9$396a3940$1b01230a@perridot.com
Whole thread Raw
Responses Re: need help with copy function  (Bruno Wolff III <bruno@wolff.to>)
Re: need help with copy function  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-general
Tree view

copy swpparm from stdin using delimiters ';';

exampaper;02;1;Bahasa Melayu;M;A;2002-11-27;system;;

\.

why does the above command return a error message

 
ERROR:  copy: line 1, Bad date external representation ''
PQendcopy: resetting connection

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: How to setup default value "0000-00-00" for "date" type under PostgreSQL?
Next
From: "peter@remindex"
Date:
Subject: Re: select count(*) from pg_stat_activity in V8.0.0