agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: Laurenz Albe <laurenz.albe@cybertec.at>
To: Matemática A3K <matematica.a3k@gmail.com>
To: David G. Johnston <david.g.johnston@gmail.com>
To: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: [Minor] Conflicting sentence in "2.4. Populating a Table With Rows"
Date: Thu, 01 Oct 2026 10:26:35 +0200
Message-ID: <62b2bf013e17f856186efb2989c16ff97befc309.camel@cybertec.at> (raw)
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>
On Tue, 2026-09-29 at 15:00 -0300, Matemática A3K wrote:
> > > Yeah, that last part could use some cleanup. I’d probably rewrite it using csv though instead of tab-delimited so as to remove the need for a parenthetical.
> > >
> > > David J.
>
> I'm attaching the patch although without the format that Laurenz used (not sure if it is needed though).
>
> 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-text 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 as 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
view thread (7+ messages) latest in thread
Message-ID: <62b2bf013e17f856186efb2989c16ff97befc309.camel@cybertec.at>
Permalink: ../62b2bf013e17f856186efb2989c16ff97befc309.camel@cybertec.at/
Also on: postgresql.org/message-id/62b2bf013e17f856186efb2989c16ff97befc309.camel@cybertec.at
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: laurenz.albe@cybertec.at, matematica.a3k@gmail.com, david.g.johnston@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: [Minor] Conflicting sentence in "2.4. Populating a Table With Rows"
In-Reply-To: <62b2bf013e17f856186efb2989c16ff97befc309.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox