How do I copy data between tables PostgreSQL
This should work:
UPDATE document_invoice t1 SET company_name = t2.company_nameFROM account_company t2 WHERE t1.company_id = t2.company_id
This should work:
UPDATE document_invoice t1 SET company_name = t2.company_nameFROM account_company t2 WHERE t1.company_id = t2.company_id