Re: Query regarding

Le 4 nov. 2015 10:23 AM, "M Tarkeshwar Rao" <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>
a écrit :
>
> 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
> INITRANS 1
> MAXTRANS 255
> STORAGE (
> INITIAL 5M
> NEXT 5M
> MINEXTENTS 1
> MAXEXTENTS UNLIMITED
> PCTINCREASE 0
> BUFFER_POOL DEFAULT
> )
> LOGGING
> NOCOMPRESS
> 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.
>

Those are really specific to oracle. The only exception is pctfree. It's
called fillfactor in PostgreSQL and is the opposite of pctfree (as in if
pctfree is 10%, fillfactor is 90%).