Date: Mon, 18 Dec 2023 16:06:21 +0100
From: Christoph Berg <myon@debian.org>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: psql JSON output format
Message-ID: <ZYBf7fD8vTb7DHZ2@msg.df7cb.de>
References: <ZYBdnGW0gKxXL5I_@msg.df7cb.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <ZYBdnGW0gKxXL5I_@msg.df7cb.de>
Archived-At: <https://www.postgresql.org/message-id/ZYBf7fD8vTb7DHZ2%40msg.df7cb.de>
Precedence: bulk

Re: To PostgreSQL Hackers
> On the command line, the format is selected by `psql --json` and `psql -J`.

Among other uses, it enables easy post-processing of psql output using `jq`:

$ psql -lJ | jq
[
  {
    "Name": "myon",
    "Owner": "myon",
    "Encoding": "UTF8",
    "Locale Provider": "libc",
    "Collate": "de_DE.utf8",
    "Ctype": "de_DE.utf8",
    "ICU Locale": null,
    "ICU Rules": null,
    "Access privileges": null
  },
...
]

Christoph