Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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.

In response to

pgadmin-support by date

Next:From: Jessica FendosDate: 2007-02-13 16:04:39
Subject: pgAdminIII not working
Previous:From: Harald Armin MassaDate: 2007-02-12 17:13:16
Subject: enhancement request: on Control-Copy please get correct quotes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group