convert_after_postgres.sql 345 Bytes
DO $$
begin

if exists(select * from information_schema.tables where table_name = 'leading_project_temp')
then
	update sungero_docflow_project as project
	  set leadingproject_project_sungero = tmp.leadingprojectid
	from leading_project_temp as tmp
	where tmp.Id = project.Id;

  drop table leading_project_temp;
end if;

end $$;