Re: help with COPY from .csv file into database

On Wed, 2004-08-04 at 15:40, michael(at)floog(dot)net wrote:
> I have tried to COPY the contents of the .csv file into my database
> called TEST_DB, but I'm still doing something incorrectly. Currently,
> database TEST_DB has one table called "matters".
>
> In my attempts listed below, I specified the name of each column/field
> in my database and specified the delimiter used in the .csv file, but
> still no go:
>
> TEST_DB-# copy matters (client_1_lastname, client_1_firstname,
...
> date_close) from '/home/floog/TEST_DB.csv' DELIMITER ',';
>
> ERROR: syntax error at or near "client_1_lastname" at character 2
...
>
> What did I do incorrectly?

You had a previous line without a terminating semi-colon. Notice that
the prompt (TEST_DB-# rather than TEST_DB=#) indicates that this is a
continuation line.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"And not only so, but we glory in tribulations also;
knowing that tribulation worketh patience; And
patience, experience; and experience, hope."
Romans 5:3,4