On 05/12/2017 08:58 AM, Günce Kaya wrote: > Hello, > > Thank you for your advice. But I did not want to ask about using Copy. I > always use it but my requirement is if there is anyway to export query > result to CSV's different sheets.
CSV != spreadsheet. You can export to CSV using COPY or \copy in psql and then import those into a spreadsheet. If you want something that creates an xls(x) file directly then that is going to require a third party software. I use Python for doing stuff like that. Some programs I use are: