raise notice in postgres code example

Example 1: plpgsql raise notice

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

Example 2: 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;

Tags:

Misc Example

Related