Subject: Re: "there is no way to insert less than one row"
To: Alvaro Herrera <alvherre@alvh.no-ip.org>,
 "David G. Johnston" <david.g.johnston@gmail.com>
Cc: max1@inbox.ru, Pg Docs <pgsql-docs@lists.postgresql.org>
References: <20210324235502.GA19006@alvherre.pgsql>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Message-ID: <d0b1dfee-0bd4-195b-c4ef-8ab7bf42de69@enterprisedb.com>
Date: Wed, 7 Apr 2021 13:54:34 +0200
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0)
 Gecko/20100101 Thunderbird/78.9.0
MIME-Version: 1.0
In-Reply-To: <20210324235502.GA19006@alvherre.pgsql>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/d0b1dfee-0bd4-195b-c4ef-8ab7bf42de69%40enterprisedb.com>
Precedence: bulk

On 25.03.21 00:55, Alvaro Herrera wrote:
> : When a table is created, it contains no data. The first thing to do
> : before a database can be of much use is to insert data. Data is
> : inserted one row at a time. Of course you can also insert
> : more than one row in a single command, but it is not possible to
> : insert something that is not a complete row.
> : Even if you know only some column values, a complete row is created.
> 
> The next paragraphs explain that omitted columns are defaulted, which
> IMO flows neatly from here.

done that way