From: | Lynna Landstreet <lynna(at)gallery44(dot)org> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: "Bad date external representation" |
Date: | 2003-06-19 19:16:16 |
Message-ID: | BB178440.406%lynna@gallery44.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Some additional information with regard to this issue, in case it helps any.
/* --------------------------------------------------------
Table structure for table "exhibitions"
-------------------------------------------------------- */
CREATE TABLE "exhibitions" (
"exhibition_id" int4 DEFAULT
nextval('"exhibitions_exhibition_id_seq"'::text) NOT NULL,
"exhibition_name" varchar(128) NOT NULL,
"start_date" date NOT NULL,
"end_date" date NOT NULL,
"curator" varchar(128),
"description" varchar(1024) NOT NULL,
"created_date" date NOT NULL,
"created_by" varchar(32) NOT NULL,
"modified_date" date NOT NULL,
"modified_by" varchar(32) NOT NULL,
CONSTRAINT "exhibitions_pk" PRIMARY KEY ("exhibition_id")
);
And the first line from the data file I was trying to import:
100|Wild Writing|9/19/2002|10/26/2002|Leslie Thompson|Kroeger enters the
landscape armed with a notebook and pencil for these nature-based images.
Using graph paper, the artist makes graphite rubbings from tree bark, which
has seen the passage of various beetle type insects. The paths, which are
left in their wake, appear like so many strange prehistoric symbols, once
Kroeger has done his magic in the darkroom. Printed as colour photograms of
relatively large scale, these works simultaneously reference moonscapes,
cave paintings, and microcosms.|2/4/2003|Lynna Landstreet|2/14/2003|Lynna
Landstreet
Don't know if that helps any...
Lynna
--
Resource Centre Database Coordinator
Gallery 44
www.gallery44.org
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Pizzo | 2003-06-19 19:56:25 | [local] idle in transaction |
Previous Message | Lynna Landstreet | 2003-06-19 19:03:41 | Re: "Bad date external representation" |