pgsql raise notice code example

Example 1: raise notice in postgresql function

RAISE INFO 'Hello World !';
RAISE NOTICE '%', variable_name;
RAISE NOTICE 'Current value of parameter (%)', my_var;
RAISE EXCEPTION '% cannot have null salary', EmpName;

Example 2: plpgsql raise notice

RAISE NOTICE 'Calling cs_create_job(%)', v_job_id;

Tags:

Sql Example

Related