install

来自「关系型数据库 Postgresql 6.5.2」· 代码 · 共 23 行

Installation of PL/pgSQL


1)	Type 'make' to build the shared plpgsql object.

2)	Type 'make install' to install the shared object in
	the PostgreSQL library directory.

3)	Declare the PL/pgSQL procedural language in your
	database by

		psql dbname <mklang.sql

	If the PostgreSQL library directory is different from
	/usr/local/pgsql/lib you must edit mklang.sql prior.

	If you declare the language in the template1 database,
	any subsequently created database will have PL/pgSQL
	support installed automatically.