A bit of background first.
I have a PostGres DB with PostGIS, I also have ArcSDE installed in this DB and all feature classes created through ArcSDE are using the PG_Geometry. Everything works well!
Over the next twelve months I will be looking at getting all of my desktop and web clients away from esri products to open source equivalents which for me means i'll be free of ArcSDE at last (I'm not an esri basher, I enjoy working with esri products but I can't justify the existance of ArcSDE doing something that should be free). Anyway I want to know if there is a way which I can "uninstall" ArcSDE from PostGres? I know that if the ArcSDE tables are left there users wont notice a difference but from an admin perspective it would be much nicer and tidier.
Has anyone done this in the past? Any tips or experiences?