![]() ![]() PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE). Pgcli also supports many of the same environment variables as psql for login options (e.g. 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. $ pgcli postgres://amjith: :5432/app_db?sslmode=verify-ca&sslrootcert=/myrootcert psycopg2 2.8 has fixed these problems, and will build from source. There are some known issues with the psycopg2 2.7 binary - see the psycopg docs for more information about this and how to force installation from source. If you are restricted to using psycopg2 2.7.x then pip will try to install it from a binary. If you don't know how to install python packages, please check the detailed instructions. $ sudo apt-get install pgcli # Only on Debian based Linux (e.g. ![]() If you already know how to install python packages, then you can simply do: $ pip install -U pgcli This is a postgres client that does auto-completion and syntax highlighting. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |