Advertisement
Guest User

Untitled

a guest
Mar 8th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Perl 0.18 KB | None | 0 0
  1. ALTER TABLE city DROP CONSTRAINT city_uf_name_uri_key;
  2. ALTER TABLE city ADD UNIQUE (pais, uf, name_uri);
  3.  
  4. update city x
  5. set name_uri = lower(trim(replace(x."name", ' ', '-')) );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement