Hi,
On Wed, Nov 4, 2015 at 1:21 AM, M Tarkeshwar Rao <
[email protected]> 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
