jitscar/clean_data_postgre.sql

## 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;
	$$