Remote Database

We can even connect to a remote postgres database using some parameters or the URL itself. 

pgcli 'postgresql://user:password@nlocalhost:port/db_name'

OR

pgcli -h localhost -U user -W '@postgres' -d db_name

We can use either of the commands to connect to a remote database in pgcli. The first command is using a single string that contains all the config data about the database and the host in a URL format. Whereas in the second command, we have to pass separate data in the form of parameters.

For further options and commands in pgcli, you can get help from the –help command:

pgcli --help 

This will result in a list of commands and options which are available in the pgcli package to be used from the command line.

Thus, we can get more options like no-password or row limit for displaying only a few records in a query and so on. 

So, pgcli is a command-line tool that can be used very similarly to the query tool in the pgAdmin provided by Postgres server. 

PGCLI is a Python package that is used as an interactive command-line interface for the PostgreSQL database server. For following with the article, make sure you have PostgreSQL installed and set up in your local system. You can follow the guide for Windows, Linux and macOS from the guide.

Also for performing any operations or testing out the package, create a simple database of your choice, There should be enough data for you to work with as it is just a REPL for running queries in a Postgres database.