| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Divyansh Gupta JNsThMAudy <ag1567827(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Need help in database design |
| Date: | 2024-12-23 16:55:30 |
| Message-ID: | CAKFQuwazso0hQtg5O1O5OXpWLq18iWUTmJKWfGiK0FYXiP65tQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Dec 23, 2024, 09:54 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 12/23/24 08:46, Divyansh Gupta JNsThMAudy wrote:
> > Also as you ask how 50 pairs turns into 50 column so each column will be
> > a key and the value of that key will store inside their respective
> > column for each row
>
> My problem with understanding this is 50 pairs = 100 values, I don't
> understand how that can fit in 50 columns that can only handle 1 value
> each. You need to provide some example data showing what you want to
> achieve. It does not need to be the full 50, just something to show the
> process.
>
Because the column name is the same as a dictionary key...
David J.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2024-12-23 16:59:11 | Re: Need help in database design |
| Previous Message | Adrian Klaver | 2024-12-23 16:54:04 | Re: Need help in database design |