Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE xxx.documentstate (
- iddoc int8 NOT NULL DEFAULT nextval('xxx.document_state_iddoc_seq'::regclass),
- documento uuid NULL,
- idstate int8 NULL,
- iduser int4 NULL,
- idprocessor int8 NULL,
- datecreate timestamp NULL,
- usercreate varchar NULL,
- datemodifie timestamp NULL,
- usermodifie varchar NULL,
- datestate timestamp NULL,
- iddocuments int8 NULL,
- requestc int8 NULL,
- details varchar NULL
- ) PARTITION BY RANGE (datecreate)
- WITH (
- OIDS = FALSE,
- toast.autovacuum_enabled = TRUE
- )
- TABLESPACE pg_default;
- ALTER TABLE xxx.documentstate
- OWNER to postgres;
- CREATE INDEX idx_documentstatedatecreated201601 ON xxx.documentstate201601 USING btree (date_created);
- CREATE INDEX idx_documentstate_id_docu201601 ON xxx.documentstate201601 USING btree (iddoc);
- CREATE INDEX ind_documentstate_id_documents201601 ON xxx.documentstate201601 USING btree (iddocuments);
- CREATE INDEX ind_documentstate_id_state201601 ON xxx.documentstate201601 USING btree (idstate);
- CREATE INDEX ind_documentstate_id_state_brin201601 ON xxx.documentstate201601 USING brin (idstate);
Add Comment
Please, Sign In to add comment