Re: Copy entire file as one field

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: Raw Message | Whole Thread | 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" |
+------------------------------------------------------------+

In response to

Browse pgsql-novice by date

  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