plpgsql question - Mailing list pgsql-general

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