You can add pgsql in postgres' template, so every DB'll have this language added.
To do this simply type as the DBA user:
<blockquote>createlang plpgsql template1
</blockquote>
To check if you have pgsql language type
<blockquote> createlang -l template1
</blockquote>
Procedural languages
Name | Trusted?
---------+----------
plpgsql | t
(1 row)
If you want to see if have pgsql in a specific Database (DBNAME), type
<blockquote> createlang -l DBNAME
</blockquote>
Bye
Giampiero
