Re: Need help in database design - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Need help in database design
Date
Msg-id 43981031-ac2a-4216-9342-8b898a06d0d7@aklaver.com
Whole thread Raw
In response to Re: Need help in database design  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On 12/23/24 08:55, David G. Johnston wrote:
> On Mon, Dec 23, 2024, 09:54 Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto: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...

Aah, got it thanks.

> 
> David J.
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Need help in database design
Next
From: Divyansh Gupta JNsThMAudy
Date:
Subject: Re: Need help in database design