From: Dinesh Pandey <dpandey@secf.com>
To: 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: Table PARTITION
Date: Thu, 7 Apr 2005 17:08:54 +0530
Message-ID: <20050407114136.17B7E53AA5@svr1.postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dpandey@secf.com
Subject: Re: Table PARTITION
In-Reply-To: <20050407114136.17B7E53AA5@svr1.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox