Обсуждение: Strange delimiters problem

Dear all,

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.

Best, Andrej

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