Insert data from table of one schema to another.

 INSERT INTO cynosure.angles SELECT * FROM angles WHERE  city ilike 'KDMC'         

When the schema is public there is noneed to specify it i.e. there is no need to do schemaname.tablename