Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Re: enhancement request: on Control-Copy please get correct quotes

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



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.



Home | Main Index | Thread Index

top