Postgres partitions showing as individual tables

Is anyone else using Postgres for their database? I can connect to mine just fine, but just realized that I can only see tables from the public schema. I have very important tables in the other schema, but I cannot see them in the “select structures” area of the data connector.

Update: Found this:

Now I can see the tables, BUT my partitioned table is showing up as hundreds of individual tables instead of one.

Well, that was a fun post. Solved it myself in 20 minutes by playing with things. The partitions are all that show up, yes, so you can’t drag and drop them into a data cube and get all the data. But you CAN still just query the main table and it works. A bit annoying, but in the end it works.

Perhaps a feature request there: show the main partitioned table, rather than its partitions.

1 Like