Help with awk script - Mailing list pgsql-novice

Can anyone help with the following:

 

Using awk I need to replace every occurance of single quote with a double quote in the string IN ('x','y','z',......). There can be any number of elements in single quotes in between the brackets.

 

IN ('x','y','z'',...) -> IN ("x","y","z",....)

 

Thanks

Atif