Обсуждение: enhancement request: on Control-Copy please get correct quotes

Поиск
Список
Период
Сортировка

enhancement request: on Control-Copy please get correct quotes

От
"Harald Armin Massa"
Дата:
I am using fields of type "inet" to store guids in PostgreSQL.<br /><br />I can view them quite nice within pgAdmin
grids.<br/><br />when I select a cell, copy its content and paste it into notepad or sqlsheet ..., the result is: <br
/><br/>"1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9"<br /><br />with double-quotes. PostgreSQL uses doublequotes only for
mixedcase identifiers, not for data.<br /><br />So to use that paste in a query like<br /><br />select foo from bar
wherebarid='1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9' <br /><br />I have to manually change the quotemarks. <br /><br
/><br/>It's nice of pgAdmin to ADD quotes, please, also add the right quotes.<br /><br />Harald<br /><br /><br
clear="all"/><br />-- <br />GHUM Harald Massa<br />persuadere et programmare <br />Harald Armin Massa<br
/>Reinsburgstraße202b<br />70197 Stuttgart<br />0173/9409607<br />fx 01212-5-13695179 <br />-<br />Python: the only
languagewith more web frameworks than keywords.  

Re: enhancement request: on Control-Copy please get correct quotes

От
Dave Page
Дата:
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.