Creating pl/pgSQL functions is easy:
CREATE FUNCTION.... Inspecting those functions six months later, after you’ve forgotten what’s in them? Turns out that that’s easy too. To inspect the SQL behind a function named, say,
\df+, like so:
dbname=# \df+ foo
This will print out, among other things,
foo’s source code.
« Back to notes