| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-06-23 22:01:01 | Re: Copy Data Question |
| Previous Message | operationsengineer1 | 2006-06-23 21:46:49 | Re: Copy Data Question |