Werner Fraga <werner.fraga@computalog.com> writes:
> 1. I noticed that some examples show the LANGUAGE in the CREATE FUNCTION
> command can be 'plpgsql'. However, if I try using this instead of 'sql', I get
> ERROR: Unrecognized language specified in a CREATE FUNCTION ...
You need to run the "createlang" script to install plpgsql in the
particular database you are using.
If you want plpgsql to be available by default in a given installation,
you can install it in template1 --- subsequently created DBs will be
clones of template1.
> 3. Is there anywhere I can find a list of the system tables? (that section in
> Bruce's book is still empty...)
\dS in psql...
regards, tom lane