On 01/06/2012 03:12 PM, Phoenix Kiula wrote:
On Fri, Jan 6, 2012 at 4:24 PM, Steve Crawford
<scrawford@xxxxxxxxxxxxxxxxxxxx> wrote:
On 01/06/2012 01:11 PM, Phoenix Kiula wrote:
Thanks Steve. YES! I changed it to transaction pooling and now it works.
Another problem through.
I need to COPY a huge text file into a table, with about 350 million
lines in the file (i.e., 350 million rows in the table).
While copying, some lines do not have data. They are empty values.
How can I specify in COPY command that if data is not found, it should
be ignored? In my temp table definition, I set this column as "NULL"
anyway, so it should be ok if this column was left empty!
What can I do in my COPY command to circumvent this?
http://www.postgresql.org/docs/9.0/interactive/sql-copy.html
Search for
NULL
Thanks.
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
