search

jorgerojas26 / lazysql

A cross-platform TUI database management tool written in Go.
MIT License
916 stars 51 forks source link

how to setup postgres schema? #106

Open notsungod opened 2 months ago

notsungod commented 2 months ago

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 commented 2 months ago

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

notsungod commented 2 months ago

yes I get this problem on the latest version.

jorgerojas26 commented 2 months ago

Can you show the schema and table name?

notsungod commented 1 month ago

Sorry for the delay. Here you go Screenshot_2024-10-07_14-08-25_1_1_1.png

Screenshot_2024-06-18_23-17-35_1_1.png

jorgerojas26 commented 1 month ago

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

teto commented 3 weeks ago

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