Re: URGENT: temporary table not recognized?

On 01/06/2012 03:12 PM, Phoenix Kiula wrote:
> On Fri, Jan 6, 2012 at 4:24 PM, Steve Crawford
> <scrawford(at)pinpointresearch(dot)com> 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(dot)klaver(at)gmail(dot)com