When you ran SELECT * FROM res_company; and saw no output, it’s not because the table is empty — it's due to how your SQL client handles certain data types. The res_company table contains fields like binary (e.g., logos) or large text/JSON, which some clients struggle to render or may suppress by default, making it appear as if there’s no data.

However, when you ran SELECT id, name FROM res_company;, you specifically requested simple, non-complex fields, which are easily displayed — confirming that the data is indeed present.

In short, the difference is due to client-side rendering limitations, not an issue with the data itself.