How do I import this? - Mailing list pgsql-php

From Julio Cuz, Jr.
Subject How do I import this?
Date
Msg-id 4.3.2.7.2.20010216092952.00b85ee8@rccd.cc.ca.us
Whole thread Raw
List pgsql-php
Hi--

I'm having problems importing a file that contains the following data
(close to 500 lines):

sample:
----------------
"Heritage";"5/2/00";"EOPS";12/30/1899 15:00:00;12/30/1899
17:00:00;12/30/1899 17:00:00;12/30/1899 15:00:00;"Claudette
Ellis";"Riverside";"cellis";"8123";100144;5/2/2000 0:00:00;"EOPS OPR Review
Staff Mtg";;"12";"12 Chairs and enough  tables (set up) in a hollow square";
----------------

The delimiter is ";"  and I'm using this:

COPY FROM <filename> INTO <mydbase> USING DELIMITER |;|

And it says bad format...Help!

Julio Cuz, Jr.
Riverside Community College
jcuz@rccd.cc.ca.us


pgsql-php by date:

Previous
From: "Dan Wilson"
Date:
Subject: Trapping NOTICE using PHP
Next
From: "Adam Lang"
Date:
Subject: Re: How do I import this?