summaryrefslogtreecommitdiffstats
path: root/README.rst
diff options
context:
space:
mode:
authorAmjith Ramanujam <amjith@newrelic.com>2014-11-30 22:02:04 -0800
committerAmjith Ramanujam <amjith@newrelic.com>2014-11-30 22:02:04 -0800
commit38aa366c9042cd3a6fbb73a77bf9a73a8e044cc5 (patch)
tree943584b142bebc43cf0ac62f5b603ec8cc7f169a /README.rst
parent60585c8856f6af917340b3736f6fb020c8ab5f9e (diff)
Update Readme.
Diffstat (limited to 'README.rst')
-rw-r--r--README.rst87
1 files changed, 84 insertions, 3 deletions
diff --git a/README.rst b/README.rst
index 00a7cdae..754f63f0 100644
--- a/README.rst
+++ b/README.rst
@@ -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