Database Reference
In-Depth Information
We then proceed to use the function to do the transformation:
INSERT INTO application_settings_new
SELECT (
flatten_application_settings(version)).*
FROM (
SELECT version
FROM application_settings_old
GROUP BY version)
And violá! The data is now available in tabular form in the new table structure.
