Strange delimiters problem - Mailing list pgsql-general

From Andrej Kastrin
Subject Strange delimiters problem
Date
Msg-id 4662A9A9.708@siol.net
Whole thread Raw
Responses Re: Strange delimiters problem
Re: Strange delimiters problem
List 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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Need a wee bit more info on PostgreSQL's SSL security options
Next
From: Bill Moran
Date:
Subject: Re: Turning on logging