Table Partition

From: "Dinesh Pandey" <dpandey(at)secf(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Table Partition
Date: 2005-04-22 10:51:52
Message-ID: 20050422105502.1E521534FB@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How to create this table (with partition) in Postgres.

--ORACLE

CREATE TABLE A (col1 NUMBER NOT NULL,

col2 DATE NOT NULL,

col3 VARCHAR2(500)

)

PARTITION BY RANGE (col2) (

PARTITION partition_one VALUES LESS THAN
(TO_DATE('01/04/2001', 'DD/MM/YYYY')) TABLESPACE MYTABSPACE

);

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-04-22 11:11:21 Re: Table modifications with dependent views - best practices?
Previous Message David Roussel 2005-04-22 10:34:29 Re: Table modifications with dependent views - best