-- Create a database
CREATE DATABASE wedata_demo_db;

-- Create schema
CREATE SCHEMA demo;

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

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


-- View data
select * from  demo.user_info;

-- View the schema of the corresponding database 
SELECT schema_name 
FROM information_schema.schemata 
WHERE catalog_name = 'wedata_demo_db';

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