| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> | 
|---|---|
| To: | PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org> | 
| Subject: | Re: Copy entire file as one field | 
| Date: | 2002-11-28 02:26:45 | 
| Message-ID: | 1038450405.24355.7.camel@haggis | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
On Wed, 2002-11-27 at 18:40, Warren Massengill wrote:
> How can I copy several hundred small text files into a database, each file 
> going into a field called 'message' and becomming one record (with or 
> without other fields) using psql?
Don't know about psql, but you could use python or perl (heck, even C!)
to script it pretty easily.
-- 
+------------------------------------------------------------+
| Ron Johnson, Jr.     mailto:ron(dot)l(dot)johnson(at)cox(dot)net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson  |
|                                                            |
| "they love our milk and honey, but preach about another    |
|  way of living"                                            |
|    Merle Haggard, "The Fighting Side Of Me"                |
+------------------------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2002-11-28 02:29:51 | Re: DB dump problems | 
| Previous Message | Gallamine | 2002-11-28 01:46:50 | DB dump problems |