ODBC access to tables like I see on-line

Baserow Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

What do you need help with?

When I use ODBC on the postgresql database I am facing the internal design of how Baserow structures the storage of the data - table and field numbers instead of my names for example - and - some data fields seem missing - like stored “off table” it seems.
Is there any way Baserow could generate a script - available on demand - that “assembles” the table into what I see online as a “real-time” View - and then I can use ODBC and say MS access against that?

2

Hi @mikemitch,

nothing stops you to access Baserow tables, but as you already discovered, Baserow uses its own internal structure to handle the data. It is therefore not straightforward or easy to query Baserow in this way.

Unfortunately it is not really feasible to provide what you are asking for. Depending on the use case you have, you will be better off accessing data through Baserow HTTP API, or export data in CSV and do some analysis this way.