diff options
-rw-r--r-- | README.rst | 87 | ||||
-rw-r--r-- | screenshots/image01.png | bin | 0 -> 82111 bytes |
2 files changed, 84 insertions, 3 deletions
@@ -1,17 +1,98 @@ A REPL for Postgres ------------------- -** _WARNING_: This is a WIP. Please DO NOT use. ** - This is a postgres client that does auto-completion and syntax highlighting. +.. image:: screenshots/image01.png Installation ============ +If you don't know how to install python pacakges, please check the `detailed instructions`__. + +__ Detailed Installation Instructions + +If you already know how to install python pacakges, then you can simply do: + :: - pip install pgcli + $ pip install pgcli + + +Detailed Installation Instructions: +=================================== + +OS X: +----- + +For installing Python pacakges it is recommended to use the package manager +called `pip`. Check if `pip` is installed on the system. + +:: + + $ which pip + +If it is installed then you can do: + +:: + + $ pip install pgcli + +If that fails due to permission issues, you might need to run the command with +sudo permissions. + +:: + + $ sudo pip install pgcli + +If pip is not installed check if easy_install is available on the system. + +:: + + $ which easy_install + + $ sudo easy_install pgcli + +Linux: +------ + + + + +Usage +===== + +:: + + $ pgcli [database_name] + + or + + $ pgcli postgresql://[user[:password]@][netloc][:port][/dbname] + +Examples: + +:: + + $ pgcli local_database + + $ pgcli postgres://amjith:pa$$w0rd@example.com:5432/app_db + + +Features +======== + +The `pgcli` is written using prompt_toolkit_. + +* Auto-completion as you type for SQL keywords as well as tables and + columns in the database. +* Syntax highlighting using Pygments. +* Smart-completion (enabled by default) will suggest context-sensitive completion. + - `SELECT * FROM <tab>` will only show table names. + - `SELECT * FROM users WHERE <tab>` will only show column names. +* Config file is automatically created at ~/.pglirc at first launch. +* Primitive support for `psql` back-slash commands. +.. _prompt_toolkit: https://github.com/jonathanslenders/python-prompt-toolkit diff --git a/screenshots/image01.png b/screenshots/image01.png Binary files differnew file mode 100644 index 00000000..58520c5f --- /dev/null +++ b/screenshots/image01.png |