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