Table Partition - Mailing list pgsql-general

From Dinesh Pandey
Subject Table Partition
Date
Msg-id 20050422105502.1E521534FB@svr1.postgresql.org
Whole thread Raw
Responses Re: Table Partition  (Scott Marlowe <smarlowe@g2switchworks.com>)
List 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

 

pgsql-general by date:

Previous
From: "David Roussel"
Date:
Subject: Re: Table modifications with dependent views - best
Next
From: Michael Fuhr
Date:
Subject: Re: Table modifications with dependent views - best practices?