Query to export to CSV

gistfile1.txt

```
COPY(SELECT rp.name AS Partner, rpa.name as Contact_Name, rpa.street, rpa.street2, rpa.city, rpa.zip, rcs.name as state, rc.name as country FROM res_partner_address rpa
JOIN res_partner rp ON rpa.partner_id=rp.id
JOIN res_country rc ON rpa.country_id=rc.id
JOIN res_country_state rcs ON rpa.state_id=rcs.id
WHERE rpa.type IS NULL AND rpa.active IS True
ORDER BY rp.name)
TO '/tmp/res_partner_address_type_null.csv' DELIMITER ',' CSV HEADER;
```