jitscar · March 7, 2019 11:57
diff --git a/clean_data_postgre.sql b/clean_data_postgre.sql
 do
 $$
 declare
  l_stmt text;
 begin
  select 'TRUNCATE ' || string_agg(format('%I.%I', schemaname, tablename), ',')
    into l_stmt
  from pg_tables
  where schemaname in ('public', 'sources');

  execute l_stmt || ' CASCADE';
 end;
 $$
	do
	$$
	declare
	l_stmt text;
	begin
	select 'TRUNCATE ' \|\| string_agg(format('%I.%I', schemaname, tablename), ',')
	into l_stmt
	from pg_tables
	where schemaname in ('public', 'sources');

	execute l_stmt \|\| ' CASCADE';
	end;
	$$