| From: | "AlexH" <devnullZERO(at)att(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | how to store a text file in a database |
| Date: | 2003-02-07 23:16:30 |
| Message-ID: | pan.2003.02.07.23.21.59.63965@att.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi:
I'm creating a postgre database to keep tract of all the job applications
I'm sending out. Here is a rough idea of my table so far, minus the data
types
CREATE TABLE application (
url
website_job_id
date_applied_to date;
city;
state;
company;
contact_info;
cv_text;
);
I have different cover letter for each application, and was wondering what
would be the best way to store this in the database.
in my database table, can cv_text refer to a link that points to the file
containing my CV ?
or should it be stored in cv_text directly as a varchar ? If so, howdo I
copy it there using SQL there ?
Obviously, I'm very newbie at databases. I'm just using the
character-based client on linux ... so I'm using SQL for all of this.
Any help would be appreciated.
Thanks
-Alex
--
For email, replace ZERO with the number zero.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ricardo Ryoiti S. Junior | 2003-02-07 23:20:49 | Re: Soft Updates/FFS and Postgresql |
| Previous Message | Chris | 2003-02-07 23:00:49 | Inquiry From Form [pgsql] |