Re: Missing File weather.txt
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: Daniel Gustafsson <daniel@yesql.se>, davidhowes@gmail.com,
pgsql-docs@lists.postgresql.org
Date: 2025-07-05T17:29:19Z
Lists: pgsql-docs
Fujii Masao <masao.fujii@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:". regards, tom lane
Commits
-
doc: Add example file for COPY
- f6ffbeda00e0 19 (unreleased) landed
- b06a335eeb03 17.6 landed
- afd2547ac645 13.22 landed
- 6242497bb402 15.14 landed
- 409c63f9f634 18.0 landed
- 246388618cee 16.10 landed
- 01d1c45c0a8e 14.19 landed