=?UTF-8?B?Ik5pbHMgTy4gU2Vsw6VzZGFsIg==?= <nosel...@asgaard.homelinux.org>
writes:
> 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.
There's nothing built-in to psql, but you could modify the query, eg
select pg_typeof(sum(r)) from mytable;
(Adding "LIMIT 1" would be wise in most cases, though you don't need it
here.)
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
