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@xxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
