Unable to see all data in postgres db form_field_values table

[mathieubossaert]

@MinimalPotato

I'd recommend avoiding this approach if possible, since the internal schema could change with future updates.

I can't agree more. And even if you do, querying xml fields in SQL is not that fun.
See our own experience here : SQL first try to get Central data into internal PostGIS database

@MinimalPotato

A more stable and supported way to manage or retrieve data is through the ODK Central's front-end or its REST API (especially if you are developing something, explore pyODK as well) or maybe OData connection.

If you want to use SQL to query your data, as I love to, you can check this ODATA integration within pl-python functions : Pl-pyodk : use of pyODK with PL/Python PostgreSQL functions to pull data from Central into your own database