UPDATE cell from text file

From: "Jason C(dot) Wells" <jcwells(at)u(dot)washington(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: UPDATE cell from text file
Date: 1999-10-24 05:15:18
Message-ID: Pine.BSF.4.10.9910240514550.47781-100000@s8-37-26.student.washington.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This has got to be easy but I am having a hard time finding the right
docs.

What I want to do is analogous to:

UPDATE website SET content='contents of a big ass file that I dont want to
type on the command line' where filename='index.html';

How can I do this?

Can I do this without writing a seperate shell and/or perl script?

Also, is there a stdio stream that I can use to pipe data into SQL
commands? Man, If I had this I could get a lot done in a hurry.

FWIW, I am not looking for COPY-ing delimited data from a flat file into a
table. I don't want to make new rows. I am trying to bring the contents of
an entire file into an existing single cell (namely content) of a table.

Am I going to be stuck just putting pointers to files in my database? Ugg,
I really want ALL my data in one place.

Please CC this address.

Thank You, | http://students.washington.edu/jcwells
Jason Wells | "Those who would trade freedom for security deserve neither
| freedom nor security." - Benjamin Franklin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason C. Wells 1999-10-24 10:42:50 Re: [GENERAL] UPDATE cell from text file
Previous Message Jason C. Wells 1999-10-24 04:57:04 UPDATE cell from text file