I see that I can format 999-999-9999 for a phone but how do I format for email when doing a create table? I have email varchar(50). Can I do format '@'
Why do you want to format an email address, it's only a string?
A valid email should already include the @ and if you stored both parts separately you simply concat:
local_part || '@' || domain_part