Postgres Pro
Downloads
Home   >   mailing lists

Can psql show the column type of a result ? - Mailing list pgsql-general

From Nils O. Selåsdal
Subject Can psql show the column type of a result ?
Date
Msg-id 4C9A5E63.6020705@asgaard.homelinux.org
Whole thread Raw
Responses Re: Can psql show the column type of a result ?  (Richard Broersma <richard.broersma@gmail.com>)
Re: Can psql show the column type of a result ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
  Hello,
I'm wondering if there's a way to show the column type of a result with
psql, e.g.

 > select sum(r) from mytable;
    r
-------
  101.0

I'd like to see the type of the 'r' column.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Nested literal parsing rules?
Next
From: Awodipe James
Date:
Subject: Compiling openssl