Is sodium penthotal ever used anymore for something like psychiatry?

Very rarely now. Sodium Pentothal is a short-acting barbiturate popularly known as "truth serum" -- and still used in anesthesia. For a time it was administered in some psychiatric situations, such as trauma. However, the results may be unreliable because the patient will go along with leading questions. It's hard to tell true from false statements. A false memory syndrome can sometimes result.
No. No. It is not used any more. This anesthetic medication is very dangerous for many different reasons. Fyi: it is very similar to the drug that killed michael jackson! for more specific answers to your particular need, please call and speak with a doctor.