SQL to handle changed screen name?

[wdavidlewis]

I recently changed my screen name for the site I play on. I have a fair amount of hand history using my old screen name and I'd love to merge it with my current hand history.

I couldn't find any way to do this in the UI (which isn't too surprising) but I figure it can be done in the database directly. I don't care if my old screen name disappears or if it has no data associated with it as long as all the hands show up under my new name. I'm comfortable issuing SQL commands (Postgres newbie but familiar with databases).

I know I can just change the hand history text files and re import them into a new database, but I was hoping for a quicker way.

Thanks.

--- David

[WhiteRider]

You can do this in the UI.
General tab, right hand side see the Alias section.
Select the player ID that you want to be your main (only) player name, and then 'edit' the alias list and add your old name as an alias. This can take a while to set up in a big DB, but after it's done your aliased name will be as quick as any other.

[wdavidlewis]

That worked great! I had seen the aliases panel, but it never occurred to me that it would work for my stats in addition to others.

Thanks so much!

--- David