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

 

Reply via email to