In postgres, we can do COPY to export the data into file. But all the data will be saved into a file. But I want to chunk that file into small files. We can do this after the export.
But is there a way to export it during the COPY process?
OR in psycopg2 can we do this?