/SQL/Raise notice in postgresql function

Raise notice in postgresql function

Postgres raise notice

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

Source: dbrnd.com

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;

Similar codes

1 vote241 views1 answer
List all triggers in SQL Server
SQL
1 vote252 views1 answer
Add multiple row table pl sql
SQL
0 vote240 views1 answer
Default password for mysql_secure_installation in mac
SQL
37 votes308 views6 answers
Mysql update
SQL
0 vote222 views1 answer
Stop psql server windows
SQL
11 votes236 views1 answer
Ddl materialized view
SQL
10 votes228 views1 answer
Dba_dependencies
SQL
0 vote245 views1 answer
Mysql terminal run sql file
SQL
0 vote228 views1 answer
Sql select column names starting with
SQL
2 votes234 views1 answer
Oracle drop table free up space
SQL