PostgreSQL - Language pgplsql does not exist despite running CREATE LANGUAGE

Question

I just tried to create my first plpgsql function. When executing the script, I get

ERROR: language "‘plpgsql’" does not exist

I then run the command CREATE LANGUAGE plpgsql; which shows the following error:

ERROR: language "plpgsql" already exists

Commands are being run on the same database.

Regards

Peter

Answer 1

use this command:

$: createlang -d dbname plpgsql