\copy combine with SELECT

["jia ding" <dingjia@xxxxxxxxx>]

Hi all,

I tried: 
select id, name  into table2   from table1;
 \copy table2 to filename.txt 
in order to export 2 columns from table1 to a file.

But, I am thinking, if there is a command can combine these two command together?
Maybe, something like: \copy select id,name  from table  to filename.txt 

?

Nina