On Tuesday 2025-08-26 22:31, David G. Johnston wrote:
>The logical dump has no ordering - it will come out however it comes out. "COPY <table> TO ..." doesn't have an order
byclause - there is no way to make or communicate to it that ordering is important. For adhoc work you can use "COPY
<query>TO ..." and put and order by in the query.
Thank you, so it's not possible currently.
How would "COPY <query> TO" behave for copying very large tables?
Would it make sense to optionally have that in pg_dump?
Or would it make sense as a new feature, to optionally order "COPY
<table> TO ..." based on primary key where available, and use that in
pg_dump option?
Dimitris
