Strange delimiters problem

From: Andrej Kastrin <andrej(dot)kastrin(at)siol(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange delimiters problem
Date: 2007-06-03 11:44:41
Message-ID: 4662A9A9.708@siol.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-06-03 12:58:48 Re: Turning on logging
Previous Message Martijn van Oosterhout 2007-06-03 09:48:00 Re: Need a wee bit more info on PostgreSQL's SSL security options