@Cybrosys

as i can't post screenshot in Comment I have to use Answer option, please check it and advice.

in my Odoo 16, there is no 'customer' or 'supplier' field in res_partner as you have mentioned. i run query just copy paste yours'.

regards

Hi,
Here's an example query using the pgAdmin Query Tool to retrieve all customers and vendors:

SELECT id, name, email, phone, customer, supplier
FROM res_partner
WHERE customer = TRUE OR supplier = TRUE;

Explanation of the query:

• id: Unique identifier of the partner.
• name: Name of the partner.
• email: Email address of the partner.
• phone: Phone number of the partner.
• customer: Boolean field indicating if the partner is a customer.
• supplier: Boolean field indicating if the partner is a vendor.

This query selects the relevant fields from the res_partner table where either the customer or supplier field is set to TRUE, indicating that the partner is either a customer or a vendor.

Hope it helps.