| From: | Ennio-Sr <nasr(dot)laili(at)tin(dot)it> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | [NOVICE-GENERAL] Insert file.txt in a table |
| Date: | 2003-04-22 15:15:06 |
| Message-ID: | 20030422151506.GA3013@deby.ei.hnet |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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) ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2003-04-22 15:21:53 | Re: database browser |
| Previous Message | Tilo Schwarz | 2003-04-22 15:14:07 | Re: Are we losing momentum? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juliet May | 2003-04-22 20:59:46 | Re: large object oid value not showing up in pgAdmin |
| Previous Message | eurlix | 2003-04-22 14:41:35 | about "pg_stat_get_tuples_fetched" |