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?
Advertisement
Answer
You can raise a notice in Postgres
as follows:
raise notice 'Value: %', deletedContactId;
Read here