how to create a new table dynamically from the users table in authentication??

This isn't something you would normally do with a relational database. You normally create your tables in a way to share amongst users. Can you give more detail on what you are trying to do and someone will be able to advice better.

I want to export the emails from the users table in authentication section. I have a profiles table which contains other data except emails. So that's why. Is there any way I can do that?

Create a function and call it with

.rpc