joaofabioma

table estado

May 25th, 2022 (edited)
462
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Table: cep.estado
  2.  
  3. -- DROP TABLE IF EXISTS cep.estado;
  4.  
  5. CREATE TABLE IF NOT EXISTS cep.estado
  6. (
  7.     id SERIAL NOT NULL,
  8.     nome character varying COLLATE pg_catalog."default",
  9.     uf character varying(2) COLLATE pg_catalog."default",
  10.     CONSTRAINT estado_pkey PRIMARY KEY (id),
  11.     CONSTRAINT estado_uf_key UNIQUE (uf)
  12. )
  13.  
  14. TABLESPACE pg_default;
  15.  
  16. ALTER TABLE IF EXISTS cep.estado
  17.     OWNER to postgres;
Add Comment
Please, Sign In to add comment