Sample Header Ad - 728x90

PostgreSQL 8.4: How to tell if a procedural language is installed or not?

6 votes
1 answer
5198 views
I have a setup program that requires plpgsql to install stored procedures in a PostgreSQL 8.4 database. I need to make sure the language is installed or the app will fail. I don't want to drop the language and re-add it, as that could screw some other things up. Is there a way to install the language "gently"? CREATE LANGUAGE IF NOT EXISTS does not appear to be valid.
Asked by Jeremy Holovacs (1271 rep)
Feb 24, 2013, 04:21 PM
Last activity: Jan 19, 2018, 02:00 AM