trevor1940
asked on
PostgreSQL: cleaning cells
Hi
I have a PostgreSQL table with empty cells or cells containing '' two single quotes
so when i do
I get multiple rows because col_b has rows with nothing and rows with ''
FYI:
It was ingested from different sources 1 had col_z the other didn't
Any suggestions how to clear the cells with ''
I have a PostgreSQL table with empty cells or cells containing '' two single quotes
so when i do
SELECT DISTINCT col_a,col_b,col_c FROM my_table
I get multiple rows because col_b has rows with nothing and rows with ''
FYI:
It was ingested from different sources 1 had col_z the other didn't
Any suggestions how to clear the cells with ''
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER