Create first_name and last_name from full_name in a Rails migration
<p>I have a table (People) with a full name column, but want to split it into a first name (and initial if it exists) column and last name column.</p>

<p>It's a PostgreSQL database FWIW. I'm at the point of creating the columns, so it can all be done in the migration if that's possible. The names all fit the old standard American style, that is, no compound names or hyphens. No periods after the initials and some of the first names are initials only. This will be a one shot change, and then any new entries will be First and Last names in their separate fields. The full name field will be dropped.</p>

<p>Thanks for any help</p>