Tom Lane <t...@sss.pgh.pa.us> wrote:
 
> No, but what you *would* need is the ability to return multiple
> result sets from one call.
 
At least.
 
> Even then, you could not exactly duplicate the current output of
> \d; but you could duplicate the functionality.
 
I would think that psql could duplicate the output pretty closely, 
especially if the output of the stored procedure was a stream of
intermingled result sets and messages (as from ereport).  This is
what many products provide.  They usually show messages with a class
'00' SQLSTATE just as plain text lines, and decorate the more severe
levels with appropriate additional information.
 
A while back I included a link to show what Sybase returns from
their sp_help SP for various object types:
 
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36273.1550/html/sprocs/X85190.htm
 
Note the lines like:
 
 Object does not have any indexes.
 
This came from the server as a SQLSTATE '00000' message.
 
-Kevin

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to