Re: URGENT: temporary table not recognized? - Mailing list pgsql-general

On 01/06/2012 03:42 PM, Phoenix Kiula wrote:
> On Fri, Jan 6, 2012 at 6:20 PM, Adrian Klaver<adrian.klaver@gmail.com>  wrote:
>
>> http://www.postgresql.org/docs/9.0/interactive/sql-copy.html
>>
>> Search for
>> NULL
>
>
>
> Thanks Adrian.
>
> Without examples, it's hard to predict syntax. If the value after a
> pipe is missing altogether, I suppose the missing value is "\n"
> (newline). But this doesn't work:
>
>     copy vl from 'data.txt' WITH DELIMITER AS '|' NULL '\n';
>
> None of these work either:
>
>     copy vl from 'data.txt' WITH DELIMITER AS '|' NULL \n;
>     copy vl from 'data.txt' WITH DELIMITER AS '|' NULL \\n;
>     copy vl from 'data.txt' WITH DELIMITER AS '|' NULL '';

Try:
copy vl from 'data.txt' WITH CSV DELIMITER '|';


If that doesn't work take a look at pgloader:
http://pgfoundry.org/projects/pgloader/






--
Adrian Klaver
adrian.klaver@gmail.com