Skip site navigation (1) Skip section navigation (2)

What am I doing wrong with this comma-delimited copy?

From: James Long <pgsql-novice(at)museum(dot)rain(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: What am I doing wrong with this comma-delimited copy?
Date: 2007-04-03 22:31:29
Message-ID: 20070403223129.GA83958@ns.umpquanet.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Also, one issue I can see coming is the date format.  Is there
a way I can read M-D-Y (or M/D/Y) format dates and store them?
My default postgresql date format is Y-M-D.  I'd be happy to
retain Y-M-D on display, I just don't want to have to involve
a script to massage the input dates to Y-M-D format.


Thank you!


Jim

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2007-04-03 22:49:49
Subject: Re: What am I doing wrong with this comma-delimited copy?
Previous:From: Ramon OrticioDate: 2007-04-02 06:31:41
Subject: Re: PL/pgSQL how to install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group