Thank you for your reply, Tom.
Why I can't ? And for my purpose is not a bad idea. I mean, I have to do
this and somehow I should find a solution.
In order to use ANALYZE I need the same data on 2nd machine, but the
data is quite large and the only information I need are the statistics
from pg_statistic.
So, why I receive that ERROR and I run the INSERT statement ?
Can anyone tell me where to look into Postgresql source to see how the
engine updates this table ?
Looking forward for reply.
With kindest regards,
Tedy
Tom Lane wrote:
> Teodor Macicas <teodor.macicas@epfl.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
>