Re: Strange delimiters problem

On 6/3/07, Andrej Kastrin <andrej(dot)kastrin(at)siol(dot)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