On 08/27/2011 11:46 PM, Fernando Hevia wrote:
> Not sure if available in v1.12 but in 1.14 you can change the quote
> character at your leisure from File -> Options -> Query tool -> "Result
> copy quote character".
>
> Cheers.
>
> On Sat, Aug 27, 2011 at 10:58, Colin Beckingham <colbec@start.ca
> <mailto:colbec@start.ca>> wrote:
>
> Using Opensuse 11.4 Kernel 3.0, pgadmin 1.12.3
>
> In the query tool, ctrl-C from a highlighted record in a result set
> produces a
> string which quotes strings with double quotes. Postgresql does not
> seem to
> like double quotes in, say, insert requests, so when you build a new
> insert
> request by pasting the clip into a new statement, before the insert
> works the
> double quotes have to be changed to single quotes, then it works.
>
> Would it be possible to have the clip from the result set quoted
> with single
> quotes, or is there a reason this should not happen?
>
> --
> Sent via pgadmin-support mailing list
> (pgadmin-support@postgresql.org <mailto:pgadmin-support@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>
Thanks, this is exactly what I was looking for. Works like a charm.
--
---
Colin Beckingham