MIME-Version: 1.0
References: <CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com>
 <b450927c-49da-46e5-ad74-bf38ceff166b@aklaver.com> <CAHesJ5+ASNoSNMiC5Ms0Ts=gw7v2_UeBpUT=phujO4yE_XCbEw@mail.gmail.com>
 <CAHesJ5JbkCBZ2f_AvUr8+KWnGPAsobu4zyfnWm8bEeb7X9oqDQ@mail.gmail.com> <06e1f1ee-74b2-43a2-9a63-da20ae455ae2@aklaver.com>
In-Reply-To: <06e1f1ee-74b2-43a2-9a63-da20ae455ae2@aklaver.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 23 Dec 2024 09:55:30 -0700
Message-ID: <CAKFQuwazso0hQtg5O1O5OXpWLq18iWUTmJKWfGiK0FYXiP65tQ@mail.gmail.com>
Subject: Re: Need help in database design
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c0b4340629f2dd42"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwazso0hQtg5O1O5OXpWLq18iWUTmJKWfGiK0FYXiP65tQ%40mail.gmail.com>
Precedence: bulk

--000000000000c0b4340629f2dd42
Content-Type: text/plain; charset="UTF-8"

On Mon, Dec 23, 2024, 09:54 Adrian Klaver <adrian.klaver@aklaver.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.


>

--000000000000c0b4340629f2dd42
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><div class=3D"gmail_quote gmail_quote_container"><di=
v dir=3D"ltr" class=3D"gmail_attr">On Mon, Dec 23, 2024, 09:54 Adrian Klave=
r &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.co=
m</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin=
:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 12/23/24 08:46,=
 Divyansh Gupta JNsThMAudy wrote:<br>
&gt; Also as you ask how 50 pairs turns into 50 column so each column will =
be <br>
&gt; a key and the value of that key will store inside their respective <br=
>
&gt; column for each row<br>
<br>
My problem with understanding this is 50 pairs =3D 100 values, I don&#39;t =
<br>
understand how that can fit in 50 columns that can only handle 1 value <br>
each. You need to provide some example data showing what you want to <br>
achieve. It does not need to be the full 50, just something to show the <br=
>
process.<br></blockquote></div></div><div dir=3D"auto"><br></div><div dir=
=3D"auto"><br></div><div dir=3D"auto">Because the column name is the same a=
s a dictionary key...</div><div dir=3D"auto"><br></div><div dir=3D"auto">Da=
vid J.</div><div dir=3D"auto"><br></div><div dir=3D"auto"><div class=3D"gma=
il_quote gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D"=
margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br></blockq=
uote></div></div></div>

--000000000000c0b4340629f2dd42--