Hi Dave!
dpage@postgresql.org wrote:
> Erwin Brandstetter wrote:
>
>> Hi developers! Hi Dave!
>>
>> Testing the new snapshot: pgAdmin III 1.7.0 (Jun 22 2007, rev:
>> 6379:6385). Client Win XP, host: Debian Sarge / PG 8.1.8
>>
>> I have noticed a shortcoming in the edit grid. When I copy a row and
>> insert it as new, the algorithm bails on the first '\n' in a text-field.
>> The rest of the data is not inserted.
>> I guess you have to escape line breaks.
>> BTW, I enter these line breaks by pressing <shift><enter> in Windows.
>>
>
> Hi Erwin,
>
> Copying strings with \n's requires Result Copy Quoting to be enabled. If
> there are no quotes around the strings, we have no way to tell where the
> end is (remember, you can copy multiple rows as well).
>
Yeah, I can confirm that it works alright with Result Copy Quoting
enabled. I could have thought of this myself, actually.
It might be a bit tricky for the run-of-the-mill user, though, to
realize the consequences of this setting.
Would it be helpful to amend the help-text? Like this ..
* *Result copy quoting* - This option specifies how the fields
should be quoted when copied to the clipboard from the result
list. Quoting can be applied to string columns only (i.e. numeric
columns will not be quoted) or all columns regardless of data type.
Disabling this option may prevent copying and pasting rows in the
edit grid from functioning properly if special characters like
line breaks are involved.
Regards
Erwin