Re: [GENERAL] Strange delimiters problem

On 6/3/07, Andrej Kastrin <[EMAIL PROTECTED]> 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.

Re: [GENERAL] Strange delimiters problem

hubert depesz lubaczewski wrote: On 6/3/07, *Andrej Kastrin* <[EMAIL PROTECTED] > wrote: ||001||,||Classification||,||Economics||,||N|| ||001||,||Classification||,||Trends||,||Y|| etc... it looks like you should be able to read it using COPY command. some

Re: [GENERAL] Strange delimiters problem

On 6/3/07, Andrej Kastrin <[EMAIL PROTECTED]> 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 '||';