Re: Query regarding

[dinesh kumar <dineshkumar02@xxxxxxxxx>]

Hi,

On Wed, Nov 4, 2015 at 1:21 AM, M Tarkeshwar Rao <m.tarkeshwar.rao@xxxxxxxxxxxx> wrote:

Hi all,

 

We have started to convert some oracle sql scripts and converting them to postgres, but facing some issues to create table.

 

I have some common doubts in create table script ie.

 

ALTER TABLE employee

DROP PRIMARY KEY CASCADE;

 

DROP employee CASCADE CONSTRAINTS;

 

CREATE TABLE employee

(

  LABEL_IMP  VARCHAR2(50 BYTE)

)

TABLESPACE DATA_TB

PCTUSED    0

PCTFREE    10

We need to use FILLFACTOR, which is an opposite setting of PCTFREE.

INITRANS   1

MAXTRANS   255

STORAGE    (

            INITIAL          5M

            NEXT             5M

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

LOGGING

Default is LOGGED. We can specify UNLOGGED if we do not want to log trx into WAL.

 

NOCOMPRESS

Postgres supports column level storage support.

SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }

NOCACHE

 

NOPARALLEL

MONITORING;

 

 

I am trying to find replacement for above keywords highlighted in BOLD in postgres, but unable to find it on google.

Could you please let us know if these parameter are managed internally in postgres or what are the alternative.

 

Regards,

Tarkeshwar

 

--

Regards,

Dinesh

manojadinesh.blogspot.com