Re: using COPY and PARTITON

From: Wojtek <foo(at)twine(dot)pl>
To: cjm1010 <cjm1010(at)naver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: using COPY and PARTITON
Date: 2009-08-10 07:07:14
Message-ID: 4A7FC722.6030102@twine.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'd recommend coping directly to child tables (partitions). It's much
faster.

Regards,
foo

Scott Marlowe wrote:
> I believe triggers can do it.
>
> On Sun, Aug 9, 2009 at 11:15 PM, cjm1010<cjm1010(at)naver(dot)com> wrote:
>
>> hi~
>>
>> I want to insert DATA by using the COPY making PARTITON TABLE. By the way,
>> DATA is inserted only in PARENT TABLE.
>> Can DATA be inserted in CHILD TABLE by using the COPY?
>>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2009-08-10 07:57:30 Re: psql crashing - don't know why
Previous Message cjm1010 2009-08-10 06:58:11 Re: using COPY and PARTITON