Commit4cab43e

committed

docs: clarify handling of column lists in COPY TO/FROM

Previously it was unclear how COPY FROM handled cases where not allcolumns were specified, or if the order didn't match.Reported-by: pavlo.golub@gmail.comDiscussion:https://postgr.es/m/157487729344.7213.14245726713444755296@wrigleys.postgresql.orgBackpatch-through: 9.4

1 parent0af0504 commit4cab43eCopy full SHA for 4cab43e

File tree

-5

lines changed

-5

lines changed

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -61,11 +61,11 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable`
`61`	`61`	`</para>`
`62`	`62`
`63`	`63`	`<para>`
`64`		`- If a listof columnsis specified, <command>COPY</command>will`
`65`		`-only copythe data in the specified columns toor fromthe file.`
`66`		`-If there are any columnsin thetable that are notinthe column list,`
`67`		`-<command>COPY FROM</command> will insert the default values for`
`68`		`-those columns.`
	`64`	`+ If acolumnlist is specified, <command>COPY TO</command>copies only`
	`65`	`+ the data in the specified columns to the file. For <command>COPY`
	`66`	`+FROM</command>, each fieldin thefile is inserted,inorder, into the`
	`67`	`+specified column. Table columns not specified in the <command>COPY`
	`68`	`+FROM</command> column list will receive their default values.`
`69`	`69`	`</para>`
`70`	`70`
`71`	`71`	`<para>`

Comments

(0)