Proposition for autoname columns

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-hackers by date

  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