Symptoms

How to extract data from PBA-E database to Microsoft Excel format?

Resolution

Please refer to official PostgreSQL documentation

Example:

pba=> \COPY (SELECT * from "Users") TO '/root/FILENAME.csv' WITH DELIMITER ',' CSV HEADER;

Internal content