> On 5 Jul 2025, at 19:29, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Fujii Masao <masao.fu...@oss.nttdata.com> writes: >> On 2020/01/28 19:18, Daniel Gustafsson wrote: >>> This is only mentioned as an example of another input method, with a link to >>> the COPY page for more information. That being said, it's a good thing for >>> a >>> tutorial to be self-contained, and going from a basic tutorial to the COPY >>> reference page is a fairly large step. I propose that we add a small >>> example >>> on what weather.txt could look like as per the attached diff. > >> Sorry for reviving this old thread, but I wanted to follow up since >> the same issue was reported again in [1], and the proposed patch >> basically looks good to me. > > +1 > >> In the tutorial, three rows are inserted using INSERT, so shouldn't >> the sample input for COPY include all three, like this? > > Agreed, the example file should match what the tutorial expects to be > in the table. I'd include text along the lines of "The data inserted > above could also be inserted from a file containing:".
The attached v2 adds the missing line, and tweaks the text added to document the file. Since there have been reports I propose backpatching this all the way down to 13 while at it. -- Daniel Gustafsson
v2-0001-doc-Add-example-file-for-COPY.patch
Description: Binary data
