-
Notifications
You must be signed in to change notification settings - Fork 344
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[PATCH] A handy conninfo output #434
Comments
We purposefully do not display the full connection string during the connection, as $ usql
Type "help" for help.
(not connected)=> \c postgres://postgres:P4ssw0rd@localhost/
Connected with driver postgres (PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1))
pg:postgres@localhost=> \conninfo
Connected with driver postgres (host=localhost password=P4ssw0rd user=postgres)
pg:postgres@localhost=> |
To answer your other inquiry, there are two forms of the Connection
\c DSN connect to database url
\c DRIVER PARAMS... connect to database with driver and parameters
\Z close database connection
\password [USERNAME] change the password for a user
\conninfo display information about the current database connection Specifically, you can bypass (not connected)=> \c postgres user=postgres password=P4ssw0rd host=localhost
Connected with driver postgres (PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1))
pg:=> \conninfo
Connected with driver postgres (user=postgres password=P4ssw0rd host=localhost)
pg:=> You will need to research each underlying database drivers to figure out what the actual DSN would look like, as its different for each. For example, here's what a connection to MySQL looks like:
Note however, that my:root@localhost=> \c mysql root:P4ssw0rd@tcp(localhost:3306)/
Connected with driver mysql (11.1.2-MariaDB-1:11.1.2+maria~ubu2204)
my:=> \conninfo
Connected with driver mysql (root:P4ssw0rd@tcp(localhost:3306)/) For the most part, I would recommend using the URL form wherever possible, as it's much easier to read. |
Hi!
thank you for usql, is awesome : )
I was wandering how to change database when connected to a postgres server,
and I get that with psql we do a
\c <database_name>
.usql expects the whole db url, and I did not see a command to do the same as psql with just the db name, so I was thinking that maybe just changing the output of
conninfo
can be handy to copy paste and change the db without exiting usql.Here a patch:
so we can:
and copy paste the
\c postgres dbname=postgres host=myhost.com password=mypass port=5432 user=postgres
bit as
\c postgres dbname=mydb host=myhost.com password=mypass port=5432 user=postgres
Makes sense to you?
The text was updated successfully, but these errors were encountered: