文档首页


postgres=# COPY tbase (id, mc) FROM stdin;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> 1  tbase
>> 2  \N
>> 3  pgxc
>> \.
postgres=# select * from tbase;
 id |  mc   
----+-------
  1 | tbase
  2 | 
  3 | pgxc
(3 rows)

注：1 和tbase 之间不是空格，而是tab符