Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to copy data form account_invoice_line table in PostgreSQL

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 195
    Comment on it

    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)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: