This convenience function lets you query stats by table and column name (as opposed to using numeric IDs) (PostgreSQL, PL/pgSQL)

get_column_stats.sql

CREATE OR REPLACE FUNCTION stats(my_table text, my_column text) RETURNS SETOF pg_statistic AS $$
DECLARE
    my_relid oid := (SELECT oid FROM pg_class WHERE relname = my_table);
    my_attnum smallint := (SELECT attnum FROM pg_attribute WHERE attrelid = my_relid AND attname = my_column);
BEGIN
    RETURN QUERY SELECT * FROM pg_statistic WHERE starelid = my_relid AND staattnum = my_attnum;
END;
$$ LANGUAGE plpgsql;