So, what is this blog about you ask? Good question. For many years I found blogs silly. Even the name "blog" is silly.
However in the recent years I have had more and more trouble keeping organized with my adventures through the FOSS community. Also I have
come to the realization that it is a disservice to the community to spend hours working around bugs or configuring a
software package and not spreading the learned info in some manner or another. My response to these issues is what you
now see before you. Enjoy!

I always end up having to do wacky database cleanup procedures and the power of regexes (sp?), err well, the power of regular expressions in Postgres is always great. For my own notes, splitting a combined machine and model name on the first space:

/* remove spaces from this manufacturer's name (since we are splitting on spaces)*/
UPDATE machine_model SET name = regexp_replace(name, 'pai lung', 'pai_lung');
/* set model to all text after first space in name */
UPDATE machine_model SET model = array_to_string(regexp_matches(name, E'^\\w+\\s+(.*)'),'');
/* set name to first word */
UPDATE machine_model SET name = split_part(name, ' ', 1);
/* set back */
UPDATE machine_model SET name = regexp_replace(name, 'pai_lung', 'pai lung');