[GENERAL] \copy only select rows

[Ow Mun Heng]

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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend