-- Create schema
create schema if not exists wedata_demo_schema ;

-- Create a table
CREATE TABLE wedata_demo_schema.user_info (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL
);

-- View tables in the corresponding schema
SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = 'wedata_demo_schema';

-- Insert data
INSERT INTO wedata_demo_schema.user_info (name) VALUES ('Alice'), ('Bob');

-- View data
select * from  wedata_demo_schema.user_info;