Hi all.
I am trying to do the following in plpgsql.
Can someone advise
create table test
(
"Test Column" varchar(10)
);
In the plpgsql function I am trying to update this column.
update test
set "Test Column" = ''test data'';
The function fails with
Error: Error while executing the query;
ERROR: unterminated " in name "Test
(State:S1000, Native Code: 1)
It works fine if the column name is "TestColumn" but not "Test Column".
Thanks
Andrew