-- Name: to_freq(regclass); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION to_freq(table_ regclass) RETURNS void

    LANGUAGE sql

    AS $_$

-- save data before truncating main table

SELECT util.copy_types_and_data($1, 'pg_temp.__copy');

-- repopulate main table w/ copies column

SELECT util.truncate($1);

SELECT util.eval($$ALTER TABLE $$||$1||$$ ADD COLUMN copies bigint NOT NULL$$);

SELECT util.populate_table($1, $$

SELECT (table_).*, copies

FROM (

	SELECT table_, COUNT(*) AS copies

	FROM pg_temp.__copy table_

	GROUP BY table_

) s

$$);

-- delete temp table so it doesn't stay around until end of connection

SELECT util.drop_table('pg_temp.__copy');

$_$;

--