-- 创建库
CREATE DATABASE wedata_demo_db;

-- 创建schema
CREATE SCHEMA demo;

-- 创建表
CREATE TABLE demo.user_info (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL
);

-- 插入数据
INSERT INTO demo.user_info (name) VALUES ('Alice'), ('Bob');


-- 查看数据
select * from  demo.user_info;

-- 查看对应库的schema 
SELECT schema_name 
FROM information_schema.schemata 
WHERE catalog_name = 'wedata_demo_db';

-- 查看对应schema中的表
SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = 'demo';