![]() | \copy to/from | Copy data between a file and a table. | \c database_name | Change to a new database. | \T | Change the table format used to output results | ssh-tunnel TEXT Open an SSH tunnel to the given address and warn Warn before running a destructive query. ![]() ![]() The result is wider than the terminal width. auto-vertical-output Automatically switch to vertical output mode if l, -list list available databases, then exit. prompt-dsn TEXT Prompt format for connections using DSN aliases less-chatty Skip intro on startup and goodbye on exit. row-limit INTEGER Set threshold for row limit prompt. list-dsn list of DSN configured into the D, -dsn TEXT Use DSN configured into the section d, -dbname TEXT database name to connect to. single-connection Do not use a separate connection for completions. w, -no-password Never prompt for password. u, -user TEXT Username to connect to the postgres database. U, -username TEXT Username to connect to the postgres database. p, -port INTEGER Port number at which the postgres instance is h, -host TEXT Host address of the postgres database. doneįound existing installation: psycopg2 2.9.1 Successfully uninstalled importlib-metadata-4.8.1 Successfully uninstalled typing-extensions-3.10.0.2įound existing installation: importlib-metadata 4.8.1 Installing collected packages: typing-extensions, importlib-metadata, click, Pygments, sqlparse, configobj, pytzdata, pendulum, prompt-toolkit, setproctitle, tabulate, cli-helpers, psycopg2, pgspecial, pgcliįound existing installation: typing-extensions 3.10.0.2 Requirement already up-to-date: zipp>=0.5 in /usr/local/lib/python3.6/site-packages (from importlib-metadata python_version click>=4.1->pgcli)Ĭollecting typing-extensions>=3.6.4 python_version click>=4.1->pgcli) Requirement already up-to-date: wcwidth in /usr/local/lib/python3.6/site-packages (from prompt-toolkit=2.0.6->pgcli)Ĭollecting tabulate>=0.8.2 (from cli-helpers>=2.2.1->pgcli) Requirement already up-to-date: python-dateutil=2.6 in /usr/local/lib/python3.6/site-packages (from pendulum>=2.1.0->pgcli) ![]() I'm happy you're taking on this challenge and I'll be glad to give you pointers on how the sql completion engine works in pgcli and mycli.WARNING: Running pip install with root privileges is generally not a good idea. I still don't have complete parity but it is close enough that users don't feel like their compromising a lot. I didn't think I could do a good enough job of maintaining parity with psql and mysql's default client if I had a universal client. This is just my guess and I don't have data to back this up.Ĥ. The code complexity needed to support multiple database backends would make it hard for a newcomer to contribute to the project. Even for the minority that do, I tried to keep pgcli and mycli behave similarly so they can switch between them seamlessly.ģ. There wasn't a huge overlap in users who use Postgres and Mysql at the same time. The same is true for mysql as well (such as `\u`).Ģ. So you can't simply send `\dt` to the database. Psql comes with backslash commands that are implemented at the client level and not in the database. I was tempted to write a universal cli that supported both postgres and mysql, but then I decided to keep them separate for the following reasons:ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |