如何输出大表postgresql中列与行的组合值？

CREATE TABLE combined_values (
    id SERIAL PRIMARY KEY,
    combined_value TEXT
);

INSERT INTO combined_values (combined_value)
SELECT column_name || ' - ' || row_value
FROM (
    SELECT column_name, row_value
    FROM your_large_table
    CROSS JOIN (
        SELECT unnest(ARRAY['row1', 'row2', 'row3']) AS row_value -- 替换为实际的行值
    ) AS rows
) AS combined;

SELECT * FROM combined_values;