"Drinkin' beer in a caberet and was I havin' fun......lay that pistol down"....?

Okay, fellow "Golden (barf) Agers" ( hee hee) Whats the name of this song? I got in trouble for singing the complete words around adults when I was about 4 years old, and my goodness, how times have changed!