006 Postgres Command Line : psql : Identify definition of a Function

In 005 when last we left our intrepid explorers we were wondering if having defined an inline table that contains the definition of the selection purely in the user defined function how do we see what that selection is as it might not be a presently defined object. SetOF references an object we can execute independently of the function Table() – does not.

Well apparently magically you can run the following.

\ef public.getrecords

And a notepad will open with the UDF code in it.

Bright people think of everything.!

Author: Mark

Mark Brooks a forty something individual working and living in and around Edinburgh