I am using fields of type "inet" to store guids in PostgreSQL.<br /><br />I can view them quite nice within pgAdmin
grids.<br/><br />when I select a cell, copy its content and paste it into notepad or sqlsheet ..., the result is: <br
/><br/>"1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9"<br /><br />with double-quotes. PostgreSQL uses doublequotes only for
mixedcase identifiers, not for data.<br /><br />So to use that paste in a query like<br /><br />select foo from bar
wherebarid='1ec9:7dfa:eb54:4755:96db:e1bf:9404:3aa9' <br /><br />I have to manually change the quotemarks. <br /><br
/><br/>It's nice of pgAdmin to ADD quotes, please, also add the right quotes.<br /><br />Harald<br /><br /><br
clear="all"/><br />-- <br />GHUM Harald Massa<br />persuadere et programmare <br />Harald Armin Massa<br
/>Reinsburgstraße202b<br />70197 Stuttgart<br />0173/9409607<br />fx 01212-5-13695179 <br />-<br />Python: the only
languagewith more web frameworks than keywords.
