I am getting an error when I try to insert an alphanumeric value into a TEXT column in a Postgres DB. This is the table definition ]1 This is the query I am using to insert data into the table This is the error message I get ERROR: syntax error at or near “a0032000947363339343638” LINE 12: 55.204773, 40.000000, 1a00320009473633… When
Tag: string-constant
cannot get simple PostgreSQL insert to work
I’m trying to do a simple insert into a postgres table, but am getting an error that the value I’m trying to insert is being interpreted as a column name Where id is set up to be the primary key, and auto increment, and not null. Those are the boxes I ticked when I set up the table in phpPgAdmin.