Strange delimiters problem

On 6/3/07, Andrej Kastrin <andrej.kastrin@siol.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

hubert depesz lubaczewski wrote:

On 6/3/07, *Andrej Kastrin* <andrej.kastrin@siol.net
<mailto:andrej.kastrin@siol.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

Thanks,
but I receive the following error message when I'm trying to run the
proposed copy command:

ERROR: COPY quote must be a single character

I use PostgreSQL 8.1.5.

Best, Andrej

On 6/3/07, Andrej Kastrin <andrej.kastrin@siol.net> wrote:

I am experiencing difficulty in trying to copy the file structure below
into PostgreSQL table:

||001||,||Classification||,||Economics||,||N||
||001||,||Classification||,||Trends||,||Y||
etc...

Although I can preprocess the input file with e.g awk, I would like to
know is it possible to do that directly in PostgreSQL.

Thanks in advance for any suggestions.

I think you might be able to. You can have CSV with your pipes
(as QUOTE in [ CSV [ HEADER ] [ QUOTE [ AS ] 'quote' ] )

http://www.postgresql.org/docs/8.2/static/sql-copy.html

Best, Andrej

Cheers,
Andrej