postgresql raise exception

-- Simple exception:
RAISE EXCEPTION 'This user role does not exist.';

-- This example will abort the transaction with the given error message and 
-- hint:
RAISE EXCEPTION 'Nonexistent ID --> %', user_id
      USING HINT = 'Please check your user ID';

-- These two examples show equivalent ways of setting the SQLSTATE:
RAISE 'Duplicate user ID: %', user_id USING ERRCODE = 'unique_violation';
RAISE 'Duplicate user ID: %', user_id USING ERRCODE = '23505';

-- There is a second RAISE syntax in which the main argument is the condition 
-- name or SQLSTATE to be reported, for example:
RAISE division_by_zero;
RAISE SQLSTATE '22012';

-- In this syntax, USING can be used to supply a custom error message, detail, 
-- or hint. Another way to do the earlier example is
RAISE unique_violation USING MESSAGE = 'Duplicate user ID: ' || user_id;

Add Own solution

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

raise error postgresql raise statement -- postgresql postgresql raise throw exception postgresql throw exception in function postgresql postgres dont throw exception postgresql if then throw exception in function postgresql throw exception in function how to throw error in postgresql postgres raise info postgresql raise exception in trigger raise postgres raise exception sql postgresql raise in postgresql postgresql function handle exception postgresql function exception postgresql raise exception and catch php postgresql raise exception using errcode postgresql procedure raise exception raise exception postgres psql raise exception raise exception psql postgres function raise exception postgresl raise postgresql raise info example raise exception with variable postgrs postgres error when using with postgres raise in function postgres raise exception example postgresql error force raise error postgres raise psql raise pslq raise error in procedure pgsql postgres trigger raise sqlstate raise exception postgresql postgresql throw exception postgres check throw custom error postgres Include Error Detail example postgres specify include error detail RAISE EXCEPTION plpgsql postgres throw exception postgres raise error raise error in postgresql with seterror equivalent in postgres with seterror in postgres postgresql raise error postgresql custom exception for check errors pgadmin function throw exception postgres raise exception postgres procedure raise exception postgres raise exception format raise postgresql postgres raise postgresql raise exception

postgresql raise exception

Welcome Back!

Create a Free Account