test=# create table wuchermann (i int);
CREATE TABLE
test=*# copy wuchermann from stdin;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> 1
>> 2
>> 3
>> 4
>> 5
>> 6
>> 7
>> 8
>> 9
>> \.
test=*# UPDATE wuchermann set i=i+1 where i > 5;
UPDATE 4
test=*# select * from wuchermann order by i;
i
----
1
2
3
4
5
7
8
9
10
(9 rows)