Re: 2.4 Tutorial COPY weather.txt -- From where?

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: mattsmathclassofficial(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: 2.4 Tutorial COPY weather.txt -- From where?
Date: 2025-07-17 23:30:31
Message-ID: 0f9c0f66-5c07-4694-8afa-b34cfbae7e10@oss.nttdata.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 2025/07/05 5:51, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/17/tutorial-populate.html
> Description:
>
> I'm trying to read the docs/tutorial from start to finish, and I made it to
> the end of "2.4. Populating a Table With Rows" before getting confused. and
> see `COPY weather FROM '/home/user/weather.txt';` referenced as an
> alternative example to running all the individual inserts. This confused me
> because I spent time looking for a link to download this, and eventually
> skimming through /src/tutorial/* on github, and couldn't find it anywhere.
> Now I'm thinking it doesn't exist anywhere, but it would be nice if (A) it
> was specified explicitly that this example file doesn't exist anywhere for
> download, or (B) provide a link to the github or similar where a plain text
> file can be downloaded for loading tutorial datasets.
> Thank you, and happy 4th of July

Thanks for the report! Daniel has added the weather.txt example to the docs [1].
It will appear at v17 docs on the website after the next minor release.

Regards,

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f6ffbeda00e08c4c8ac8cf72173f84157491bfde

--
Fujii Masao
NTT DATA Japan Corporation

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Shinya Kato 2025-07-18 02:35:19 Re: Document reopen of output file via SIGHUP in pg_recvlogical
Previous Message David G. Johnston 2025-07-17 13:14:15 Re: Creating Database Querry in psql CLI