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

Re: Copy Data Question

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Copy Data Question
Date: 2006-06-23 21:54:35
Message-ID: 20060623215435.73479.qmail@web31803.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> >   CSV QUOTE AS 'quote' 
> >   FORCE NOT NULL column1, column2, column3, column4,
> > column5, column6 
> >  
> > > ;
> 
> the delimiter is the tab, which is the default.  i
> don't think i need to include it.  i don't what i'd
> put in place of 'delimiter' to represent tab, anyhow.
> 
> i'm not getting CSV QUOTE.  should by statement look
> like:
> 
> CSV QUOTE AS '''

You can open the file in a text editor just to verify how it is stored as a CSV.

If the data does not use quotes in the text.file then just drop this argument.

Also, if your text file does have quotes, it might help to remove quotes numeric data being pushed
to integer datatypes in the temp table.

Regards,

Richard Broersma Jr.

In response to

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-06-23 22:01:01
Subject: Re: Copy Data Question
Previous:From: operationsengineer1Date: 2006-06-23 21:46:49
Subject: Re: Copy Data Question

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