PostgresSQL database creation

Need a procedure to create database schema as per the user_name.
1. Create a public database with sample data table.
2. Create a procedure to create a user and id.
3. Create a procedure to create a user based on user name and copy public.tables in new user schema.