On Thu, 2005-11-17 at 09:55 -0500, Colton A Smith wrote:
> My question: does the COPY utility consult check constraints
> before populating tables?
No.
I'd dump it piece by piece using a WHERE clause exactly the same as the
constraints you will use, then reload using COPY into the partitions.
Best Regards, Simon Riggs