| From: | dj00302003(at)yahoo(dot)com (Jay Davis) |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | How to turn flat file to SQL |
| Date: | 2004-01-12 00:44:01 |
| Message-ID: | 1d17eeb7.0401111644.e512a95@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi,
I'm new to SQL but we want to turn some of our flat files into
SQL databases. The flat file is the result of a survey (think of
a test) where there are some multiple choice questions, and
a bunch of "T/F" questions. The T/F questions are just checked
boxes, which we can think of as keywords that a person chooses.
The question is, can we put this into a SQL database just as a
flat file, ie as one table, with one column per question, or should
we break it into several tables, for instance with a table of
the "keywords" (the boxes that can be checked). Is there any
problem on a typical Linux box with running PostgreSql database
with one table of 120 columns?
Thanks,
J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Weaver | 2004-01-12 03:28:47 | Re: Get error during initdb |
| Previous Message | Tom Lane | 2004-01-11 20:42:49 | Re: PQexec hangs, stuck on malloc_consolidate |