Bulk load straight into partitioned table?

From: Danny Lo <lo(dot)dannyk(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Bulk load straight into partitioned table?
Date: 2010-05-19 22:13:13
Message-ID: AANLkTikidmul710MpXL2jJH1Smq9yZBdMDzX2crGwcmv@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have about 150gb data that I'd like to bulk load into a table partitioned
by month. I'm wondering if I could use the COPY command with a trigger on
table to copy this in directly?
At the moment, I'm doing:

copy command into table_x

then sql command:

insert into master_table_a
select * from table_x

thanks,
Danny

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joshua Tolley 2010-05-20 03:06:10 Re: Bulk load straight into partitioned table?
Previous Message Jasen Betts 2010-05-19 11:01:55 Re: Copy function - how to move text types across