Message-ID: <62b2bf013e17f856186efb2989c16ff97befc309.camel@cybertec.at>
Subject: Re: [Minor] Conflicting sentence in "2.4. Populating a Table With
 Rows"
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: =?ISO-8859-1?Q?Matem=E1tica?= A3K <matematica.a3k@gmail.com>, "David G.
 Johnston" <david.g.johnston@gmail.com>, "pgsql-docs@lists.postgresql.org"	
 <pgsql-docs@lists.postgresql.org>
Date: Thu, 01 Oct 2026 10:26:35 +0200
In-Reply-To: 
 <CA+FDnh+c97orQwpMOX9o=tHGFeTX6qi7LUoJCYf0T4mLEX67HA@mail.gmail.com>
References: 
 <179060786814.1026194.11232417502247566920@wrigleys.postgresql.org>
	 <CAKFQuwagiKBv-3t4U_CSGFLC8uDBCwbM9TNW55k=46CfM0EFxw@mail.gmail.com>
	 <CA+FDnhLubC2OR0xs0ZQx=f6xYeqLLQgoq1XeD7p=Qo2Re1-8qg@mail.gmail.com>
	 <CA+FDnh+c97orQwpMOX9o=tHGFeTX6qi7LUoJCYf0T4mLEX67HA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/62b2bf013e17f856186efb2989c16ff97befc309.camel%40cybertec.at>
Precedence: bulk

On Tue, 2026-09-29 at 15:00 -0300, Matem=C3=A1tica A3K wrote:
> > > Yeah, that last part could use some cleanup.=C2=A0 I=E2=80=99d probab=
ly rewrite it using csv though instead of tab-delimited so as to remove the=
 need for a parenthetical.
> > >=20
> > > David J.
> =C2=A0
> I'm attaching the patch although without the format that Laurenz used (no=
t sure if it is needed though).
>=20
> It fixes the problem and removes the parenthetical, do you think is OK?

No issue with the format of the patch, but with the content.

The COPY statement uses the default tab-separated TEXT format, so your CSV =
data
wouldn't work with it.

The wording in the documentation is confusing, because it does not indicate
that the file below belongs to the COPY statement above.

I think this should read:

  You could also have used COPY to load large amounts of data from flat-tex=
t files. [...]
  An example would be:

     COPY weather FROM '/home/user/weather.txt';

  where the file name for the source file must be available on the machine =
running the
  backend process, not the client, since the backend process reads the file=
 directly.
  The file used in the <command>COPY</command> statement above could look a=
s follows
  (the values are separated by a tab character):

     San Francisco	46	50	0.25	1994-11-27
     San Francisco	43	57	0.0	1994-11-29
     Hayward	37	54	\N	1994-11-29

Yours,
Laurenz Albe