如何在postgresql查询中将行转换为列

CREATE EXTENSION IF NOT EXISTS tablefunc;

CREATE TABLE your_table (
    category text,
    attribute text,
    value text
);

INSERT INTO your_table VALUES
    ('Category1', 'Attribute1', 'Value1'),
    ('Category1', 'Attribute2', 'Value2'),
    ('Category2', 'Attribute1', 'Value3'),
    ('Category2', 'Attribute2', 'Value4');

CREATE VIEW view_name AS
SELECT category, attribute, value
FROM your_table;

SELECT *
FROM crosstab(
    'SELECT category, attribute, value
     FROM view_name
     ORDER BY 1',
    'SELECT DISTINCT attribute
     FROM view_name
     ORDER BY 1'
) AS ct(category text, attribute1 text, attribute2 text);

 category  | attribute1 | attribute2
-----------+------------+------------
 Category1 | Value1     | Value2
 Category2 | Value3     | Value4