| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Matemática A3K <matematica(dot)a3k(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [Minor] Conflicting sentence in "2.4. Populating a Table With Rows" |
| Date: | 2026-10-01 08:26:35 |
| Message-ID: | 62b2bf013e17f856186efb2989c16ff97befc309.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matemática A3K | 2026-10-01 14:23:14 | Re: [Minor] Conflicting sentence in "2.4. Populating a Table With Rows" |
| Previous Message | PG Doc comments form | 2026-09-30 20:56:45 | Improve "3.5. Window Functions" tutorial |