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