Skip to content

Instantly share code, notes, and snippets.

View Kooshaba's full-sized avatar

Andy Cernera Kooshaba

View GitHub Profile
statique / serialized_conversion.sql
Created November 2, 2012 20:42
PostgreSQL Convert Rails serialized YAML to JSON query
-- 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.
' ', ''),
'...', ''),
'---', '["'),