Userland copy of pg_statistic - is there a solution?
Vinícius Abrahão <vinnix.bsd@gmail.com>
From: Vinícius Abrahão <vinnix.bsd@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2024-09-30T07:31:06Z
Lists: pgsql-general
Morning, postgres=# create table backup_pg_statistic as select * from pg_statistic; 2024-09-30 08:25:56 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] ERROR: column "stavalues1" has pseudo-type anyarray 2024-09-30 08:25:56 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] STATEMENT: create table backup_pg_statistic as select * from pg_statistic; ERROR: column "stavalues1" has pseudo-type anyarray Time: 9.544 ms postgres=# create table test_array(a anyarray); 2024-09-30 08:26:40 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] ERROR: column "a" has pseudo-type anyarray 2024-09-30 08:26:40 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] STATEMENT: create table test_array(a anyarray); ERROR: column "a" has pseudo-type anyarray Time: 9.137 ms Is there a solution for this simple problem? Cheers, Vinícius