| From: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: URGENT: temporary table not recognized? |
| Date: | 2012-01-07 00:16:09 |
| Message-ID: | CAFWfU=uw+GVcNw9kY=+0aoDFBQr7QTpBkhMM6WAB9KQe=T-iyw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jan 6, 2012 at 6:54 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
>
> Try:
> copy vl from 'data.txt' WITH CSV DELIMITER '|';
Doesn't work. Can't see what the different in CSV is from a text file.
Same errors are thrown.
> If that doesn't work take a look at pgloader:
> http://pgfoundry.org/projects/pgloader/
Wow, another geeky tool. Hard to find documentation. Archaic
presentation, no simple steps to install and get using. Anyway doesn't
seem to provide the options I need
(http://pgloader.projects.postgresql.org/) --
a) Ability to assign more than one NULL value
b) Ability to ignore lines altogether that have any problem
Really, other databases have mechanisms to ignore "problem lines"
while copying. Does Postgresql allow me to *ignore* lines while
COPYING?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2012-01-07 00:16:23 | Re: URGENT: temporary table not recognized? |
| Previous Message | Phoenix Kiula | 2012-01-06 23:55:42 | Re: URGENT: temporary table not recognized? |