Connect with ``psql``
========================

``psql`` is a command line tool for PostgreSQL®, useful to manage and query your database.

Variables
'''''''''

These are the placeholders you will need to replace in the code sample:

==================      =============================================================
Variable                Description
==================      =============================================================
``POSTGRESQL_URI``      URL for PostgreSQL connection, from the service overview page
==================      =============================================================

Pre-requisites
''''''''''''''

For this example you'll need ``psql`` already installed on your computer

Connect to PostgreSQL
'''''''''''''''''''''

From your terminal, execute the following code:

.. code::
   
   psql POSTGRESQL_URI

The output should look like the following if the connection is successful:

.. code::
  
    psql (13.2, server 13.3)
    SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
    Type "help" for help.

    defaultdb=>

To confirm that the connection is working, issue the following code checking the PostgreSQL version:

.. code::

    select version();

The result will be similar to the following:

.. code::
  
                                        version
    --------------------------------------------------------------------------------------------
    PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc, a 68c5366192 p 6520304dc1, 64-bit
    (1 row)