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

From David G. Johnston
Subject Re: Need help in database design
Date
Msg-id CAKFQuwazso0hQtg5O1O5OXpWLq18iWUTmJKWfGiK0FYXiP65tQ@mail.gmail.com
Whole thread Raw
In response to Re: Need help in database design  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Need help in database design
List pgsql-general
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.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Need help in database design
Next
From: Adrian Klaver
Date:
Subject: Re: Need help in database design