目录
1、使用python创建uuid函数
CREATE OR REPLACE FUNCTION "public"."uuid_python"()
RETURNS "pg_catalog"."varchar" AS $BODY$
import uuid
return uuid.uuid1()
$BODY$
LANGUAGE 'plpythonu' VOLATILE COST 100
;
ALTER FUNCTION "public"."uuid_python"() OWNER TO "gpadmin";
2、调用uuid函数
CREATE OR REPLACE FUNCTION "public"."get_uuid"()
RETURNS "pg_catalog"."text" AS $BODY$BEGIN
return md5(uuid_python());
END
$BODY$
LANGUAGE 'plpgsql' VOLATILE COST 100
;
ALTER FUNCTION "public"."get_uuid"() OWNER TO "gpadmin";