[GENERAL] Check if language is installed

[Andrus]

My script running as superuser needs to install plpgsql using
CREATE LANGUAGE plpgsql;


in 8.2+

Which is the best way to check that this command does not cause error ?

Is it best to use 

select true from pg_language where lanname='plpgsql'

for checking for plpgsql existance  before running CREATE LANGUAGE ?

Andrus.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster