COPY and partitioning

[Colton A Smith <smith@xxxxxxxxxx>]

Hi

  I understand v8.1 implements table partitioning.  Very exciting!

  I have a big table (30 G) that is a real headache.  I'd like to 
partition it.  My plan is the following: (1) use pg_dump -t to
dump the data; (2) create a partitioning schema with check constraints;
and (3) repopulate using the COPY utility.

  My question: does the COPY utility consult check constraints
before populating tables?

  Thanks as always.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend