Hi everyone,
I have a problem with adding a column to an existing table. I want to add
a column named modified which is of datatype TIMESTAMP and has a DEFAULT
CURRENT_TIMESTAMP as it's initial value. I cannot do this with ALTER
TABLE, it tells me to user ALTER TABLE SET DEFAULT instead but I can
> The information you gave is not very helpful.
> An INSERT command, which caused the error, would help.
> Anyway, did you enclose the text by single quotes?
> AFAIK, you do not have to escape double quotes.
>
Found the problem. Yes I enclosed the text in single quotes, and the text
also i
Hi everyone,
I have a column with type text and am trying to pump in a larger amount of
text that has double quotes and also commas in between. I got an error
when I tried to do a simple INSERT. I then tried to escape the double
quote with a backslash but that didn't work. The manual for the 7.1
