From: Daniel Gustafsson <daniel@yesql.se>
Message-Id: <D49B15F0-46BA-4D97-9475-BBF28B855214@yesql.se>
Content-Type: multipart/mixed;
	boundary="Apple-Mail=_39729359-CC5B-445A-B8BA-51BDD6756DFD"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.2\))
Subject: Re: Missing File weather.txt
Date: Sat, 12 Jul 2025 00:18:18 +0200
In-Reply-To: <967885b6-aebf-4ff4-b950-a58c9d67587d@oss.nttdata.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
 pgsql-docs@lists.postgresql.org
To: Fujii Masao <masao.fujii@oss.nttdata.com>
References: <158017814191.19852.15019251381150731439@wrigleys.postgresql.org>
 <68FE7D96-3F05-40E3-B3A2-04CE267CF28A@yesql.se>
 <89bd784e-c3ab-4d9e-9be1-0846bd8c260c@oss.nttdata.com>
 <10240.1751736559@sss.pgh.pa.us>
 <4DF3BEAF-EAAA-4C91-92B3-2CA8F022B383@yesql.se>
 <967885b6-aebf-4ff4-b950-a58c9d67587d@oss.nttdata.com>
Archived-At: 
 <https://www.postgresql.org/message-id/D49B15F0-46BA-4D97-9475-BBF28B855214%40yesql.se>
Precedence: bulk


--Apple-Mail=_39729359-CC5B-445A-B8BA-51BDD6756DFD
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=us-ascii

> On 11 Jul 2025, at 01:36, Fujii Masao <masao.fujii@oss.nttdata.com> 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


--Apple-Mail=_39729359-CC5B-445A-B8BA-51BDD6756DFD
Content-Disposition: attachment;
	filename=v3-0001-doc-Add-example-file-for-COPY.patch
Content-Type: application/octet-stream;
	x-unix-mode=0644;
	name="v3-0001-doc-Add-example-file-for-COPY.patch"
Content-Transfer-Encoding: quoted-printable

=46rom=2015f04b455d053087614dfeb9c381143066267057=20Mon=20Sep=2017=20=
00:00:00=202001=0AFrom:=20Daniel=20Gustafsson=20=
<dgustafsson@postgresql.org>=0ADate:=20Fri,=2011=20Jul=202025=2000:03:57=20=
+0200=0ASubject:=20[PATCH=20v3]=20doc:=20Add=20example=20file=20for=20=
COPY=0A=0AThe=20paragraph=20for=20introducing=20INSERT=20and=20COPY=20=
discussed=20how=20a=20file=0Acould=20be=20used=20for=20bulk=20loading=20=
with=20COPY,=20without=20actually=20showing=0Awhat=20the=20file=20would=20=
look=20like.=20=20This=20adds=20a=20programlisting=20for=20the=0Afile=20=
contents.=0A=0ABackpatch=20to=20all=20supported=20branches=20since=20=
this=20example=20has=20lacked=0Athe=20file=20contents=20since=20=
PostgreSQL=207.2.=0A=0AAuthor:=20Daniel=20Gustafsson=20<daniel@yesql.se>=0A=
Reported-by:=20davidhowes@gmail.com=0ADiscussion:=20=
https://postgr.es/m/158017814191.19852.15019251381150731439@wrigleys.postg=
resql.org=0ABackpatch-through:=2013=0A---=0A=20doc/src/sgml/query.sgml=20=
|=2014=20++++++++++++--=0A=201=20file=20changed,=2012=20insertions(+),=20=
2=20deletions(-)=0A=0Adiff=20--git=20a/doc/src/sgml/query.sgml=20=
b/doc/src/sgml/query.sgml=0Aindex=20727a0cb185f..002d2f89fb4=20100644=0A=
---=20a/doc/src/sgml/query.sgml=0A+++=20b/doc/src/sgml/query.sgml=0A@@=20=
-264,8=20+264,18=20@@=20COPY=20weather=20FROM=20=
'/home/user/weather.txt';=0A=20=0A=20=20=20=20=20where=20the=20file=20=
name=20for=20the=20source=20file=20must=20be=20available=20on=20the=0A=20=
=20=20=20=20machine=20running=20the=20backend=20process,=20not=20the=20=
client,=20since=20the=20backend=20process=0A-=20=20=20=20reads=20the=20=
file=20directly.=20=20You=20can=20read=20more=20about=20the=0A-=20=20=20=20=
<command>COPY</command>=20command=20in=20<xref=20linkend=3D"sql-copy"/>.=0A=
+=20=20=20=20reads=20the=20file=20directly.=20=20The=20data=20inserted=20=
above=20into=20the=20weather=20table=0A+=20=20=20=20could=20also=20be=20=
inserted=20from=20a=20file=20containing=20(note=20that=20the=20white=20=
space=0A+=20=20=20=20on=20each=20line=20is=20actually=20a=20tab=20=
character):=0A+=0A+<programlisting>=0A+San=20Francisco=20=20=20=2046=20=20=
=20=2050=20=20=20=200.25=20=20=20=201994-11-27=0A+San=20Francisco=20=20=20=
=2043=20=20=20=2057=20=20=20=200.0=20=20=20=201994-11-29=0A+Hayward=20=20=
=20=2037=20=20=20=2054=20=20=20=20\N=20=20=20=201994-11-29=0A=
+</programlisting>=0A+=0A+=20=20=20=20You=20can=20read=20more=20about=20=
the=20<command>COPY</command>=20command=20in=0A+=20=20=20=20<xref=20=
linkend=3D"sql-copy"/>.=0A=20=20=20=20</para>=0A=20=20=20</sect1>=0A=20=0A=
--=20=0A2.39.3=20(Apple=20Git-146)=0A=0A=

--Apple-Mail=_39729359-CC5B-445A-B8BA-51BDD6756DFD--