Describe result set in PostgreSQL?

Question

In Microsoft Sql Server, there is a proc sys.sp_describe_first_result_set which takes an arbitrary sql query string and returns data describing the types that would be in the result set, were it to be executed. Note, this is describing the results of a complex query, not a table. MSDN reference

Is there anything similar for Postgres?

Answer 1

I tried to do this by creating a stored procedure to create temperory view then check information_schema.columns before droping the view.