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.

Reply via email to