Re: Show type in psql SELECT - Mailing list pgsql-hackers

From David Fetter
Subject Re: Show type in psql SELECT
Date
Msg-id 20130223175508.GB23340@fetter.org
Whole thread Raw
In response to Show type in psql SELECT  (Mike Toews <mwtoews@gmail.com>)
Responses Re: Show type in psql SELECT  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
On Sat, Feb 23, 2013 at 12:09:51PM +1300, Mike Toews wrote:
> 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:

I'm thinking we should add it as a SET parameter and expose it to all
SQL.  The next client program(s) shouldn't have to re-invent this
separately.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: [PATCH 0/3] Work around icc miscompilation
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: Strange Windows problem, lock_timeout test request