To copy data from account_invoice_line table in account module in PostgreSQL use this code in pgadmin and user can copy data from account_invoice_line table.
Copy account_invoice_lines
copy (SELECT *
FROM
account_invoice_lines
INNER JOIN account_invoice ON account_invoice.id = account_invoice_line.invoice_id
WHERE
account_invoice.state = 'open') to E'C:\\Users\\dinesh\\Documents\\demo\\inv_lines.csv' csv HEADER
C:\\Users\\dinesh\\Documents\\demo\\inv_lines.csv = this is rhe file location
0 Comment(s)