From: | "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> |
---|---|
To: | "pgAdmin Support" <pgadmin-support(at)postgresql(dot)org> |
Subject: | enhancement request: on Control-Copy please get correct quotes |
Date: | 2007-02-12 17:13:16 |
Message-ID: | 7be3f35d0702120913o74d061a4mcdf9dc94c9954331@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python: the only language with more web frameworks than keywords.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-02-12 20:31:18 | Re: enhancement request: on Control-Copy please get correct quotes |
Previous Message | Raymond O'Donnell | 2007-02-12 14:12:32 | Re: Query (view) question |