From: | Vangelis Katsikaros <ibob17(at)yahoo(dot)gr> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ignore errors for COPY [solved] |
Date: | 2010-11-11 16:46:32 |
Message-ID: | 4CDC1DE8.1060105@yahoo.gr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/11/2010 03:05 PM, Guillaume Lelarge wrote:
>
> You should better look at pgloader which will use COPY to put your data
> in your table and found the lines in error. Of course, it takes time to
> detect lines in error. But at least, all "good" lines will be in your
> table, and all "bad" lines will be in a file, so that you can modify
> them to inject later.
>
>
Hi
Thanks for the answer, indeed it solves the issue.
Now, I would like to ask a second question (sorry for using the same
thread :)
I would like to create a specific database on a another location (not in
"data_directory = '/var/lib/postgresql/8.3/main'" ). I was wondering if
I have to run
initdb -D /other/path/
of if there is another way
(for example in mysql I can do the same thing by creating a symlink to
the other location inside "datadir = /var/lib/mysql" )
Regards
Vangelis
From | Date | Subject | |
---|---|---|---|
Next Message | Aram Fingal | 2010-11-11 16:50:47 | Schema tool |
Previous Message | David Fetter | 2010-11-11 16:45:33 | Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9 |