Right, for internal or C functions it just gives a symbol name or something similar. I've never been annoyed seeing that, just having pages of PL/PGSQL (I use a lot of that, possibly biased towards the “too much” direction) take up all the space.
A bit hacky, but what about only showing the first line of the source code? Then you would see link names for that type of function but the main benefit of suppressing the full source code would be obtained. Or, show source if it is a single line, otherwise “…” (as in, literally an ellipsis).
I find \df+ much less useful than it should be because it tends to be cluttered up with source code. Now that we have \sf, would it be reasonable to remove the source code from the \df+ display? This would make it easier to see function permissions and comments. If somebody wants to see the full definition of a function they can always invoke \sf on it.
If there is consensus on the idea in principle I will write up a patch.
+1
+1 but maybe with a twist. For any functions in a procedural language like plpgsql, it makes it pretty useless today. But when viewing an internal or C language function, it's short enough and still actually useful. Maybe some combination where it would keep showing those for such language, but would show "use \sf to view source" for procedural languages?
yes, it is almost necessary for C functions or functions in external languages. Maybe it can be specified in pg_language if prosrc is really source code or some reference.
