Article ID: 122089, created on Jun 19, 2014, last review on Jun 19, 2014

  • Applies to:
  • Business Automation 5.5
  • Business Automation 5.4

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;

Search Words

csv

excel

data

PBA-e database

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 210d017ddc3a076d22f0f865b1cf0730 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF