Advertisement
joaofabioma

teste GENERATED IDENTITY

May 25th, 2022
1,102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Table: tipos.tbl_
  2.  
  3. -- DROP TABLE IF EXISTS tipos.tbl_;
  4.  
  5. CREATE TABLE IF NOT EXISTS tipos.tbl_
  6. (
  7.     id_ integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
  8.     col0 integer,
  9.     col1 integer,
  10.     col2 integer,
  11.     col3 integer,
  12.     col4 integer,
  13.     col5 integer,
  14.     col6 integer,
  15.     col7 integer,
  16.     col8 integer,
  17.     col9 integer,
  18.     CONSTRAINT tbl__pkey PRIMARY KEY (id_)
  19. )
  20.  
  21. TABLESPACE pg_default;
  22.  
  23. ALTER TABLE IF EXISTS tipos.tbl_
  24.     OWNER to postgres;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement