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.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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
