I admire your honesty. Most fellas I know would have lied and said their girlfriend did it!
I once did exactly the same thing on a bollard in Greenwich. Saw it, got in, drove into it (WTF??) just think, in six months time the way you feel now will be a distant memory - dont beat yourself up about it