Hello
I have a problem:
i use postgresql and i need to store in one of my table's column source
code of program (written in C). What is the best type for that column ?


Thanx
Michal

vertigo wrote:

Why? What is the problem you are trying to solve?

Your proposed "solution" is to store a possibly
extremely large amount of text in a "column" in
a table. Why a column? Why not another table?
Why not just store the fully-qualified filename?

NPL

--
"It is impossible to make anything foolproof
because fools are so ingenious"
- A. Bloch

My problem is that i work on diskless machine and have
only access to remote database server (postgresql) and
all privileges to specified database,
and i must save a file on that server, so i could later
get it from that server.
What do you mean by 'Why not another table?' ?
How would you save that file ?

Thanx
Michal

vertigo <none (AT) microsoft (DOT) com> wrote

"Free your mind" Morpheous in The Matrix

one table has the information about the file, including an unique ID
column (or columns) and another table uses the ID and stores the file,
line by line. rather than a column that stores the whole file (which
can be a problem getting data in and out). Line numbering determines
ordering and it could have features not found in ordinary files, such
as a built in change history. With the ID it's obvious that many
"files" can be stored there.

HTH,
ED