如何在postgres中创建具有动态值的表和插入数据

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name VARCHAR(50)
);

INSERT INTO users (name) VALUES ('John');

CREATE OR REPLACE FUNCTION create_dynamic_table_and_insert_data(table_name VARCHAR, column_name VARCHAR, column_type VARCHAR, column_value VARCHAR)
RETURNS VOID AS $$
BEGIN
  -- 创建表
  EXECUTE 'CREATE TABLE ' || table_name || ' (' || column_name || ' ' || column_type || ')';

  -- 插入数据
  EXECUTE 'INSERT INTO ' || table_name || ' (' || column_name || ') VALUES (' || quote_literal(column_value) || ')';
END;
$$ LANGUAGE plpgsql;

SELECT create_dynamic_table_and_insert_data('dynamic_table', 'column1', 'VARCHAR(50)', 'Hello');