Thread: psql \df and opaque functions
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.
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