The Church Brew works is a great place to go, if for nothing else, just for the atmospere. I was able to visit for dinner and a few beers on my last trip out there. (I liked all the beers I had, but my palate is not defined enough to offer any real comments) There is something about sitting in old church pews, with a waiter that looks very much like paul mcCartney scurrying out of the former confession box (now the entrance to the kitchen) with some good food and beers. The Pittsburgh Brewing company (Iron City) is actually a block down across the street from The Church. There are a few other local breweries in town, but i have never vsited or had their beer.
Primanti Brothers in The Strip District is also a good local flavor (sorta like Geno's cheesesteaks in Philly)
If you are into weird stuff, the Andy Warhol museaum is in Pittsburgh, last time I was there it was a cheap admission and the "silver cloud room" is very cool.
There are also 2 homebrew clubs in the area one is
http://trashhomebrewers.org/ and the other
http://www.trubrewers.com/ I think their sites may provide some good info on places to go.
Enjoy your visit, its a nice little city, I plan on moving back there in October!
"There is one God that is Lord over the earth, and one Captain that is lord over the Pequod."