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 7AA0753ABB for ; Thu, 7 Apr 2005 12:41:46 +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 38107-01 for ; Thu, 7 Apr 2005 11:41:37 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 17B7E53AA5 for ; Thu, 7 Apr 2005 12:41:36 +0100 (BST) Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R) with ESMTP id md50000590308.msg for ; Thu, 07 Apr 2005 04:41:56 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" Subject: Table PARTITION Date: Thu, 7 Apr 2005 17:08:54 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0003_01C53B94.8A40AC60" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcU7Y1MglmkdaBPOSe2W4GvFHS3sUA== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Thu, 07 Apr 2005 04:41:56 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-MDAV-Processed: mail.secf.com, Thu, 07 Apr 2005 04:42:00 -0700 Message-Id: <20050407114136.17B7E53AA5@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.536 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE, MSGID_FROM_MTA_ID, UPPERCASE_25_50 X-Spam-Level: * X-Archive-Number: 200504/71 X-Sequence-Number: 20964 This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C53B94.8A40AC60 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 Regards Dinesh Pandey ---------------------------------------------------------------------------- ------ Dinesh Pandey Sr. Software Engineer Second Foundation (India) Pvt. Ltd. Plot# 52 Industrial Area, Phase II Chandigarh. (India) PH: (O) 0172-2639202, Extn: 233 ------=_NextPart_000_0003_01C53B94.8A40AC60 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Table PARTITION

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

Regards
Dinesh Pandey


------------------------------------------------------------------= ----------------
Dinesh = Pandey 
Sr. Software = Engineer

Second Foundation (India) Pvt. Ltd.
Plot# 52
Industrial Area, Phase II
Chandigarh. (India)
PH: (O) 0172-2639202, Extn: 233

------=_NextPart_000_0003_01C53B94.8A40AC60--