Re: Missing File weather.txt

2025-07-12 Thread Daniel Gustafsson
> On 12 Jul 2025, at 18:41, Tom Lane wrote: > > Daniel Gustafsson writes: >> Or perhaps ”values are separated by a tab character”? > > WFM Thanks, I'll get this pushed once the freeze is over on REL_18_STABLE. -- Daniel Gustafsson

Re: Missing File weather.txt

2025-07-12 Thread Tom Lane
Daniel Gustafsson writes: > Or perhaps ”values are separated by a tab character”? WFM regards, tom lane

Re: Missing File weather.txt

2025-07-12 Thread Daniel Gustafsson
> On 12 Jul 2025, at 18:23, Tom Lane wrote: > > Fujii Masao writes: >>> On 2025/07/12 7:18, Daniel Gustafsson wrote: >>> It should, fixed in v3. > >> LGTM. Thanks! > > I'm okay with this too. I find myself niggling a bit at the > parenthetical remark "the white space on each line is actually

Re: Missing File weather.txt

2025-07-12 Thread Tom Lane
Fujii Masao writes: > On 2025/07/12 7:18, Daniel Gustafsson wrote: >> It should, fixed in v3. > LGTM. Thanks! I'm okay with this too. I find myself niggling a bit at the parenthetical remark "the white space on each line is actually a tab character". There's several tabs on each line, so use o

Re: Missing File weather.txt

2025-07-11 Thread Fujii Masao
On 2025/07/12 7:18, Daniel Gustafsson wrote: On 11 Jul 2025, at 01:36, Fujii Masao wrote: Since the prcp column isn't specified, its value is NULL. So shouldn't the fourth field in the data line above be \N instead of 0.0? It should, fixed in v3. LGTM. Thanks! Regards, -- Fujii Masao

Re: Missing File weather.txt

2025-07-11 Thread Daniel Gustafsson
> On 11 Jul 2025, at 01:36, Fujii Masao wrote: > Since the prcp column isn't specified, its value is NULL. So shouldn't > the fourth field in the data line above be \N instead of 0.0? It should, fixed in v3. -- Daniel Gustafsson v3-0001-doc-Add-example-file-for-COPY.patch Description: Binary

Re: Missing File weather.txt

2025-07-10 Thread Fujii Masao
On 2025/07/11 7:22, Daniel Gustafsson wrote: On 5 Jul 2025, at 19:29, Tom Lane wrote: Fujii Masao 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

Re: Missing File weather.txt

2025-07-10 Thread Daniel Gustafsson
> On 5 Jul 2025, at 19:29, Tom Lane wrote: > > Fujii Masao 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

Re: Missing File weather.txt

2025-07-05 Thread Tom Lane
Fujii Masao 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

Re: Missing File weather.txt

2025-07-05 Thread Fujii Masao
On 2020/01/28 19:18, Daniel Gustafsson wrote: On 28 Jan 2020, at 03:22, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-populate.html Description: On this page https://www.postgresql.org/docs/

Re: Missing File weather.txt

2020-01-28 Thread Daniel Gustafsson
> On 28 Jan 2020, at 03:22, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/tutorial-populate.html > Description: > > On this page https://www.postgresql.org/docs/12/tutorial-populate.html you > hav

Missing File weather.txt

2020-01-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-populate.html Description: On this page https://www.postgresql.org/docs/12/tutorial-populate.html you have this command: COPY weather FROM '/home/user/weather.txt'; I've searche