I want to copy query results to a text file and there's an aggregate function in the SELECT expression. One of the aggregate function's parentheses seems to end the \copy() function and I don't know how best to write the statement. A minimal example: \copy(select count_value, sum(count_value) from table_name) to 'output_file.txt'; Do I write sumE'('count_valueE')', sum\(count_value\), or something else? TIA, Rich