postgres:在一个表中插入多行，如果不存在，则插入到其他表中

INSERT INTO target_table (column1, column2, ...)
SELECT value1, value2, ...
FROM source_table
WHERE condition;

CREATE OR REPLACE FUNCTION insert_data(data_table_name TEXT, column1_type datatype, column2_type datatype, ...)
RETURNS VOID AS $$
BEGIN
    IF EXISTS (SELECT 1 FROM target_table) THEN
        INSERT INTO target_table (column1, column2, ...)
        SELECT value1, value2, ...
        FROM source_table;
    ELSE
        INSERT INTO other_table (column1, column2, ...)
        SELECT value1, value2, ...
        FROM source_table;
    END IF;
END;
$$ LANGUAGE plpgsql;