Thread

1. psql \df and opaque functions

   Thomas F.O'Connell <tfo@monsterlabs.com> — 2002-03-05T18:39:52Z

   is it a known issue that \df in psql does not list functions that return
   opaque (i.e., those used in triggers)?
   
   also, does \dd only list builtins?  if so, is there a convenient way to
   view triggers in psql?
   
   -tfo
   
   p.s. i've looked through the docs, to no avail, and would've checked
   the archives, but search seems to be broken, at the moment.
   
   

2. Re: psql \df and opaque functions

   Tom Lane <tgl@sss.pgh.pa.us> — 2002-03-06T00:18:02Z

   tfo@monsterlabs.com writes:
   > is it a known issue that \df in psql does not list functions that return
   > opaque (i.e., those used in triggers)?
   
   I believe this was done deliberately as a means of suppressing I/O
   conversion functions from the display.  I'm not sure I agree with that,
   and I am sure that it hides more stuff than just conversion functions,
   but that was the rationale.
   
   There's been talk on pghackers of breaking down the notion of type
   "opaque", which is presently overloaded to mean about half a dozen
   different things, into several pseudo-types that would have crisper
   definitions.  That would probably make it possible to identify I/O
   functions with much more reliability, and so improve the accuracy
   of \df's filtering of "uninteresting" functions.
   
   			regards, tom lane