Thread: 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
||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