Guest User

Untitled

a guest
Jan 17th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. sql := 'CREATE TABLE public.t_'||nombretabla||'('||nombre_id||' numeric NOT NULL DEFAULT NEXTVAL ("public"."sec_' || nombretabla||'"), CONSTRAINT pk_' ||nombretabla||' PRIMARY KEY ('||nombre_id||' ) )
  2. WITH ( OIDS=FALSE); ALTER TABLE public.t_'||nombretabla||' OWNER TO postgres;';
  3.  
  4. execute sql;
Add Comment
Please, Sign In to add comment