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

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 (view raw, whole thread or download thread mbox)
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  |
|                                                            |
| "they love our milk and honey, but preach about another    |
|  way of living"                                            |
|    Merle Haggard, "The Fighting Side Of Me"                |

In response to

pgsql-novice by date

Next:From: Ron JohnsonDate: 2002-11-28 02:29:51
Subject: Re: DB dump problems
Previous:From: GallamineDate: 2002-11-28 01:46:50
Subject: DB dump problems

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