Re: [HACKERS] Improved \df(+) in psql + backward-compatibility - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [HACKERS] Improved \df(+) in psql + backward-compatibility
Date
Msg-id 200509232032.j8NKW5U11857@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Improved \df(+) in psql + backward-compatibility  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Seems this item will have to remain for 8.2.  I have added this to TODO:

        o Display IN, INOUT, and OUT parameters in \df+

          It probably requires psql to output newlines in the proper
          column, which is already on the TODO list.


---------------------------------------------------------------------------

Tom Lane wrote:
> David Fetter <david@fetter.org> writes:
> > I've noticed that \df doesn't do quite what it might when a function
> > is created with named input parameters.  Please find enclosed a patch
> > against CVS TIP that does this better.
>
> Meanwhile, getting back to the actual merits of the patch ... this is
> not right yet, because it will do the wrong thing when there are OUT
> parameters.  (The proargnames array includes both IN and OUT params,
> and you can't assume that proargnames and proargtypes have corresponding
> subscripts.)  It would probably be a good idea to discuss what display
> we want for a function with OUT parameters, anyway.  The strict columnar
> representation that \df currently uses doesn't scale very well :-(
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: be-secure.c patch
Next
From: Bruce Momjian
Date:
Subject: Re: Improve psql's handling of multi-line queries