Re: Show type in psql SELECT

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