[GENERAL] How to update stavaluesN columns in pg_statistics (type anyarry)

[Keith Hayden]

Hi,

I need to spoof statistics, and so need to update the stavaluesN columns in
pg_statistics, which are of type anyarray. Can this be done using an UPDATE
statement ? I have tried using array[...] and '{...}' syntax with no luck.
Any other ideas as to how to achieve this ?

Thanks,
Keith.