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-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?
Use a text[] for your copy of the stavalues* columns. Yours, Laurenz Albe
