postgresql 是否有数据可视化工具也能够显示模式间关系 [关闭]

# PostgreSQL数据可视化工具及模式关系展示

sql
-- 创建模式及表
CREATE SCHEMA sales;
CREATE TABLE public.products (
    product_id SERIAL PRIMARY KEY,
    product_name VARCHAR(255) NOT NULL
);
CREATE TABLE sales.orders (
    order_id SERIAL PRIMARY KEY,
    product_id INT REFERENCES public.products(product_id),
    order_date DATE NOT NULL
);
-- 插入示例数据
INSERT INTO public.products (product_name) VALUES ('Laptop'), ('Phone');
INSERT INTO sales.orders (product_id, order_date) VALUES (1, '2023-01-01'), (2, '2023-01-02');

sql
SELECT
    'public.products'::regclass AS table_from,
    'sales.orders'::regclass AS table_to,
    'product_id' AS field_from,
    'product_id' AS field_to
;