> > > Does anybody have a function lying around (preferably pl/pgsql) that > > > takes a table name and returns coverage counts? > > > > What is "coverage count"? Ah, I should have explained better. I meant how much of a column is null. Basically you have to 0. count how many total records in a table 1. discover the column names in a table 2. for each column name, count how many nulls and subtract from total count If nobody has one written, I'll write one and blog it. Thanks! Seamus PS. In a similar vein, we published http://blog.faraday.io/how-to-do-histograms-in-postgresql/ which gives plpsql so you can do: SELECT * FROM histogram($table_name_or_subquery, $column_name) -- Seamus Abshere, SCEA https://www.faraday.io https://github.com/seamusabshere https://linkedin.com/in/seamusabshere -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
