Postgres Pro
Downloads
Home   >   mailing lists

Bulk load straight into partitioned table? - Mailing list pgsql-novice

From Danny Lo
Subject Bulk load straight into partitioned table?
Date
Msg-id AANLkTikidmul710MpXL2jJH1Smq9yZBdMDzX2crGwcmv@mail.gmail.com
Whole thread Raw
Responses Re: Bulk load straight into partitioned table?  (Joshua Tolley <eggyknap@gmail.com>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Copy function - how to move text types across
Next
From: Joshua Tolley
Date:
Subject: Re: Bulk load straight into partitioned table?