From: | Eugen Konkov <kes-kes(at)yandex(dot)ru> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Proposition for autoname columns |
Date: | 2020-11-02 15:05:29 |
Message-ID: | 131355559.20201102170529@yandex.ru |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello Pgsql-hackers,
When selecting data from json column it named as '?column?'
tucha=# select info->>'suma', docn from document order by id desc limit 5;
?column? | docn
----------+------
665.97 | 695
513.51 | 632
665.97 | 4804
492.12 | 4315
332.98 | 1302
(5 rows)
It would be useful if the name of column will be autoassigned based on
name of json key. Like at next query:
tucha=# select info->>'suma' as suma, docn from document order by id desc limit 5;
suma | docn
--------+------
665.97 | 695
513.51 | 632
665.97 | 4804
492.12 | 4315
332.98 | 1302
(5 rows)
Would it be useful this auto assigned name for column from json?
--
Best regards,
Eugen Konkov
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2020-11-02 15:28:22 | Re: Disable WAL logging to speed up data loading |
Previous Message | Anastasia Lubennikova | 2020-11-02 15:02:22 | Re: Improving psql slash usage help message |