On Mon, 2024-09-30 at 08:31 +0100, Vinícius Abrahão wrote:
> 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-typeanyarray
> 2024-09-30 08:25:56 BST [7400]: user=vinnix,db=postgres,app=psql,client=[local] STATEMENT: create table
backup_pg_statisticas 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?
Use a text[] for your copy of the stavalues* columns.
Yours,
Laurenz Albe
