Hello! Am Sonntag, dem 14.04.2024 um 20:54 +0000 schrieb M Sarwar: > Hi, > I am working CROSSTAB functionality to generate the reports in the > CSV format. > > Now I have stage where I need to generate 2 result sets for the same > 1 column data. Something like "CREATE VIEW"? The documentation has some useful examples: https://www.postgresql.org/docs/current/sql-createview.html "CREATE PROCEDURE" and "CREATE FUNCTION" are rarely covered by tutorials, so I mention them. They can be used in a similar manner. For CSV, I'm the wrong person. I'd code it in C/C++. Regards, Andreas Wagner
