官术网_书友最值得收藏!

Moving functions to other schemas

As with many other database objects, it is possible to place a function into a schema that is different from the default one, which is public. All we need to do is either fully qualify the name of the function at the time it is created or issue an ALTER FUNCTION command.

Listing 19 shows the two ways to add the function f_greetings() to the schema my_library:

  1. By declaring the function with the schema qualifier before its name, such as my_library.f_greetings
  2. By issuing an ALTER FUNCTION SET SCHEMA command to move the function from one schema to another
      -- first ensure there is the schema
testdb=> CREATE SCHEMA my_library;
-- and then add the function to the schema
testdb=> CREATE OR REPLACE FUNCTION
my_library.f_greetings( who text )
RETURNS text AS $code$
BEGIN
RETURN 'Hello dear ' || who;
END $code$ LANGUAGE plpgsql IMMUTABLE;

-- or to move an already existing function
testdb=> ALTER FUNCTION f_greetings( text ) SET SCHEMA my_library;
Listing 19:  Declaring a function in a specific schema

For security reasons, it is not possible to change the schema of an existing function into the pg_temp one, since this would transform the function into a temporary one. Similarly, a function that has been already defined as temporary cannot be moved to a non-temporary schema.

主站蜘蛛池模板: 关岭| 霸州市| 临江市| 海南省| 阳山县| 梓潼县| 从化市| 全南县| 睢宁县| 库车县| 滕州市| 忻州市| 临武县| 施甸县| 万载县| 肇源县| 巴楚县| 营口市| 洛扎县| 宿迁市| 绵竹市| 福清市| 历史| 儋州市| 阜新| 大同县| 韶关市| 屏南县| 徐闻县| 永善县| 苗栗县| 高碑店市| 岢岚县| 辽中县| 泰安市| 通山县| 平乐县| 西乡县| 昌江| 明光市| 宜兴市|