Also you can do: "createlang plpgsql template1", which will automatically create the pgsql language for every new database.