Skip site navigation (1) Skip section navigation (2)

How to insert soft CRs in db records

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to insert soft CRs in db records
Date: 2003-04-20 00:35:49
Message-ID: 20030420003549.GA5142@deby.ei.hnet (view raw or flat)
Thread:
Lists: pgsql-novice
Hi! 
In an attempt to recover in some way a .dbt file (relative to a .dbf
file transformed in a pg table) I'm facing some difficulties.
I created a single column pg-table and filled it with the text coming
from the .dbt (previously converted to a linux text file).
To obtain separate records (one for each ex-dbt quasi-record) I had to
manipulate heavily the text file and to cancel all CRs used in the
original .dbt for formatting purposes.   

Now the first question is:
"Is there any simpler way to do that?" or "How to avoid that sql
interpretes each line feed (of the original txt file) as the end of a
record?"
Missing a positive answer, the second question would be:
"Is there any way to format the single records (inserting line feeds,
tabs, etc.) considering that the column has been created as a charvar?"

Thanks for your attention and have a nice and peaceful Easter everybody.
	Ennio.



-- 
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?//
 Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that.             )=(
 Do something you aren't good at!" (used to say Henry Miller) ]


pgsql-novice by date

Next:From: SALUNKHE,MANDAR (HP-Singapore,ex1)Date: 2003-04-21 01:15:42
Subject: Postgresql database does not start and just hangs
Previous:From: Joe ConwayDate: 2003-04-18 20:11:39
Subject: Re: i guess i can't code in C...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group