| 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: | Whole Thread | Raw Message | 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 |