.. highlight:: psql
.. _ref-show:

===========================
``SHOW (session settings)``
===========================

The ``SHOW`` statement can display the value of either one or all session
setting variables. Some of these can also be configured via
:ref:`SET SESSION <ref-set>`.

.. NOTE::

   The ``SHOW`` statement for session settings is unrelated to the other ``SHOW``
   statements like e.g. ``SHOW TABLES``.

.. rubric:: Table of contents

.. contents::
   :local:

Synopsis
========

::

    SHOW { parameter_name | ALL }


Parameters
==========

:parameter_name:
  The name of the session setting which should be printed. See :ref:`conf-session`
  for available session settings.

:ALL:
  Show the values of all settings.
