Re: Inserting additional data into pg_statistics

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Teodor Macicas <teodor(dot)macicas(at)epfl(dot)ch>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Inserting additional data into pg_statistics
Date: 2010-06-19 17:38:01
Message-ID: 8775.1276969081@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Teodor Macicas <teodor(dot)macicas(at)epfl(dot)ch> writes:
> I'm trying to reproduce the pg_statistics catalog from one database
> server to another one.

You can't really, and manually fooling with system catalogs is usually
a bad idea anyway. Just run ANALYZE.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Macicas 2010-06-19 17:49:42 Re: Inserting additional data into pg_statistics
Previous Message M. Bashir Al-Noimi 2010-06-19 15:24:26 Re: Problem serving one-click installer to Syria