<![CDATA[Forum PostgreSQL - function for search string in all table of a particular schema ? (post]]> https://forum.postgresql.org.pl/viewtopic.php?id=1407 Fri, 12 Oct 2012 23:50:58 +0000 PunBB <![CDATA[Odp: function for search string in all table of a particular schema ? (post]]> https://forum.postgresql.org.pl/viewtopic.php?pid=3754#p3754 Fri, 12 Oct 2012 23:50:58 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3754#p3754 <![CDATA[function for search string in all table of a particular schema ? (post]]> https://forum.postgresql.org.pl/viewtopic.php?pid=3752#p3752 0) then return 'l'; else return '2572'; end if; end loop; END; $BODY$ LANGUAGE plpgsql VOLATILE COST 100; in output i need all tables in which string exists : like table_name count_of_string_match]]> Thu, 11 Oct 2012 14:04:24 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3752#p3752