I have a populated table in PostgreSQL. I added a text column after the table was populated. Viewing the table data, the text column is blank for all rows. I'd like to query for these blank rows, but select * from "my_table" where "my_column" = ''; doesn't work (returns nothing), and neither does select * from "my_table" where "my_column" = NULL;
How can I query to match rows where this new text column is empty?
