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 04:57:04 |
Message-ID: | Pine.BSF.4.10.9910240456330.47570-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
From | Date | Subject | |
---|---|---|---|
Next Message | Jason C. Wells | 1999-10-24 05:15:18 | UPDATE cell from text file |
Previous Message | Peter Eisentraut | 1999-10-24 02:22:29 | Re: [GENERAL] UPDATE cell from text file |