Not equal and null in Postgres
Solution 1:
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