psql - Show query result column types (PostgreSQL)

Question

Is there a way to easily get the column types of a query result? I read the psql documentation, but I don't think it supports that. Ideally, I'd be able to get something like:

 columna : text | columnb : integer
----------------+-------------------
 oh hai         |                42

Is there a way I can get this information without coding something up?

question from:https://stackoverflow.com/questions/3267769/show-query-result-column-types-postgresql

Answer 1

I don't think you can print exactly what you have in the sample, unless you write a stored procedure for it.

One way to do it (two "selects"):

1. create table my_table as select ...
2. d my_table
3. select * from my_table