Search Postgresql Archives

Re: using COPY and PARTITON

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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?


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux