printing a value of a variable in postgresql

Question

I have a postgresql function  CREATE OR REPLACE FUNCTION fixMissingFiles   RETURNS VOID AS    DECLARE     deletedContactId integer      BEGIN             SELECT INTO deletedContactId contact id FROM myContacts WHERE id 206351               -- print the value of deletedContactId variable to the console      END     LANGUAGE plpgsql    How can I print the value of the deletedContactId to the console

User · Accepted Answer

You can raise a notice in Postgres as follows   raise notice  Value      deletedContactId    Read here

[sql] printing a value of a variable in postgresql

Examples related to sql

Examples related to postgresql