Re: ALTER STATISTIC and dump ? - Mailing list pgsql-general

From Tom Lane
Subject Re: ALTER STATISTIC and dump ?
Date
Msg-id 21049.1044040142@sss.pgh.pa.us
Whole thread Raw
In response to ALTER STATISTIC and dump ?  (Hervé Piedvache <herve@elma.fr>)
List pgsql-general
=?iso-8859-15?q?Herv=E9=20Piedvache?= <herve@elma.fr> writes:
> I just want to know if the command :
> ALTER TABLE [ ONLY ] table [ * ]
> � � �ALTER [ COLUMN ] column SET STATISTICS integer
> is also applied after a pg_dumpall, and the integration of the data in a new
> database ?

IIRC, pg_dump 7.3 dumps that, but 7.2 does not.

> How to know if so or not ?

Look in the dump file to see if there are any ALTER SET STATISTICS
commands ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: limited field duplicates
Next
From: Tom Lane
Date:
Subject: Re: Query performance PLEASE HELP