Connect with pgcli

The pgcli client is an interactive command-line interface for Postgres that offers several advantages over the traditional psql client, including syntax highlighting, autocompletion, multi-line editing, and query history.

Installation

For installation instructions, please refer to the pgcli installation documentation.

Usage information

To view pgcli usage information, run the following command:

Connect to Neon

The easiest way to connect to Neon using the pgcli client is with a connection string, which you can obtain from the Connection Details widget on the Neon Dashboard. Select a branch, a role, and the database you want to connect to. A connection string is constructed for you.

From your terminal or command prompt, run the pgcli client with the connection string. Your command will look something like this:

Run queries

After establishing a connection, try the pgcli client by running the following queries. To test the pgcli autocompletion feature, type the SELECT query.

The following result is returned:

The pgcli query history feature allows you to use the Up and Down keys on your keyboard to navigate your query history.

The pgcli client also supports named queries. To save a query, type:

To run a named query, type:

For more information about pgcli features and capabilities, refer to the pgcli documentation.

Need help?

Join the Neon community forum to ask questions or see what others are doing with Neon. Neon Pro Plan users can open a support ticket from the console. For more detail, see Getting Support.