postgresql – Postgres COPY with multiple small chunks

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?