Clubbing while pregnant!

Okay so my husbands 21st birthday is next month and at that time I'll be 6 and a half months pregnant. His brother and his brothers wife want us to come to NY to celebrate it and want to go out to a club or roof top lounge type of thing with drinks and stuff that overlooks the city. And I just feel so uncomfortable going and I feel like it's kind of selfish of him to really really want me to do that. What do you guys think?