Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitf6ffbed

Browse files
doc: Add example file for COPY
The paragraph for introducing INSERT and COPY discussed how a filecould be used for bulk loading with COPY, without actually showingwhat the file would look like. This adds a programlisting for thefile contents.Backpatch to all supported branches since this example has lackedthe file contents since PostgreSQL 7.2.Author: Daniel Gustafsson <daniel@yesql.se>Reviewed-by: Fujii Masao <masao.fujii@oss.nttdata.com>Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>Discussion:https://postgr.es/m/158017814191.19852.15019251381150731439@wrigleys.postgresql.orgBackpatch-through: 13
1 parent5e6e42e commitf6ffbed

File tree

1 file changed

+12
-2
lines changed

1 file changed

+12
-2
lines changed

‎doc/src/sgml/query.sgml

Lines changed: 12 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -264,8 +264,18 @@ COPY weather FROM '/home/user/weather.txt';
264264

265265
where the file name for the source file must be available on the
266266
machine running the backend process, not the client, since the backend process
267-
reads the file directly. You can read more about the
268-
<command>COPY</command> command in <xref linkend="sql-copy"/>.
267+
reads the file directly. The data inserted above into the weather table
268+
could also be inserted from a file containing (values are separated by a
269+
tab character):
270+
271+
<programlisting>
272+
San Francisco 46 50 0.25 1994-11-27
273+
San Francisco 43 57 0.0 1994-11-29
274+
Hayward 37 54 \N 1994-11-29
275+
</programlisting>
276+
277+
You can read more about the <command>COPY</command> command in
278+
<xref linkend="sql-copy"/>.
269279
</para>
270280
</sect1>
271281

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp