SQL Remove element from all columns on a table

Question

Hi I have a table with around 30 columns all column title have ". I will like to know if on sql have a script to replace the " for none.

Example

"ID"  |"Color"  |"Size"  | "Price" ....
 1    |  Red    |  3     |$50.00
 2    |  Blue   |  5     |$30.00

And I will like to look like:

ID  | Color  | Size  | Price ....
1   | Red    |  3    | $50.00
2   | Blue   |  5    | $30.00

Answer 1

Do like this for all columns:

ALTER TABLE blog RENAME COLUMN "ID" ID;