注意:需要该项目绑定 TDSQL PostgreSQL 的数据源。
一、示例代码
— 创建schemacreate 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;