printing a value of a variable in postgresql

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;

​x
 
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?

Answer

You can raise a notice in Postgres as follows:

raise notice 'Value: %', deletedContactId;

 
raise notice 'Value: %', deletedContactId;​

Read here

Advertisement

Answer