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

Commit721a8bb

Browse files
committed
Correct stdin/stdout usage in COPY .. PROGRAM
The COPY documentation incorrectly stated, for the PROGRAM case,that we read from stdin and wrote to stdout. Fix that, and improveconsistency by referring to the 'PostgreSQL' user instead of the'postgres' user, as is done in the rest of the COPY documentation.Pointed out by Peter van Dijk.Back-patch to 9.3 where COPY .. PROGRAM was introduced.
1 parent5f4f66f commit721a8bb

File tree

1 file changed

+8
-6
lines changed

1 file changed

+8
-6
lines changed

‎doc/src/sgml/ref/copy.sgml

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -71,12 +71,14 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable
7171
<para>
7272
<command>COPY</command> with a file name instructs the
7373
<productname>PostgreSQL</productname> server to directly read from
74-
or write to a file. The file must be accessible to the server and
75-
the name must be specified from the viewpoint of the server. When
76-
<literal>PROGRAM</literal> is specified, the server executes the
77-
given command, and reads from its standard input, or writes to its
78-
standard output. The command must be specified from the viewpoint of the
79-
server, and be executable by the <literal>postgres</> user. When
74+
or write to a file. The file must be accessible by the
75+
<productname>PostgreSQL</productname> user (the user ID the server
76+
runs as) and the name must be specified from the viewpoint of the
77+
server. When <literal>PROGRAM</literal> is specified, the server
78+
executes the given command and reads from the standard output of the
79+
program, or writes to the standard input of the program. The command
80+
must be specified from the viewpoint of the server, and be executable
81+
by the <productname>PostgreSQL</productname> user. When
8082
<literal>STDIN</literal> or <literal>STDOUT</literal> is
8183
specified, data is transmitted via the connection between the
8284
client and the server.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp