James Long wrote:
> Welcome to psql 8.1.8, the PostgreSQL interactive terminal.
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
> james=> \pset fieldsep ,
> Field separator is ",".
> james=> \copy transactions from bar
> ERROR: value too long for type character(14)
> CONTEXT: COPY transactions, line 1, column symbol: "Cash,0,0,Cash Adjustment,4/2/2007,,,0.87,0,0, ,BALANCE-SWP T1 TO T2,16,,Financial"
> psql appears to be treating the entire input line as one tuple,
> instead of seeing the fieldsep value as a field delimiter.
fieldsep does not affect the COPY command.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2007-04-04 00:18:00|
|Subject: Re: What am I doing wrong with this comma-delimited copy? |
|Previous:||From: James Long||Date: 2007-04-03 22:31:29|
|Subject: What am I doing wrong with this comma-delimited copy?|