[NOVICE-GENERAL] Insert file.txt in a table - Mailing list pgsql-general

From Ennio-Sr
Subject [NOVICE-GENERAL] Insert file.txt in a table
Date
Msg-id 20030422151506.GA3013@deby.ei.hnet
Whole thread Raw
List pgsql-general
Hi!
Trying to insert a whole file.txt in a table I'm getting separate
records for each paragraph terminated by a <LF> (0x0A).n the file.txt.
Is there any way to have  a delimiter recognised so that more that one
single <LF> terminated paragraph can go in a single record?
The obvious solution would be to manually edit the file.txt and split it
into several smaller files; then, insert these into the table as
separate records.
No quicker way?
(using pgres 7.2.0)

--
[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-general by date:

Previous
From: Lyndon Tiu
Date:
Subject: Father of Relational Databases - Dead at 79.
Next
From: Thomas Kellerer
Date:
Subject: Re: database browser