/SQL/Trigger in postgresql to change incoming entry

Trigger in postgresql to change incoming entry

CREATE or REPLACE FUNCTION func()
RETURNS TRIGGER
AS $$
BEGIN
NEW.columnname = 0;
RETURN NEW;
END;
$$
LANGUAGE plpgsql;

-- Statement to make trigger to execute above code --
CREATE TRIGGER change_incoming BEFORE INSERT on Tablename 
FOR EACH ROW EXECUTE PROCEDURE func();

Similar codes

0 vote123 views1 answer
Query for backup a database at another location in file system
SQL
13 votes235 views4 answers
Sql joining 3 tables
SQL
28 votes122 views6 answers
Foreign key
SQL
0 vote131 views1 answer
How to fetch data from database in sql
SQL
0 vote118 views1 answer
H2 auto increment and unique
SQL
0 vote101 views1 answer
Dnsmasq.conf location macos
SQL
0 vote120 views1 answer
Drop unique
SQL
0 vote111 views1 answer
What is the use of index in mysql table
SQL
0 vote106 views1 answer
Sql pivot without aggregate
SQL
14 votes121 views2 answers
Install mysqldump
SQL