Community mailing list archives

Re: How to import data from postgresql to excel

- 06/30/2015 08:16:07

If you want data directly from postgresql, you will want to log in to psql and do a query like the following:

COPY (SELECT, from sale_order s LEFT JOIN res_partner p on TO '/tmp/cust-sale.csv' CSV HEADER;

That query will give you the customer name and the sales order number/name and the resulting file can be exported to excel.  See also this stack overflow question and answer:

If, however, you want to just export a certain list view, check out:

Best of luck!
~John Walsh

On Tuesday, June 30, 2015 7:15 AM, Sayali Kothawade <> wrote:

        I am trying to import data from Postgresql from sales modules to excel.
I want data from customers and sales order on a single excel sheet. 
Can you please suggest me any solution?

Thanks & Regards,
Sayali Kothawade.
Ayanworks Technolgy Solutions Pvt. Ltd.
Post to: