CREATE OR REPLACE FUNCTION 函數(shù)名(參數(shù)1，[整型 int4, 整型數(shù)組 _int4, …])

RETURNS 返回值類型 AS

$BODY$

DECLARE

變量聲明

BEGIN

函數(shù)體

END;

$BODY$

LANGUAGE ‘plpgsql' VOLATILE;

CREATE OR REPLACE FUNCTION create_table_for_client(id int)

RETURNS integer AS

$BODY$

DECLARE

num int4 := 0;

sql "varchar";

BEGIN

sql := 'create table _' || id || '_company(id int, name text)';

EXECUTE sql;

sql := 'create table _' || id || '_employee(id int, name text)';EXECUTE sql;

sql := 'create table _' || id || '_sale_bill(id int, name text)';EXECUTE sql;

.......

return num;

END;

$BODY$ LANGUAGE plpgsql VOLATILE