how to setup postgres schema?

[notsungod]

i use postgres://user:pw@localhost/db?sslmode=disable&search_path=schema as my url.
But when i connect and try to open a table i get a red popup with error message table must be in the format schema.table` . What am I doing wrong or how can i fix this? Thank you!

[jorgerojas26]

What version of lazysql are you on? Make sure you are on the latest version, which right now is the v0.2.9.

[notsungod]

yes I get this problem on the latest version.

[jorgerojas26]

Can you show the schema and table name?

[notsungod]

Sorry for the delay. Here you go

[jorgerojas26]

Ok, i think i know what is the problem. I'll fix it soon.

[teto]

0.2.9 on nixos. Same problem. I can browse the database with dbeaver just fine but lazysql shows me no result, just the error already reported here.

EDIT: same problem with 0.3.0

[jorgerojas26]

I think this is related to how the tree works for postgres. For Postgres, there must be 3 levels in the tree, i only see 2 in your screenshot. I'm not sure why, but i think that is the problem.

Of course it is a LazySQL problem, the tree needs a refactor. Just wanted to let you know that, maybe you can find a workaround until the refactor is done.