pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Steve Estes <denzera@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Summary of DDL/DML statement return/output values?
Date: Mon, 22 Jun 2020 13:43:48 -0400
Message-ID: <20200622174348.GA24989@alvherre.pgsql> (raw)
In-Reply-To: <CAJjrZPBH8h2nx41zfdm2_BP_f=8G==OR6or=Jgo9+FAAtjc6gw@mail.gmail.com>

On 2020-Jun-22, Steve Estes wrote:

> However, for some statements PG's output format is documented (e.g. INSERT
> <https://www.postgresql.org/docs/12/sql-insert.html;, EXPLAIN
> <https://www.postgresql.org/docs/12/sql-explain.html;), and in others it is
> not (e.g. SET <https://www.postgresql.org/docs/12/sql-set.html;, CREATE
> TABLE <https://www.postgresql.org/docs/12/sql-createtable.html;, ALTER TABLE
> <https://www.postgresql.org/docs/12/sql-altertable.html;, etc).  The
> output-control RETURNING clause gets its own page
> <https://www.postgresql.org/docs/12/dml-returning.html;, but I'm unaware of
> any other meta-summary of output values.
> 
> *Is there a summary of what PG returns in response to each of the various
> statements that it supports?  If not, should there be?*

I think starting with commit 2f9661311b83 it might be possible to create
such a table.  I'm wary of documenting this painting us into a corner
forever, though.

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f9661311b83dc481fc19f6e3bda01539...

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

view thread (5+ messages)  latest in thread

Message-ID: <20200622174348.GA24989@alvherre.pgsql>
Permalink:  ../20200622174348.GA24989@alvherre.pgsql/
Also on:    postgresql.org/message-id/20200622174348.GA24989@alvherre.pgsql

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: alvherre@2ndquadrant.com, denzera@gmail.com, pgsql-docs@lists.postgresql.org
  Subject: Re: Summary of DDL/DML statement return/output values?
  In-Reply-To: <20200622174348.GA24989@alvherre.pgsql>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox