>If I understand correctly, COPY TO can't copy related fields from other tables, or, for that matter, any expression. Of course, I can use SELECT - SQL, but that won't respect the filter and sort order of the currently selected table.
>
>Any ideas?

You can use current filter as WHERE clause and current order as ORDER BY clause in the query.