Installing PostgreSQL Procedural Languages
April 1st, 2011
According to PostgreSQL docs, “A procedural language must be “installed” into each database where it is to be used. But procedural languages installed in the database template1 are automatically available in all subsequently created databases. So the database administrator can decide which languages are available in which databases and can make some languages available by default if he chooses.”
su - postgres createlang plpgsql template1
Leave a Reply