[HACKERS] proposal psql \gdesc - Mailing list pgsql-hackers

From Pavel Stehule
Subject [HACKERS] proposal psql \gdesc
Date
Msg-id CAFj8pRBhYVvO34FU=EKb=nAF5t3b++krKt1FneCmR0kuF5m-QA@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] proposal psql \gdesc  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Hi

Sometimes I have to solve the result types of some query. It is invisible in psql. You have to materialize table or you have to create view. Now, when we can enhance \g command, we can introduce query describing

some like

select a, b from foo
\gdesc

     |   type     | length | collation | ....
------------------------------------------------
 a  | varchar  |     30  |
 b  | numeric |      20 | 

What do you think about this idea?

Regards

Pavel    

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] PG 10 release notes
Next
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] PG 10 release notes