| From: | Dave Page <dpage(at)postgresql(dot)org> |
|---|---|
| To: | Harald Armin Massa <haraldarminmassa(at)gmail(dot)com> |
| Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: enhancement request: on Control-Copy please get correct quotes |
| Date: | 2007-02-12 20:31:18 |
| Message-ID: | 45D0CE96.3000807@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Harald Armin Massa wrote:
> I am using fields of type "inet" to store guids in PostgreSQL.
>
> I can view them quite nice within pgAdmin grids.
>
> when I select a cell, copy its content and paste it into notepad or
> sqlsheet ..., the result is:
>
> "1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9"
>
> with double-quotes. PostgreSQL uses doublequotes only for mixed case
> identifiers, not for data.
>
> So to use that paste in a query like
>
> select foo from bar where barid='1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9'
>
> I have to manually change the quotemarks.
>
>
> It's nice of pgAdmin to ADD quotes, please, also add the right quotes.
See the result copy quoting options:
http://www.pgadmin.org/docs/1.6/options-tab3.html
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jessica Fendos | 2007-02-13 16:04:39 | pgAdminIII not working |
| Previous Message | Harald Armin Massa | 2007-02-12 17:13:16 | enhancement request: on Control-Copy please get correct quotes |