| From: | "Dinesh Pandey" <dpandey(at)secf(dot)com> |
|---|---|
| To: | "'PostgreSQL'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Table PARTITION |
| Date: | 2005-04-07 11:38:54 |
| Message-ID: | 20050407114136.17B7E53AA5@svr1.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-04-07 12:06:28 | Re: Table PARTITION |
| Previous Message | Markus Schaber | 2005-04-07 11:36:55 | Re: [despammed] Crosstab function |