Alcohol is such a destructive chemical poison to the mind (as well as the body), that I cannot see a situation where a Dr, in particular a Dr who specialises in the mind, would suggest you continue to drink. It actually causes suicidal ideation in people who abuse it, it doesn't lessen suicidal thoughts. Alcohol in fact is so detrimental to ones mind that pysc doctors for the NHS in England will not treat people under the influence of alcohol, you simply can't get a referral to be seen by one until you sober up. So either you haven't told him the full story of your alcohol abuse so he does not understand the gravity of the issue, or you need a new Dr because your current one has some warped view on alcohol and the effects.
From your posts, you sound like a typical case of an alcoholic / alcohol dependent person, and in this case the only answer is abstinence. Moderation is impossible. The quicker you can accept this and build a life without alcohol, the better and less pain you will go through. It took me many relapses before I accepted that I cannot drink safely. I would be sober for a month or two and think I have it nailed. I still might not have it nailed, I am not out of the woods either myself. I have one drink and I then want many drinks, and then all the consequences begin again.