Re: Strange delimiters problem

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: "Andrej Kastrin" <andrej(dot)kastrin(at)siol(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange delimiters problem
Date: 2007-06-03 13:18:58
Message-ID: 9e4684ce0706030618h15114b95k7860ed0dd3778107@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/3/07, Andrej Kastrin <andrej(dot)kastrin(at)siol(dot)net> wrote:
>
> ||001||,||Classification||,||Economics||,||N||
> ||001||,||Classification||,||Trends||,||Y||
> etc...
>

it looks like you should be able to read it using COPY command.
something like:
copy some_table from stdin with delimiter ',' csv quote '||';

depesz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2007-06-03 13:44:13 Re: general features
Previous Message Bill Moran 2007-06-03 12:58:48 Re: Turning on logging