blob: 7f8c3282f5de0ef8321cffbc2c77d4655ec7920a [file] [log] [blame]
SELECT 0::int as sid,
s.starelid,
c.relname as starelname,
s.staattnum,
a.attname as staattname,
s.stainherit,
s.stanullfrac,
s.stawidth,
s.stadistinct,
s.stakind1,
s.stakind2,
s.stakind3,
s.stakind4,
s.stakind5,
s.staop1,
s.staop2,
s.staop3,
s.staop4,
s.staop5,
s.stanumbers1,
s.stanumbers2,
s.stanumbers3,
s.stanumbers4,
s.stanumbers5,
s.stavalues1::TEXT,
s.stavalues2::TEXT,
s.stavalues3::TEXT,
s.stavalues4::TEXT,
s.stavalues5::TEXT
FROM pg_statistic s, pg_class c, pg_namespace n, pg_attribute a
WHERE n.nspname NOT IN ('pg_catalog', 'pg_toast', 'information_schema')
AND n.oid = c.relnamespace
AND c.oid = s.starelid
AND a.attnum = s.staattnum
AND a.attrelid = s.starelid;