search

frectonz / sql-studio

SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB]
https://sql-studio.frectonz.io/
MIT License
1.51k stars 26 forks source link

Postgresql connection issue #21

Closed mbecker closed 6 days ago

mbecker commented 1 week ago

Hi,

just wanted to try the sql-stido with my running postgres-docker-instance locally. The docker postgres is running and used by other local running apps (go / rust) without any problems.

I'm trying to start sql-studio as follows

sql-studio postgres postgres://username123:pasword123@localhost:5432/postgres?sslmode=disable
zsh: no matches found: postgres://username123:pasword123@localhost:5432/postgres?sslmode=disable

Suprisingly, the following connection string works:

sql-studio postgres postgres://username123:pasword123@localhost:5432/postgres
frectonz commented 6 days ago

The error is not coming from sql-studio. It's from ZSH. You need to quote the connection string. So that ZSH doesn't think you are writing a glob path.

sql-studio postgres "postgres://username123:pasword123@localhost:5432/postgres?sslmode=disable"