$ curl cheat.sh/

--  One way to do this:

 ALTER TABLE domain.old RENAME TO new

--  Other way:

 SET search_path TO domain;
 ALTER TABLE old RENAME TO new;

--  Documentation for [`search_path`][1].
--  
  --  [1]: http://www.postgresql.org/docs/current/static/runtime-config-
--  client.html
--  
--  [Bohuslav Burghardt] [so/q/27787741] [cc by-sa 3.0]

$

Follow @igor_chubin cheat.sh