From: | Colin Beckingham <colbec(at)start(dot)ca> |
---|---|
To: | Fernando Hevia <fhevia(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Feature request: copy and quotes |
Date: | 2011-08-30 07:25:47 |
Message-ID: | 4E5C907B.3070502@start.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)start(dot)ca
> <mailto:colbec(at)start(dot)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(at)postgresql(dot)org <mailto:pgadmin-support(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Uckun | 2011-08-30 10:56:30 | feature request |
Previous Message | Guillaume Lelarge | 2011-08-30 07:13:03 | Re: Solaris 10 (64Bit) - Different Behavior on Privileges and Default Privileges Tab Pages of Properties Screen of Database and Schema on pgAdmin III |