Not equal and null in Postgres

You can use the “null safe” operator is distinct from instead of <>

SELECT * 
FROM "A" 
WHERE "B" is distinct from 'C'

http://www.postgresql.org/docs/current/static/functions-comparison.html

^{You should also avoid quoted identifiers. They are much more trouble then they are worth it}