Re: Show type in psql SELECT
| От | Jeff Janes |
|---|---|
| Тема | Re: Show type in psql SELECT |
| Дата | |
| Msg-id | CAMkU=1zjgPuD7zBAN148N6WMC97ykbUR6C8XoKg1Vht87RtYVw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Show type in psql SELECT (David Fetter <david@fetter.org>) |
| Ответы |
Re: Show type in psql SELECT
|
| Список | pgsql-hackers |
On Sat, Feb 23, 2013 at 9:55 AM, David Fetter <david@fetter.org> wrote:
This information is already provided through libpq, see PQftype.
It is merely a matter of making psql present the data it already has in a way people find convenient.
The client has to decide what to do with this information, I don't see any way around that. The server can't make that decision for it.
Cheers,
Jeff
On Sat, Feb 23, 2013 at 12:09:51PM +1300, Mike Toews wrote:I'm thinking we should add it as a SET parameter and expose it to all
> Hi hackers,
>
> Type info can be viewed with "\d mytable", however often I'd like to
> see the type (and typmod) info in SELECT queries with psql, similar
> to pgAdmin III. For example:
SQL.
This information is already provided through libpq, see PQftype.
It is merely a matter of making psql present the data it already has in a way people find convenient.
The next client program(s) shouldn't have to re-invent this
separately.
The client has to decide what to do with this information, I don't see any way around that. The server can't make that decision for it.
Cheers,
Jeff
В списке pgsql-hackers по дате отправления: