TDSQL PostgreSQL

-- 创建schema
create schema if not exists wedata_demo_schema ;

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

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

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

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