change null to 0 in SQL script

I like to change a null value of a query to 0 in the SQL script. I know how
to do it in MS-SQL server and MS-Access but those commands does not work in
pg-sql.

Anyone has any ideas?

Thanks