| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
| Cc: | Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Importing CSV File |
| Date: | 2015-10-27 16:46:46 |
| Message-ID: | CAKFQuwa+NpSt5_f306G2mSTBXXcUd3bLXWzfJP2DJ0V8onujpw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 27, 2015 at 12:36 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:
>
> contents of /tmp/junk.data:
> -------------------------------------------------------------------
> 1,'junk1'
> 2,'junk1'
> 3,'junk1'
>
Good info but I resonably certain the format in question is more like:
--------------------
1,'junk1',\r\n,'blah','blah2'
2,'junk2',\r\n,'blah'
3,'junk3',\r\n,'blah','blah2','blah3'
and the OP wants to only import the common columns while ignoring the fact
that extra columns exist.
I guess line 4 could read:
4,'junk4','important',\r\n,'blah','blah2'
so that even within the main structure there would be a variable number of
columns...
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-10-27 16:47:50 | Re: Importing CSV File |
| Previous Message | Melvin Davidson | 2015-10-27 16:36:17 | Re: Importing CSV File |