Re: ALTER STATISTIC and dump ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hervé Piedvache <herve(at)elma(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ALTER STATISTIC and dump ?
Date: 2003-01-31 19:09:02
Message-ID: 21049.1044040142@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-15?q?Herv=E9=20Piedvache?= <herve(at)elma(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Tkach 2003-01-31 19:30:46 Query performance PLEASE HELP
Previous Message Tom Lane 2003-01-31 19:06:23 Re: limited field duplicates