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