\copy only select rows

Is there a way to do a dump of a database using a select statement?

eg: \copy trd to 'file' select * from table limit 10