On Tue, Jan 15, 2008 at 12:18:18PM -0500, blackwater dev wrote:
> Ok, fair enough, in theory, I don't want to simply trust the file to have
> clean data so will want to put the data into a huge array (php) which I can
> clean and then pump into the db. What is the best way to pump all this data
>
Hello all,
I'm pulling in a csv file nightly and need to pump in into my db. My plan
is to pump it into a temp table and then to an update or insert from the
temp table to the real table. I'm having an issue, however, with the copy.
Here is a my syntax.
COPY cars FROM 'cars04.txt'
Title: bulk copy in postgresql
Hi.
Can someone please tell me if there is a tool in postgres similar to BCP?
I need to populate some tables using data from some text files and don't know how to do it.
Thanks in advance,
Carlos Felipe Zirbes
