Oracle veteran here, new to postgres. As an example, I have a table defined as (col1 varchar(10),col2 inteter,col3 varchar(20). I issue this statement from the Query Tool in pgadmin:
insert into tablename values(‘First Name’,23,’Last Name’);
and I get these messages:
ERROR: Array value must start with “{” or dimension information.malformed array literal: “First Name”
ERROR: malformed array literal: “First Name”
SQL state: 22P02
Detail: Array value must start with “{” or dimension information.
Character: 28
As far as I know, I haven’t said anything about an array. I just want to insert 3 fields as 1 row of data. Every “insert into” example I’ve found, including using a .csv file, seem straightforward and work fine. Not for me! Am I doing something wrong syntactically or what?
I tried what the examples suggested, expecting it to work.
user24714292 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.