\copy combine with SELECT - Mailing list pgsql-general

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