Andy Cernera Kooshaba
statique
/ serialized_conversion.sql
Created
November 2, 2012 20:42
PostgreSQL Convert Rails serialized YAML to JSON query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- replace table_name with the name of your database table, e.g. users | |
| -- replace data with the serialized field in the table, e.g. nicknames | |
| -- output generates serialized data that decrypts to a Ruby array. | |
| -- data with quotes, hyphens, or spaces will have issues with this query. | |
| -- preview the YAML to JSON to confirm the conversion is working. | |
| SELECT data, REPLACE(REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(REPLACE(REPLACE(REPLACE(data, | |
| ' ', ''), | |
| '...', ''), | |
| '---', '["'), |