From: | "Erik Rijkers" <er(at)xs4all(dot)nl> |
---|---|
To: | "Mike Toews" <mwtoews(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Show type in psql SELECT |
Date: | 2013-02-23 06:34:58 |
Message-ID: | 13b89d7b9d03e8c8075832b4ff515cf6.squirrel@webmail.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sat, February 23, 2013 00:09, Mike Toews wrote:
>
> 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:
>
> my_db=# \pset type
> my_db=# SELECT * FROM my_table;
> gid | description | width
> integer | character varying(255) | numeric(6,3)
> ---------+------------------------+--------------
> 1 | Hello | 3.220
> (1 row)
>
> Has anyone else thought this was a missing feature?
>
As an occasional pgAdmin user, I have often thought that this feature should be added to psql. It
would save time going back and forth between different views (especially with broad tables). I
would be glad to have the possibility. It would have to be optional, of course.
In short: +1 from me.
thanks,
Erik Rijkers
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-02-23 10:55:54 | Re: bugfix: --echo-hidden is not supported by \sf statements |
Previous Message | Michael Paquier | 2013-02-23 05:48:09 | New hooks for snapshot and transaction ID acquisition from external source |