X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C205B53205 for ; Thu, 7 Apr 2005 13:06:37 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45095-07 for ; Thu, 7 Apr 2005 12:06:29 +0000 (GMT) Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by svr1.postgresql.org (Postfix) with ESMTP id D489B53A91 for ; Thu, 7 Apr 2005 13:06:27 +0100 (BST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-30.mail.demon.net with esmtp (Exim 4.42) id 1DJVmI-000NFa-0q; Thu, 07 Apr 2005 12:06:30 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id BD30716AC6; Thu, 7 Apr 2005 13:06:27 +0100 (BST) Message-ID: <42552244.5050603@archonet.com> Date: Thu, 07 Apr 2005 13:06:28 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: dpandey@secf.com Cc: 'PostgreSQL' Subject: Re: Table PARTITION References: <20050407114136.17B7E53AA5@svr1.postgresql.org> In-Reply-To: <20050407114136.17B7E53AA5@svr1.postgresql.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.059 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/72 X-Sequence-Number: 20965 Dinesh Pandey wrote: > How can we create oracle's table with partition in Postgres. (How to create > Table partion in postgres) > > CREATE TABLE invoices > (invoice_no NUMBER NOT NULL, > invoice_date DATE NOT NULL, > comments VARCHAR2(500)) > > PARTITION BY RANGE (invoice_date) > (PARTITION invoices_q1 VALUES LESS THAN (TO_DATE('01/04/2001', > 'DD/MM/YYYY')) TABLESPACE users By hand, I'm afraid (although I think people are looking into this feature for version 8.1) There's lots of discussion in the mail archives about how people are handling this. You're basically looking at some combination of - partial/conditional indexes - unions - inheritance -- Richard Huxton Archonet Ltd