Postgres schemas (namespaces) are not supported

[valpackett]

Tables explicitly namespaced into schemas in PostgreSQL are not well-supported.

They are listed twice in the sidebar, and the Content tab is broken:

relation "objects" does not exist
LINE 1: SELECT * FROM objects
                      ^

(It tries to select objects instead of mf2.objects, the schema is just ignored)

[Alecaddd]

This, unfortunately, it's a limitation of the LibGDA I'm using to handle different types of DBs. I decided to use this library because offers a common interface to handle MySql/MariaDB, SQLite, and PostgreSQL, without the necessity of using standalone packages nor using unique methods per DB. It's really handy, but a bit outdated, and didn't receive any major bug fix since 2015. Gnome just moved the repo from bugzilla to GitLab, and 3 new developers started working on it. I really hope a new version will be released soon, otherwise, I have scheduled a full refactor to use standalone libraries for each DB.

Apologies for the issue, and thanks for using Sequeler.

[valpackett]

3 new developers started working on it

ooh, that sounds nice! This? It says "forked version" right now, I wonder if it will actually become the official version…

[SkyzohKey]

Can this be fixed with a patch or something? Actually ran into this issue too today :(

[Alecaddd]

Waiting for the Gnome folks to release a new version of the LibGDA

[comtom]

Same issue here. Any table that is not in the public schema cannot be inspected using the left panel. Also is not clear in the UI which table corresponds to each schema, other applications, as beekeeperstudio represents all schemas as folders and inside each schema it shows its tables.