backup and recover the contents of the

<link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link>

table. The <function>dump_statistic</> function generates <literal>INSERT</>

statements which can later be applied to a compatible database. The extension

statistical data since these statements heavily rely on the provided functions.

</para>

<para>

Note that the definition of the

<link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link>

table might change occasionally, which means that generated dump might be incompatible

with future releases of PostgreSQL.

per each tuple of the

<link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link>,

excluding the ones that contain statistical data for tables in the

<literal>information_schema</> and <literal>pg_catalog</> schemas.

</para>

<para>

The <literal>INSERT</> statement takes form of

<screen>

WITH upsert as (

UPDATE pg_catalog.pg_statistic SET %s

WHERE to_schema_qualified_relation(starelid) = relname

AND to_attname(relname, staattnum) = attname

AND to_atttype(relname, staattnum) = atttype

AND stainherit = r.stainherit

RETURNING *)

ins as (

SELECT %s

WHERE NOT EXISTS (SELECT * FROM upsert)

AND to_attnum(relname, attname) IS NOT NULL

AND to_atttype(relname, attname) = atttype)

INSERT INTO pg_catalog.pg_statistic SELECT * FROM ins;

</screen>

per each tuple of the

<link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link>,

excluding the ones that do not relate to the tables in

<literal>schema_name</> schema.

per each tuple of the

<link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link>,

excluding the ones that do not relate to the specified

<literal>"schema_name.table_name"</> table.

Returns the element type of the given array as <literal>oid</>.

Given a relation name and a column number, returns the column name

as <literal>text</>.

Given a relation name and a column name, returns the column number

as <literal>int2</>.

Given a relation name and a column name, returns the column type

as <literal>text</>.

function returns the <literal>oid</> of the given schema.

<function>get_namespace</function> returns the schema

of the given relation as <literal>oid</>.