ALTER TABLE myschema.distributors SET SCHEMA yourschema;
SELECT table_schema,table_name FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE' AND table_schema='public' ORDER BY table_name
-- Tablolar icin dynamic script hazirlama ============================================
SELECT 'ALTER TABLE '||table_schema||'."'||table_name||'" SET SCHEMA "tempats";' FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE' AND table_schema='public' AND table_name NOT IN ('CompanyUserTransactionLogType')
